请各位帮忙看一下我更新数据库是出了什么问题
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);
}
}
请各位看一下出了什么问题，不能运行出结果！
[解决办法]
while (myReader.Read())
{
}
改为if(myReader.Read())
{
}
[解决办法]
把SqlDataReader myReader = myComm.ExecuteReader();这句后的myReader.Read();删除看一下
[解决办法]
语句有没有执行，就是
if (SqlConn.OpenDbConnection(myConn2))是真吗？
[解决办法]
SqlConnection myConn = new SqlConnection();
myConn.Open();
myConn 连接字符串没设吧。
[解决办法]
SqlConnection myConn = new SqlConnection();
－－－－－－－－－－－－－－－－－－－－－－－－－
没有连接字符串
