Regarding the problem that the return value of SqlDataReader cannot be assigned to a variable in asp.NET, anxious, pleas

raofeng76

The script source code is as follows:
<script runat = "server">
    string strcnn = "server = localhost; uid = sa; pwd = wbq; database = WebDate_WBQ";
    SqlConnection cnn;
    SqlCommand cmd;

    void Page_Load (object sender, EventArgs e) {
       string userID = Request.QueryString ["userID"];
       cnn = new SqlConnection (strcnn);
       cnn.Open ();
       cmd = new SqlCommand ("select * from users where userID =" + userID + "", cnn);
       SqlDataReader dr = cmd.ExecuteReader ();
       Label1.Text = dr ("userID"). ToString (); // The following code is wrong.
       TextBox1.Text = dr ("userName"). ToString ();
       TextBox2.Text = dr ("pwd"). ToString ();
       TextBox3.Text = dr ("sex"). ToString ();
       TextBox4.Text = dr ("regDate"). ToString ();
       TextBox5.Text = dr ("QQ"). ToString ();
       TextBox6.Text = dr ("email"). ToString ();
       TextBox7.Text = dr ("address"). ToString ();
       dr.Close ();
       cnn.Close ();
    }
</ script>

The compilation error message is as follows:
Compile Error
Explanation: An error occurred during the compilation of the resources required to service the request. Please check the following specific error details and modify the source code appropriately.
Compiler Error Message: CS0118: "dr" means "variable" and should be "method" here

Source error:

Line 18: cmd = new SqlCommand ("select * from users where userID =" + userID + "", cnn);
Line 19: SqlDataReader dr = cmd.ExecuteReader ();
Line 20: Label1.Text = dr ("userID"). ToString ();
Line 21: TextBox1.Text = dr ("userName"). ToString ();
Line 22: TextBox2.Text = dr ("pwd"). ToString ();

raofeng76

Urgent use!

苹果小刀

SqlDataReader dr = cmd.ExecuteReader ();
Line 20: Label1.Text = dr ("userID"). ToString ();
Line 21: TextBox1.Text = dr ("userName"). ToString ();
Line 22: TextBox2.Text = dr ("pwd"). ToString ();

Add a sentence before line 20
dr.Read ();

raofeng76

Dude, add a sentence before line 20: dr.Read (); It doesn't work, it's still the original mistake!

苹果小刀

dr ["userID"]. ToString ();
()-> []

raofeng76

---- dr ["userID"]. ToString ();
()-> []

Is this wrong?

I changed it to: Lable1.Text = (string) .dr ["userID"] is not right!

苹果小刀

sqlCon.Open ();
            SqlDataReader sqlReader = sqlCmd.ExecuteReader (CommandBehavior.CloseConnection);
            string [] strCourses = new string [20];
            string [] iValues ​​= new string [20];
            int i = 0;
            while (sqlReader.Read ())
            {
                iValues ​​[i] = sqlReader.GetString (0);
                strCourses [i] = sqlReader.GetString (1);
                i ++;
            }
            sqlReader.Close ();

This is an example

raofeng76

I changed to:
       Label1.Text = dr.GetString (0);
       TextBox1.Text = dr.GetString (1);
       TextBox2.Text = dr.GetString (2);
       TextBox3.Text = dr.GetString (3);
       TextBox4.Text = dr.GetString (4);
       TextBox5.Text = dr.GetString (5);
       TextBox6.Text = dr.GetString (6);
       TextBox7.Text = dr.GetString (7);
After the original error disappeared

SqlDataReader sqlReader = sqlCmd.ExecuteReader (CommandBehavior.CloseConnection);
What does the code in brackets mean?

Why do i change myself to
SqlDataReader dr = cmd.ExecuteReader (CommandBehavior.CloseConnection);
It appeared again:

Line 1: Syntax error near '='.
Explanation: An unhandled exception occurred during the execution of the current web request. Check the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Line 1: There was a syntax error near '='.

If you change it to: SqlDataReader dr = cmd.ExecuteReader (); the same error!

苹果小刀

Boss, will it work?

raofeng76

Dude, I have n’t learned that much. I am doing homework now!
Could you tell me more about it?