UC知道C# 数据写入问题，很奇怪
来源：百度知道 编辑：UC知道 时间：2024/05/22 19:20:29
private void button1_Click_1(object sender, EventArgs e)
{
SqlConnection sqlConnection = new SqlConnection(Properties.Settings.Default.LabHis_DataConnectionString);
sqlConnection.Open();
string sqlstring = "insert into operator_info(operator_no,operator_name,pinyin,password) values('0002','jiang','jiang','xingshang')";
SqlDataAdapter adapter = new SqlDataAdapter(sqlstring, sqlConnection);
DataSet ds = new DataSet();
adapter.Fill(ds);
SqlCommand cmd = new SqlCommand("select operator_name from operator_info where operator_no='0002'", sqlConnection);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
MessageBox.Show(dr[0].ToString());
}
dr.Close();
sqlConnection.Close();
{
SqlConnection sqlConnection = new SqlConnection(Properties.Settings.Default.LabHis_DataConnectionString);
sqlConnection.Open();
string sqlstring = "insert into operator_info(operator_no,operator_name,pinyin,password) values('0002','jiang','jiang','xingshang')";
SqlDataAdapter adapter = new SqlDataAdapter(sqlstring, sqlConnection);
DataSet ds = new DataSet();
adapter.Fill(ds);
SqlCommand cmd = new SqlCommand("select operator_name from operator_info where operator_no='0002'", sqlConnection);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
MessageBox.Show(dr[0].ToString());
}
dr.Close();
sqlConnection.Close();
当你关闭程序后，是不是同时关闭了某项运行程序？比如数据库的运行等等，检查一下环境问题，再就是可能跟你输入的查询条件有关，你在后台写的查询代码是不是符合查询的所有情况条件，导致查询结果没有
sqlstring = "insert into operator_info(operator_no,operator_name,pinyin,password) values('0002','jiang','jiang','xingshang')";
SqlDataAdapter adapter = new SqlDataAdapter(sqlstring, sqlConnection);
这样写是什么意思 先插入了在执行查询
是不是因为operator_no是主键不能插入重复值的原因.有什么问题再问好了
是不是sqlConnection.Close()没成功
有关java的问题，这里都有很详细的讲解，你可以参考一下，方法有很多
参考资料:http://www.baidu.com/s?wd=%B1%B1%B7%E7%CD%F8&rsv_bp=0&rsv_spt=3&inputT=131