SqlCommand Sc = new SqlCommand();
SqlDataReader query;
string mysql1 = "select max(userid) as val from smt_companyuser";
Sc.CommandText = mysql1;
query = Sc.ExecuteReader();
query.Read();当程序执行到query = Sc.ExecuteReader(); 就不执行下面任何语句了,,,也不报任何错误....
各位大哥指教指教
SqlDataReader query;
string mysql1 = "select max(userid) as val from smt_companyuser";
Sc.CommandText = mysql1;
query = Sc.ExecuteReader();
query.Read();当程序执行到query = Sc.ExecuteReader(); 就不执行下面任何语句了,,,也不报任何错误....
各位大哥指教指教
SqlConnection con=new SqlConnection("server=.;database=student;uid=sa;pwd=0421");
SqlCommand Sc = new SqlCommand();
SqlDataReader query;
string mysql1 = "select max(userid) as val from smt_companyuser";
Sc.CommandText = mysql1;
//指定Command的Connection
Sc.Connection = con;
//打开数据库连接
con.Open();
query = Sc.ExecuteReader();
query.Read();
//关闭数据库连接
con.Close();
SqlConnection conn=new SqlConnection("server=.;database=;uid=sa;pwd=");
SqlCommand Sc = new SqlCommand(conn);
ConnectMain.Open();
SqlCommand Sc = new SqlCommand();
SqlDataReader query;
string mysql1 = "select max(userid) as val from smt_companyuser";
Sc.CommandText = mysql1;
Sc.Connection = ConnectMain;
query = Sc.ExecuteReader();
query.Read();
int us = int.Parse(query["val"].ToString());
mysql1 = "insert into smt_companyuser(username,userid,adddate,hitnum) values('" + this.userid + "'," + us + ",'" + DateTime.Now + "',1)";
Sc.CommandText = mysql1;
Sc.Connection = ConnectMain;
Sc.ExecuteNonQuery();
Sc.Dispose();
ConnectMain.Close();全部代码是这样的.....
没有任何错误...
{
SqlConnection ConnectMain = new SqlConnection("Data Source=192.168.1.185;UID=sa;PWD=sa;initial catalog=albb");
ConnectMain.Open();
SqlCommand Sc = new SqlCommand();
SqlDataReader query;
string mysql1 = "select max(userid) as val from smt_companyuser";
Sc.CommandText = mysql1;
Sc.Connection = ConnectMain;
query = Sc.ExecuteReader();
query.Read();
int us = int.Parse(query["val"].ToString());
mysql1 = "insert into smt_companyuser(username,userid,adddate,hitnum) values('" + this.userid + "'," + us + ",'" + DateTime.Now + "',1)";
Sc.CommandText = mysql1;
Sc.Connection = ConnectMain;
Sc.ExecuteNonQuery();
Sc.Dispose();
ConnectMain.Close();
}
catch(Exception ex)
{
//WinForm的话用MessageBox.Show(ex.Message);
//控制台程序用Console.WriteLine(ex.Message);
}
query = Sc.ExecuteReader();
query.Read();
int us = int.Parse(query["val"].ToString());
//关闭datareader
query.Close();
{
ConnectMain.Close();
}
ConnectMain.Open() ;打开连接前执行以上代码看看
谢谢各位了...