How can i Read data using SqlDataReader [duplicate]

Question

I have a SQL Server 2008 database and I am working on it in the backend. I am working on asp.net/C#

using (SqlCommand StrQuer = new SqlCommand("SELECT *  FROM [shopcart].[dbo].[user] WHERE username=@userid AND password=@password", myconn))
{
   StrQuer.Parameters.AddWithValue("@userid", str_usr);
   StrQuer.Parameters.AddWithValue("@password", str_psd);

   SqlDataReader dr = StrQuer.ExecuteReader();

   if (dr.HasRows)
   {
      // MessageBox.Show("loginSuccess");    
   }
}

I know that the reader has values. My SQL command is to select just 1 row from a table. I want to read the items in the row in the reader one by one. How do I do this?

Thanks

such type of questions i dont think should be answered here, very basic thing one can get answer at first search — Md. Parvez Alam
– Md. Parvez Alam, Commented Aug 1, 2013 at 10:59

Alex Filipovici · Accepted Answer · 2013-08-01 11:02:54Z

2

You may use the FieldCount property:

if (dr.Read())
{
    for (int i = 0; i < dr.FieldCount; i++)
    {
        var value = dr[i];
        // do something
    }
}

edited Aug 1, 2013 at 11:02

answered Aug 1, 2013 at 10:57

Alex Filipovici

32.8k7 gold badges60 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Md. Parvez Alam Over a year ago

stackoverflow.com/questions/4018114/…

Jignesh.Raj · Accepted Answer · 2013-08-01 11:03:13Z

1

You can use dr.Read() inside while loop. Like This :

while(dr.read())
{
    // MessageBox.Show("loginSuccess");    
}

answered Aug 1, 2013 at 11:03

Jignesh.Raj

6,0074 gold badges30 silver badges57 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 10:26:49Z

1

if (dr.HasRows)
{
    dr["NameOfColumn"].ToString();    
}

You obviously assign the variable and cast to appropriate type above.

Take a look at my question here too, for another solution Casting Ado.net DataReader to IDataRecord giving strange result

edited May 23, 2017 at 10:26

CommunityBot

11 silver badge

answered Aug 1, 2013 at 10:59

Christian Phillips

18.8k8 gold badges55 silver badges85 bronze badges

Comments

Farhad Jabiyev · Accepted Answer · 2013-08-01 11:10:59Z

1

You can use dr.Read() inside while loop.

while(dr.Read())
{
    string firstCell = dr[0].ToString();
    string secondCell = dr[1].ToString();

    // and so on...
}

// It will be better if you close DataReader
dr.Close();

edited Aug 1, 2013 at 11:10

answered Aug 1, 2013 at 10:57

Farhad Jabiyev

26.9k8 gold badges79 silver badges103 bronze badges

1 Comment

Md. Parvez Alam Over a year ago

stackoverflow.com/questions/4018114/…

Raghubar · Accepted Answer · 2013-08-01 10:59:01Z

0

Here is full example of sqldatareader.

 SqlConnection myConnection = new SqlConnection();  
        myConnection.ConnectionString = WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;  
        SqlCommand myCommand = new SqlCommand();  
        myCommand.CommandType = CommandType.Text;  
        myCommand.CommandText = "SELECT CategoryID, CategoryName FROM Categories";  
        myCommand.Connection = myConnection;  
        SqlDataReader myReader;  

        try  
        {  
            myConnection.Open();  
            myReader = myCommand.ExecuteReader();  
            while (myReader.Read())  
            {  
                ListItem li = new ListItem();  
                li.Value = myReader["CategoryID"].ToString();  
                li.Text = myReader["CategoryName"].ToString();  
                ListBox1.Items.Add(li);  
            }  
            myReader.Close();  
        }  
        catch (Exception err)  
        {  
            Response.Write("Error: ");  
            Response.Write(err.ToString());  
        }  
        finally  
        {  
            myConnection.Close();  
        }

answered Aug 1, 2013 at 10:59

Raghubar

2,7981 gold badge23 silver badges31 bronze badges

1 Comment

ta.speot.is Over a year ago

This is a terrible example. There are no less than 3 IDisposable resources here and you Dispose none of them. Please read the fine manual for the using statement.

Ajay · Accepted Answer · 2013-08-01 11:02:27Z

0

Put the name of the column begin returned from the database where "ColumnName" is. If it is a string, you can use .ToString(). If it is another type, you need to convert it using System.Convert.

SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
string column = rdr["ColumnName"].ToString();
int columnValue = Convert.ToInt32(rdr["ColumnName"]);
}

answered Aug 1, 2013 at 11:02

Ajay

6,59818 gold badges83 silver badges135 bronze badges

Collectives™ on Stack Overflow

How can i Read data using SqlDataReader [duplicate]

6 Answers 6

1 Comment

Comments

Comments

1 Comment

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

Comments

1 Comment

1 Comment

Comments

Linked

Related