.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Basic Question on .NET CLR in SQL - Calling a function directly?

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hello, I have been reading up on CLR + SQL integration - My aim is to do an e-mail validation by calling RegEx functionality provided by the CLR.However from what I read and if I understand correct - I would need to create a .NET assembly and load it. I was wondering if there is an option to invoke .NET functions directly from SQL [e.g like create a function and access the .NET classes] . ?C# Fan! ananda84(at)gmail(dot)com

View Complete Post

More Related Resource Links

Some basic MVC question

  1. In regular asp net I can run (debug) the application but I can either "view in browser" that gives me the option to view the application and write code on same time.

In MVC I can't find this option.

  1. What is the basic DATA MODEL for working with SQL DB.

I mean with no any framework (entity framework, Sub sonic, Link to SQL etc')

I look for basic application that works with data but with no fw.

  1. What is the popular DB framework that working with data.
  2.  I am looking on  mvc series


C# Soup To Nuts  (the best series ever)


I watch some of the MVC video, seems that the music store is good but I have to wait to the other part.

Does any one know and recommend   a Microsoft MVC tutorial?





Very Basic Question - Error message running first page


Hi Everyone,

I am running Windows 7 and I have gone into Control Panel and activated all of the IIS Functions.

The web application I am running was downloaded from the net (and has worked on other machines previously).  Once I downloaded it, I moved it into C:/inetpub/wwwroot/code/main.asp

I am a bit of a novice at this!  But I am hoping someone can point me in the right direction!


I get the following error when I try and run the web application through IE:

"An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error."

(When i click the "click here" button it just goes to the IIS site).


Appreciate any help I can get!




way of calling "javascript function of parent window from child window."

The article way of calling "javascript function of parent window from child window." was added by raja.s on Sunday, June 06, 2010.

Hi,Here i am going to explain how to call the javascript function of a parent window from the child window(pop-Up).Some may know before reading this post.Parent Java Script Function:script language="Javascript" type="text/javascript">

Client ID basic question


Hi guys,

Is there any problem to use MANUALLY, within a Javascript, the client ID code?

Like that  ctl00_ContentPlaceHolderConteudo_pgtoiframe


I have one iFrame that need to access div style located in the parent page. So I've done that using manually the clientID code. The code works perfectly and It's still working fine right now.

Will I get errors or problems in the future using it in that manner????

Thank you


Total newbie question: Calling jQuery in an UpdatePanel?



Please forgive this ignorant question - I've used ASP.NET AJAX a good deal but I'm new to jQuery.  Specifically, is it possible to call or create jQuery events on the fly via an UpdatePanel?  For example, calling a jQuery modal or animating a Label (or <div> contained Literal), etc.

If anyone has any advice or could point me to some easy tutorials on mixing ASP.NET AJAX and jQuery, I'd greatly appreciate it. 



Basic question



           I m using VS 2005. When I create a website using VS 2005, it doesnt let me choose the solution folder it automatically creates the folder under My Document. Dont know why. I created website under say C:\Project\MyWebsite.


I have a page, with an image whose source is /image/xyz.gif. So I created a folder image under c:\Project\MyWebsite and have xyz.gif. But the page didnt show the image. If the image path is "image/xyz.gif" then it works. Isnt the directory that you create MyWebsite the root directory?.







Basic question about web services


I followed an example on how to create a simple web service that converts celsius to fahrenheit. It seems to work alright. After the conversion it outputs the new value in xml. What do you do with the value that's in xml? Do you use an Xmlreader to read it from the xml, or what is usually done after the value is generated in xml?


SQL architecure basic question

Hey, I am new to SQL Server or RDBMS. I am a .Net developer. I would like to get SQL Server installed to my PC. I am seeing Microsoft SQL Server 2005 -> Configuration Tools in my Start Menu/Programs, which has server configuration, Error and usage reporting and Surface area configuration. What are they? Is SQL server already installed in my PC? I heard there are management studio but I am not seeing that. what are they? how do they work? any good article links to explain the basics? Thanks. -Jesu Benin.Software Professional

calling a javascript function within aspx

i have a js method i wrote myself called sumAlert();  i want to call it in my aspx like this, when a user clicks on a button<asp:Button ID="Button" runat="server" Text="Submit" OnClientClick="if (confirm('WARNING! You will be unable to save again if you proceed')) sumAlert();"                        OnClick="Button_Click" />How can i get it to call the function if the user confirms OK?

Calling Serverside PageMethod function from an external page Client Side Code ?

there is many examples on the net about this issue .like this :http://sappidireddy.wordpress.com/2008/03/31/how-to-call-server-side-function-from-client-side-code-using-pagemethods-in-aspnet-ajax/But all javascript codes are in same aspx file including codebehind WebMethodsI wantto call a pagemethod from a js which is in another page.something like this : (javascript code but not in same aspx)PageMethods("www.externalpage.com").GetContactName(ctrl.value, CallSuccess, CallFailed, dest)).or calling WebMethods from javascript must only be defined in codebehind with linked aspx fileonly avaible in same aspx ?cant I call a Webmethod in a.aspx from a javascript in b.aspx ?any clue ?thanks.

Basic Encryption Question

I have been looking at ways of encrypting querystrings and I have found a few good examples.. but, I just want some clarification on what is most often referred to as the EncryptionKey and the characters that are in that key....Is there basically an unlimited number of alphanumeric combinations that could be used in the following code as the encryption key, is there anything that someone should be CAREFUL about including in that key?thanks...using System.Security.Cryptography;private static string EncryptionKey = "!#$a54?3";/// other examples: "r0b1nr0y"///in a try-catch:key = System.Text.Encoding.UTF8.GetBytes(EncryptionKey.Substring(0, 8));DESCryptoServiceProvider des = new DESCryptoServiceProvider(); inputByteArray = Convert.FromBase64String(Input);

Quick basic question about TFS 2010

Is TFS a standalone platform or do I need to install SQL Server 2010 first?     Thanks, Joshua

Animation sample and basic XAML question.

I am trying to put into place the animation sample in http://msdn.microsoft.com/en-us/library/system.windows.media.animation.stringkeyframe.keytime.aspx It doesn't work. I have two questions. 1) The example lists both the XAML and the C# code. It doesn't seem that the two are tied together. In this example is the XAML and C# code just two ways of obtaining the same result? 2) When the Rectangle is constructed in the C# code the properties set and the delegate event 'Loaded' asssigned. How is this event triggered? Just for learning purposes I would like to have this rectangle move across the bounds of the application window when triggered and stop again under user control. I am not sure how to construct the restangle then have it tied to my main window. Thank you. Kevin

(basic) DESCENDANTS question (I think) :-)

