Sharepoint and stored procedures
Hi,
I am trying to get a simple stored procedure to work in a sharepoint web part (C#), this is the first time I am programming C# and working with sharepoint.
I am used to develop in VB.NET and in order to get a stored procedure to work there I need to make a reference to the SQL by using "imports system.data.sql", the equivelant in C# would be "using system.data.sql", now the problem I have is that when I do this in Visual Studio 08 I get the error "Error 1 The type or namespace name 'data' could not be found (are you missing a using directive or an assembly reference?)"
So ok, cool, I thought and went on trying to find the C# equivelant or maybe other references which enable me to work with SQL connections and stored procedures, no luck at all, can't find any, I googled for the answer but can't find an answer...
So maybe someone who can give me a push in the right direction? Does this work differently in C# or even in Sharepoint, is it even possible to use stored procedures this way in sharepoint or do I have to make use of a different technique?
thanks!
Erik