新手求：C# 更新数据库一条数据的代码 连接数据及更新数据的

[tiangeng520]

C# 更新数据库一条数据的代码 连接数据及更新数据的

[daishengs]

String strConnection="server=127.0.0.1;database=ZJBF_Exam;uid=ZJBF_Exam;pwd=ZJBF_Exam";
OleDbConnection objConnection=new OleDbConnection(strConnection);

String strSQL="SELECT * FROM [T1]";
OleDbCommand objCommand=new OleDbCommand(strSQL,objConnection);
OleDbDataAdapter objDataAdapter=new OleDbDataAdapter(objCommand);
objConnection.Open();
objDataAdapter.Fill(myTable);
objConnection.Close();

[daishengs]

String strConnection="server=127.0.0.1;database=ZJBF_Exam;uid=ZJBF_Exam;pwd=ZJBF_Exam";
SqlConnection objConnection=new SqlConnection (strConnection);

String strSQL="update [T1] set F1='0' WHERE ID=1";
SqlCommand objCommand=new SqlCommand (strSQL,objConnection);
objConnection.Open();
objCommand.ExecuteNonQuery();
objConnection.Close();