I am trying to get (first level) DESCENDANTS' aggregation for two different hierarchy types and it seems that for parent-child hierarchies it works fine (first example) however for regular hierarchies (non parent-child) it does not work, returning the same level's data.  Am I missing something basic here? I would really like to get the aggregation working for non parent-child hierarchies but I'm stumped on the syntax or whether it is doable. thx much for any thoughts! Cos   --Adventure Works -- with Parent/Child Hierarchy -- works fine! with member measures.[Rollup Amount] as   Aggregate(Descendants([Account].[Accounts].CurrentMember,                                             1,                                             SELF),[Measures].[Amount]) select {[Measures].[Amount], measures.[Rollup Amount]      } on 0, nonempty([Account].[Accounts].levels(0).members,[Measures].[Amount]) on 1 from [Adventure Works]

Another basic Data Binding question

3 days ago (thanks to Olaf) I was able to make progress with binding a data collection to a DataGrid. Since then I have searched the web in vain for a VB example to enable me to switch off the DataGrid AutoGenerateColumns and enter my own columns and appropriate Paths to the Collection’s properties.   The following code works fine but I can’t work out how to enter my own individual columns etc. Can anyone give me the syntax for an example of one column please?   Why is it so difficult to find VB examples of WPF demos etc? (Nearly everything is in C#.)   I have some experience in Access VB so have picked VB in trying to use WPF. I would be grateful for any links to VB WPF resources. Option Explicit On Option Strict On Imports System.Collections.ObjectModel Partial Public Class DataGrid_FilledFromCodeBehind Private _ocEng As ObservableCollection(Of EnPlayer) Public Property EngSqd() As ObservableCollection(Of EnPlayer) Get Return _ocEng End Get Set(ByVal value As ObservableCollection(Of EnPlayer)) _ocEng = value End Set End Property Private Sub Window_Loaded(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded _ocEng = New ObservableCollection(Of EnPlayer)() For i = 0 To 4 EngSqd.Add(New EnPlayer(ref(i), names(i), ages(i), bat(i))) Next Me.DataCon

How can we show and hide iframes progarmmtically in javascript, calling the function from a seprate

I have currently placed 5 iframes inside 5 divs and i m trying to show and hide iframes by following code if (docid == idpath_array[1])             {                document.all("div1").style.display = 'block';                document.all("div2").style.display = 'none';                document.all("div3").style.display = 'none';                document.all("div4").style.display = 'none';                document.all("div5").style.display = 'none';            } but the problem is that after setting style of one div as display:none,I am not able to display the same div latter by setting display:block hence programmically I am not able to display an already hidden iframe by making display:block in div

Basic Data Access question (ObjectDisposedExpection)

I am just starting to look at .NET 4.0 and Entity Framework 4 and having trouble finding the best way to achieve something. I'll explain with a quick example:I got my CategoryManager class that looks like this:public sealed class CategoryManager { public System.Data.Objects.ObjectSet<Category> Categories { get { try { StoreEntities storeDb = new StoreEntities();                    using (storeDb)                    {                        return storeDb.Categories;                    } } catch (Exception) { //TODO  throw; } } } public List<string> GetCategoryNames() { try { var categories = from category in this.Categories select category.Name; return categories.ToList();
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend