Type or namespace could not found

[sivakumarl]

I have a doubt in c#

while iam doing my c# applications especially ado.net

it says that a "type or namespace could not found."

even though i use using system.data.sqlclient namespace

the same example is ruiing me in vb.net

 

suppoose if i use a DataSet ds = new DataSet() ;

 

it says that type or name space of " DataSet" could not found

 

any body pls help me to clear my query

Thank you

[PlausiblyDamp]

Have you added a reference to system.data.dll?

[sivakumarl]

yes !

it was there added by default

but i added the reference again still it is giving me the error

[PlausiblyDamp]

Does it work if you use

System.Data.DataSet ds = new System.Data.DataSet();

 

also could you paste your using statements here - I noticed in your original post they were in lower case - C# is case sensitive.

[sivakumarl]

using System;

using System.Collections;

using System.ComponentModel;

using System.Data.SqlClient;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

 

It executed for me Now!!!

Could you please tellme why it does nt take if i give

DataSet ds = new DataSet();

Instead of

System.Data.DataSet ds = new System.Data.DataSet();

 

my is it not inheriting the default namespace.Is it problem in framework. My framework version is 1.1.4322

 

and my using statements does't vary from what i gave above.

 

what about the other statements like SqlDbType ,CommadType ,ParameterDirection,... because these staements also getting the same error when iam using a stored procedure.

 

i will give a simple example for that

 

SqlConnection nwindConn = new SqlConnection("Initial Catalog=northwind;Data Source=Pubs;User Id=siva;Pwd=siva");

 

SqlCommand salesCMD = new SqlCommand("Ten Most Expensive Products" , nwindConn);

salesCMD.CommandType = CommandType.StoredProcedure;

 

nwindConn.Open();

 

SqlDataReader myReader = salesCMD.ExecuteReader();

 

while (myReader.Read())

{

Response.Write(myReader.GetString(0));

Response.Write(myReader.GetDecimal(1));

Response.Write("<br>");

}

 

Here it is giving the same error like

"type or namespace of name'CommadType' not found"

 

Please tell me why my using statements are not inheriting

I request you to extend your cooperation.

Thank you

[sivakumarl]

The connection string in the above code is

"Data Source=localhost;Initial Catalog=NorthWind;User Id=siva;Pwd=siva"

[PlausiblyDamp]

You have

using System.Data.SqlClient

but you don't have

using System.Data

 

at the top - therefore you will have to fully qualify DataSet, CommandType etc. (or add in the relevant using directive)

[sivakumarl]

OH!!!!!!!!!!

Thank you Very much for your coperation

I appreciate your help

Thank you