SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=.;Initial Catalog=Library;Integrated Security=True;Pooling=False;Asynchronous Processing=true";
string sqlsel = "select password from Admin where password='" + textBox30.Text + "'";
conn.Open();
SqlCommand ccmd = new SqlCommand(sqlsel, conn);
SqlDataReader sdr = ccmd.ExecuteReader();
string strsql = "update Admin set password='" + textBox31.Text + "'where username='bluesky'";
SqlCommand cmd = new SqlCommand(strsql, conn);
if (sdr.Read())
{
MessageBox.Show("密码更新成功!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("原始密码错误,密码更新失败!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
为什么提示更新成功,数据库中却没有变呢?
conn.ConnectionString = "Data Source=.;Initial Catalog=Library;Integrated Security=True;Pooling=False;Asynchronous Processing=true";
string sqlsel = "select password from Admin where password='" + textBox30.Text + "'";
conn.Open();
SqlCommand ccmd = new SqlCommand(sqlsel, conn);
SqlDataReader sdr = ccmd.ExecuteReader();
string strsql = "update Admin set password='" + textBox31.Text + "'where username='bluesky'";
SqlCommand cmd = new SqlCommand(strsql, conn);
if (sdr.Read())
{
MessageBox.Show("密码更新成功!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("原始密码错误,密码更新失败!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
为什么提示更新成功,数据库中却没有变呢?
解决方案 »
- C#对于接口的一些疑问
- 如下图,窗体加载的时候,上面那些控件都不可操作。当单击下面gridview里的数据行的时候,相应数据可显示在上面的上面控件里,但仍不可操作。
- 啥叫C#Office 2003 Word外接程序中的外接程序(AddIn)?和插件有什么不同?到底起个什么作用,别用一些术语来蒙我.
- 恳请用.NET做过多语言的兄弟进来帮帮忙
- 谁能告诉我utf-8的字符值的范围
- 怎么判断GetFiles()得到的文件是不是隐藏的,这样写不行啊,,,
- C# 同时执行多条SQL语句的问题?
- 有没有人用过mysqldrivercs 我怎么不能用?
- 如何在程序中把一个控件放在其他控件的前面?
- 关于换行
- .net窗体换皮肤的软件..
- 用C#2005 做了个小东西(带sql2000数据库)如何给“客户用”
if (sdr.Read())
{
MessageBox.Show("密码更新成功!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("原始密码错误,密码更新失败!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
} 这里出问题了。
sdr.Read()仅仅表示数据库存在指定的记录。
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=.;Initial Catalog=Library;Integrated Security=True;Pooling=False;Asynchronous Processing=true";
//string sqlsel = "select password from Admin where password='" + textBox30.Text + "'";
conn.Open();
SqlCommand ccmd = new SqlCommand(sqlsel, conn);
//SqlDataReader sdr = ccmd.ExecuteReader();
string strsql = "update Admin set password='" + textBox31.Text + "'where username='bluesky'";
SqlCommand cmd = new SqlCommand(strsql, conn);
int count=cmd.ExecuteNonQuery();
if (count>0)
{
MessageBox.Show("密码更新成功!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("原始密码错误,密码更新失败!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=.;Initial Catalog=Library;Integrated Security=True;Pooling=False;Asynchronous Processing=true";
string sqlsel = "select password from Admin where password='" + textBox30.Text + "'";
conn.Open();
SqlCommand ccmd = new SqlCommand(sqlsel, conn);
SqlDataReader sdr = ccmd.ExecuteReader();
if (!sdr.HasRows)
{
MessageBox.Show("原始密码错误,密码更新失败!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
sdr.Close();
conn.Close();
string strsql = "update Admin set password='" + textBox31.Text + "'where username='bluesky'";
SqlCommand cmd = new SqlCommand(strsql, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("密码更新成功!", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);;
}