how to retrieve values from database in asp.net?

Question

I have a database. I'm fetching two values from database in the sqlcommand, but one problem I'm facing is that how to get the adminstatus from the table in the reader()..

my code

protected void signin_Click(object sender, EventArgs e)
    {

    string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

    using (SqlConnection conn = new SqlConnection(connectionString))
    using (SqlCommand comm = new SqlCommand("SELECT password,adminstatus FROM usertable WHERE userid = @username", conn))
    {
        comm.Parameters.AddWithValue("@username", logintext.Text);

        conn.Open();

        using (SqlDataReader reader = comm.ExecuteReader())
        {
            if (reader.Read())
            {
                string password = reader.GetString(0);
                //int st =Convert.ToInt32(reader.GetString(1));
                //int st = reader.GetInt32(0);
                if (password == logpasstext.Text)
                {
                    Session["userid"] = logintext.Text;
                   // iframestyle.Attributes["src"] = "userpage.aspx";
                    iframestyle.Attributes["src"] = "userpage.aspx";
                    logdiv.Attributes["style"] = "display:none;";
                }
              /*  else if (password == logpasstext.Text && st == 1)
                {
                    Session["userid"] = logintext.Text;
                    // iframestyle.Attributes["src"] = "userpage.aspx";
                    iframestyle.Attributes["src"] = "adminpage.aspx";
                    logdiv.Attributes["style"] = "display:none;";
                }*/

                else
                {
                    errorsignin.Visible = true;
                    errorsignin.Text = "INVALID LOGIN";
                    logdiv.Attributes["style"] = "display:block;";
                }
            }
            else
            {
                errorsignin.Visible = true;
                errorsignin.Text = "INVALID LOGIN";
                logdiv.Attributes["style"] = "display:block;";
            }
        }
    }
}

i couldn't get the adminstatus from the table using reader...

What do you mean "couldn't get the adminstatus"? Are you getting an error? Are you getting a null? If the latter, are you sure that isn't the actual value in the database? Your commented out code looks fine (other than you should probably use reader.GetInt32(1) if you know it's an int). — Craig W.
– Craig W., Commented Mar 12, 2014 at 15:10

Murali Murugesan · Accepted Answer · 2014-03-12 15:18:06Z

1

Try using string indexer with SQLDataReader. Just specify the column name you want to retreive

 string adminstatus= Convert.ToString(reader["AdminStatus"]); 
// Assuming AdminStatus is a column name

edited Mar 12, 2014 at 15:18

answered Mar 12, 2014 at 15:09

Murali Murugesan

22.6k18 gold badges76 silver badges123 bronze badges

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

Comments

Alex · Accepted Answer · 2014-03-12 15:10:11Z

0

You can use reader.GetOrdinal(ColumnName) to avoid magic numbers.

I'd then go with

//if adminstatus is a SQL string like the other field
reader.GetString(reader.GetOrdinal("adminstatus")); // returns string

//if adminstatus is for example a SQL bit 
reader.GetBoolean(reader.GetOrdinal("adminstatus")); // returns bool

answered Mar 12, 2014 at 15:10

Alex

23.3k4 gold badges43 silver badges76 bronze badges

Comments

Gilles V. · Accepted Answer · 2014-03-12 15:15:34Z

0

string adminStatus = reader.GetString(1)

where "1" is the position of the field in the query

or better :

string adminStatus = reader.GetString(reader.GetOrdinal("adminstatus"))

with reader.GetOrdinal("adminstatus") returning the position of the field in the query

You will have to replace "GetString" with the method corresponding to the data type (for example, GetInt32 or GetFloat or GetBoolean)

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldatareader(v=vs.110).aspx

edited Mar 12, 2014 at 15:15

answered Mar 12, 2014 at 15:07

Gilles V.

1,40413 silver badges22 bronze badges

1 Comment

Gilles V. Over a year ago

what do you mean by "not working" ? do you have an error message?

Collectives™ on Stack Overflow

how to retrieve values from database in asp.net?

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related