private void returnButton_Click(object sender, EventArgs e)
{
try
{
SqlConnection myConn = new SqlConnection();
myConn.Open();
if (SqlConn.OpenDbConnection(myConn))
{
string sqlString = "select * from test"; SqlCommand myComm = new SqlCommand(sqlString, myConn); SqlDataReader myReader = myComm.ExecuteReader();
myReader.Read(); while (myReader.Read())
{
SqlConnection myConn2 = new SqlConnection(); if (SqlConn.OpenDbConnection(myConn2))
{ string sqlString2 = "update test set Translation = null";
SqlCommand myComm2 = new SqlCommand(sqlString2, myConn2);
myComm2.ExecuteNonQuery();
}
}
string sqlString3 = "select * from test"; DataSet mySet = new DataSet(); myComm.Connection = myConn;
myComm.CommandText = sqlString3; translationGridView.DataSource = mySet.Tables; myComm.Dispose();
myConn.Close();
myReader.Close(); } } catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}请各位看一下出了什么问题,不能运行出结果!
{
try
{
SqlConnection myConn = new SqlConnection();
myConn.Open();
if (SqlConn.OpenDbConnection(myConn))
{
string sqlString = "select * from test"; SqlCommand myComm = new SqlCommand(sqlString, myConn); SqlDataReader myReader = myComm.ExecuteReader();
myReader.Read(); while (myReader.Read())
{
SqlConnection myConn2 = new SqlConnection(); if (SqlConn.OpenDbConnection(myConn2))
{ string sqlString2 = "update test set Translation = null";
SqlCommand myComm2 = new SqlCommand(sqlString2, myConn2);
myComm2.ExecuteNonQuery();
}
}
string sqlString3 = "select * from test"; DataSet mySet = new DataSet(); myComm.Connection = myConn;
myComm.CommandText = sqlString3; translationGridView.DataSource = mySet.Tables; myComm.Dispose();
myConn.Close();
myReader.Close(); } } catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}请各位看一下出了什么问题,不能运行出结果!
{
}改为if(myReader.Read())
{
}
if (SqlConn.OpenDbConnection(myConn2))是真吗?
myConn.Open();myConn 连接字符串没设吧。
-------------------------
没有连接字符串