自己写了个这,但是执行时报错“没有找到内容。”请帮忙看看!!写了先该定义的都定义了,表里有3条记录。 int Max_num;
SqlDataReader Max_dr;
Max_sel="select max(id) as id from admin";
SqlCommand Max_cmd=new SqlCommand (Max_sel,myConnection);
Max_dr=Max_cmd.ExecuteReader();
Max_num=(int)Max_dr["id"];
Max_num++;
SqlDataReader Max_dr;
Max_sel="select max(id) as id from admin";
SqlCommand Max_cmd=new SqlCommand (Max_sel,myConnection);
Max_dr=Max_cmd.ExecuteReader();
Max_num=(int)Max_dr["id"];
Max_num++;
myConnection.Open();//连接Open
int Max_num=0;
SqlDataReader Max_dr;
Max_sel="select max(id) as id from admin";
SqlCommand Max_cmd=new SqlCommand (Max_sel,myConnection);
Max_dr=Max_cmd.ExecuteReader();
if(Max_dr.Read())//使Datareader滚动到记录
Max_num=(int)Max_dr["id"];
Max_num++;
你应该加上if(Max_dr!=null)