sqldatareader instance

[murali093]

Why we are not able to create an instance for Sqldatareader

[nateraaaa]

Why we are not able to create an instance for Sqldatareader

Please provide more information on the problem you are having. A section of code would also be helpful.

Nathan

[Plater]

It requires there to be data to be read from:

SqlCommand cmd= new SqlCommand(SQLCmdText,myDBConnection);
SqlDataReader myreader= cmd.ExecuteReader();
 

[muralimk]

Please provide more information on the problem you are having. A section of code would also be helpful.

Nathan

Hi
As we create instance for dataset
dataset ds=new datset();
we are not able to create sqldatareader
sqldatareader dr=new sqldatareader();

[Plater]

Right, you cannot create an empty dataReader like that, which is why I posed this code:

SqlCommand cmd= new SqlCommand(SQLCmdText,myDBConnection);
SqlDataReader myreader= cmd.ExecuteReader();
 

Now, you can do this:

SqlDataReader myreader=null;
 

And then use "myreader" anywhere that it is still in scope, if that helps you.