Ask a data set filling problem (white)

dscy8899

protected void Page_Load (object sender, EventArgs e)
    {
        string sql = "select * from cheeck where shuihao = session ['shuihao']";
        SqlConnection con = new SqlConnection ();
        con.ConnectionString = "Server = i-server; database = fapiao; integrated security = SSPI;";
        con.Open ();
        SqlDataAdapter sqlda = new SqlDataAdapter (sql, con);
        DataSet ds = new DataSet ();
        
        DataTable mytable = ds.Tables ["cheeck"]

The above is a piece of my program. I would like to ask when filling the dataset object with FILL.
     Is the "cheeck" in sqlda.Fill (ds, "cheeck"); the result of the query using the select statement above? My cheeck is a table, and the error is displayed when running. I do n’t know how to fill the query content into ds Inside, ask ~

huyanqing

string sql = "select * from cheeck where shuihao = session ['shuihao']";
        SqlConnection con = new SqlConnection ();
        con.ConnectionString = "Server = i-server; database = fapiao; integrated security = SSPI;";
        con.Open ();
        SqlDataAdapter sqlda = new SqlDataAdapter (sql, con);
        DataSet ds = new DataSet ();
sqlda.Fill (ds, "cheeck");

shenmue024

"select * from cheeck where shuihao = session ['shuihao']";

=====>

 "select * from cheeck where shuihao = '" + session ["shuihao"]. ToString () + "'";

在小学读高中

Yes, it is to fill the results of the select statement query into ds, just follow the upstairs
sqlda.Fill (ds, "cheeck"); The cheeck in it is just an alias you take.

dscy8899

I changed "select * from cheeck where shuihao = session ['shuihao']"; to
  
"select * from cheeck where shuihao = '" + session ["shuihao"]. ToString () + "'"; prompting an error saying "the name" session "does not exist in the current context" Is it defined before?

在小学读高中

This sentence is written as DataTable mytable = ds.Tables [0], just pull it!

pronice

session ["Sleep well"]. ToString ()

->

session ["Sleep well"]. ToString ()

dscy8899

Oh, quietly ask, what does Tables [0] "0" in DataTable mytable = dsTables [0]. Mean,

dscy8899

After I am modified according to the above suggestions, the runtime is directed to string sql = "select * from cheeck where shuihao = '" + Session ["shuihao"]. ToString () + "'"; this line prompts "The object reference is not set to "Instance of the object" error, how do I solve it?

在小学读高中

It is the first table in ds! default
The data set contains many tables