Programming Forums > Application Development > C#

King · Jan 20th, 2007, 10:11 PM

In Visual Studio 2003 I could run the following statement:

cmdUser.Parameters.Add("@firstname", SqlDbType.VarChar, 25).Direction = ParameterDirection.Output;

But now in VS2005 it won't compile because it doesn't know what SqlDbType and ParameterDirection are. If I add the System.Data. in front of SqlDbType and ParameterDirection it will work fine. Is VS2005 supposed to behaving like this, or am I missing something?

Thanks.

Samuaijack · Jan 20th, 2007, 10:47 PM

i didn't play with VS 2005 but i think what you should do is to write (using System.Data.SqlClient).

King · Jan 20th, 2007, 10:58 PM

I have done that...

xavier · Jan 21st, 2007, 12:18 AM

I have these 2 inclusions

using System.Data;
using System.Data.SqlClient;

and this:

(Toggle Plain Text)

cmd.Parameters.Add("@asd",SqlDbType.VarChar,25).Direction = ParameterDirection.Output;

compiles fine.

PhilBon · Jan 21st, 2007, 1:10 AM

Maybe I can Give you some background info. What I have found is that you have to be more explicit about what Libraries you want the compiler to use. Cause I to had this kind of problem. Best thing to figure out what you need is put in what you think:

(Toggle Plain Text)

cmdUser.Parameters.Add("@firstname", SqlDbType.VarChar, 25).Direction = ParameterDirection.Output;

and then mouse over it or right click (I can't remember) and it should say "Change To:..." and in front of the cmdUser should be the library that you need. So this would be System.Data if that is what it's part of (I didn't run it to check). If you are only going to use the Library once I think you should leave it to System.Data.cmdUser because then it might lessen the compile time. One thing to know, I did this in Visual Basic .Net 2005 so I'm not 100% sure if it will work with C# but I'm pretty sure because it's the same IDE.

King · Jan 21st, 2007, 2:56 AM

OK I fixed it. I just closed down my project and re-opened it and it compiled fine... very weird.

Thanks for the input guys.

Arevos · Jan 21st, 2007, 5:44 AM

Quote:

Originally Posted by King

OK I fixed it. I just closed down my project and re-opened it and it compiled fine... very weird.

Yeah, Visual Studio 2003 has these little moments as well, and SQL Server 2005 very occassionally also manages to screw itself up. Just remember you're dealing with Microsoft products, which whilst feature-packed, might not be always consistent and stable.

milot · Jan 21st, 2007, 10:25 AM

Did you tried adding System.Data.Common in using directives and try

 CSharp Syntax (Toggle Plain Text) 
cmdUser.Parameters.AddWithValue()
cmdUser.Parameters.AddWithValue()

Jan 20th, 2007, 10:11 PM	#1
King Professional Programmer Join Date: Jan 2006 Location: Ontario, Canada Posts: 372 Rep Power: 0	System.Data In Visual Studio 2003 I could run the following statement: (Toggle Plain Text) cmdUser.Parameters.Add("@firstname", SqlDbType.VarChar, 25).Direction = ParameterDirection.Output; cmdUser.Parameters.Add("@firstname", SqlDbType.VarChar, 25).Direction = ParameterDirection.Output; But now in VS2005 it won't compile because it doesn't know what SqlDbType and ParameterDirection are. If I add the System.Data. in front of SqlDbType and ParameterDirection it will work fine. Is VS2005 supposed to behaving like this, or am I missing something? Thanks. __________________ I am Addicted to Linux!

Jan 20th, 2007, 10:58 PM	#3
King Professional Programmer Join Date: Jan 2006 Location: Ontario, Canada Posts: 372 Rep Power: 0	I have done that... __________________ I am Addicted to Linux!

Jan 21st, 2007, 12:18 AM	#4
xavier Professional Programmer Join Date: Oct 2004 Location: .ro Posts: 381 Rep Power: 4	I have these 2 inclusions using System.Data; using System.Data.SqlClient; and this: (Toggle Plain Text) cmd.Parameters.Add("@asd",SqlDbType.VarChar,25).Direction = ParameterDirection.Output; cmd.Parameters.Add("@asd",SqlDbType.VarChar,25).Direction = ParameterDirection.Output; compiles fine. __________________ Don't take life too seriously, it's not permanent !

Jan 21st, 2007, 1:10 AM	#5
PhilBon Hobbyist Programmer Join Date: Nov 2005 Posts: 172 Rep Power: 3	Maybe I can Give you some background info. What I have found is that you have to be more explicit about what Libraries you want the compiler to use. Cause I to had this kind of problem. Best thing to figure out what you need is put in what you think: (Toggle Plain Text) cmdUser.Parameters.Add("@firstname", SqlDbType.VarChar, 25).Direction = ParameterDirection.Output; cmdUser.Parameters.Add("@firstname", SqlDbType.VarChar, 25).Direction = ParameterDirection.Output; and then mouse over it or right click (I can't remember) and it should say "Change To:..." and in front of the cmdUser should be the library that you need. So this would be System.Data if that is what it's part of (I didn't run it to check). If you are only going to use the Library once I think you should leave it to System.Data.cmdUser because then it might lessen the compile time. One thing to know, I did this in Visual Basic .Net 2005 so I'm not 100% sure if it will work with C# but I'm pretty sure because it's the same IDE.

Jan 21st, 2007, 2:56 AM	#6
King Professional Programmer Join Date: Jan 2006 Location: Ontario, Canada Posts: 372 Rep Power: 0	OK I fixed it. I just closed down my project and re-opened it and it compiled fine... very weird. Thanks for the input guys. __________________ I am Addicted to Linux!

Jan 20th, 2007, 10:47 PM	#2
Samuaijack Programmer Join Date: Jul 2006 Location: using Earth.Africa.Egypt.Cairo; Posts: 71 Rep Power: 3	i didn't play with VS 2005 but i think what you should do is to write (using System.Data.SqlClient).

Jan 21st, 2007, 10:25 AM	#8
milot Programmer Join Date: Nov 2006 Location: Kosov�/Prishtin� Posts: 47 Rep Power: 0	Did you tried adding System.Data.Common in using directives and try CSharp Syntax (Toggle Plain Text) cmdUser.Parameters.AddWithValue() cmdUser.Parameters.AddWithValue()

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode