读书人

请各位帮忙看一下我更新数据库是出了什

发布时间: 2011-12-10 22:22:01 作者: rapoo

请各位帮忙看一下我更新数据库是出了什么问题
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();
-------------------------
没有连接字符串

读书人网 >C#

热点推荐