一段修改程序,运行后老显示“出错,where附近出错” 求大神教育啊
private void button3_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("请输入班级编号!");
return;
}
SqlConnection conn = new SqlConnection(strcon);
string sqlStr = "update [banjiguanli] set"; if (textBox2.Text.Trim().ToString() != "")
{ sqlStr += "[bjmc]='" + textBox2.Text.Trim() + "',"; }
if (textBox3.Text.Trim() != "")
{ sqlStr += "[bzr]='" + textBox3.Text.Trim() + "',"; }
if (textBox4.Text.Trim() != "")
{ sqlStr += "[zrs]='" + textBox4.Text.Trim() + "',"; }
if (textBox5.Text.Trim() != "")
{ sqlStr += "[zydm]='" + textBox5.Text.Trim() + "',"; } sqlStr += " where bjbh='" + textBox1.Text.Trim() + "'";
SqlCommand cmd = new SqlCommand(sqlStr, conn);
try
{
conn.Open();
int cnm = cmd.ExecuteNonQuery();
if (cnm == 1) //如果受影响的行数为1则修改成功
{ MessageBox.Show("修改成功"); }
else
{ MessageBox.Show("数据库中没有此班级!"); }
this.banjiguanliTableAdapter.Fill(this.FATADataSet.banjiguanli);
}
catch (Exception ex)
{ MessageBox.Show("出错,没有完成班级信息的修改!" + ex.Message); }
finally
{
conn.Close();
}
}
private void button3_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("请输入班级编号!");
return;
}
SqlConnection conn = new SqlConnection(strcon);
string sqlStr = "update [banjiguanli] set"; if (textBox2.Text.Trim().ToString() != "")
{ sqlStr += "[bjmc]='" + textBox2.Text.Trim() + "',"; }
if (textBox3.Text.Trim() != "")
{ sqlStr += "[bzr]='" + textBox3.Text.Trim() + "',"; }
if (textBox4.Text.Trim() != "")
{ sqlStr += "[zrs]='" + textBox4.Text.Trim() + "',"; }
if (textBox5.Text.Trim() != "")
{ sqlStr += "[zydm]='" + textBox5.Text.Trim() + "',"; } sqlStr += " where bjbh='" + textBox1.Text.Trim() + "'";
SqlCommand cmd = new SqlCommand(sqlStr, conn);
try
{
conn.Open();
int cnm = cmd.ExecuteNonQuery();
if (cnm == 1) //如果受影响的行数为1则修改成功
{ MessageBox.Show("修改成功"); }
else
{ MessageBox.Show("数据库中没有此班级!"); }
this.banjiguanliTableAdapter.Fill(this.FATADataSet.banjiguanli);
}
catch (Exception ex)
{ MessageBox.Show("出错,没有完成班级信息的修改!" + ex.Message); }
finally
{
conn.Close();
}
}
解决方案 »
- 求高人 c+a+d调不出任务管理器
- c#做的winframe程序怎么答应datagridview中的内容
- C#怎样生成对称加密算法的密钥
- c#获取另一个窗体动态生成的控件信息
- 点击上一页时经常出现“索引 -5 不是为负数,就是大于行数”,请高手帮忙!!!
- 求助:Application/Session对象有和区别?
- 增加记录的问题(自动增行)???——激情岁月!!
- 哪儿能用证书服务下载!
- rose 能否 生成 。net 代码吗 ?
- 我换了一个名字,怎么把原来的可用分导过来呢????谢谢!
- 如何设置子线程可以随着主线程的结束而结束?
- 怎么把Rectangle name和String str的name和str进行比较呢?或者转换?
----
update table set c1=xxx,b1=yyyy, wehre ....
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("请输入班级编号!");
return;
}
SqlConnection conn = new SqlConnection(strcon);
StringBuilder sb = new StringBuilder();
sb.Append("update [banjiguanli] set ");
if (textBox2.Text.Trim().ToString() != "")
{
sb.Append(" [bjmc]='" + textBox2.Text.Trim() + "', ");
}
if (textBox3.Text.Trim() != "")
{
sb.Append(" [bzr]='" + textBox3.Text.Trim() + "', ");
}
if (textBox4.Text.Trim() != "")
{
sb.Append(" [zrs]='" + textBox4.Text.Trim() + "',");
}
if (textBox5.Text.Trim() != "")
{
sb.Append(" [zydm]='" + textBox5.Text.Trim() + "' ");
}
sb.Append(" where bjbh='" + textBox1.Text.Trim() + "'");
SqlCommand cmd = new SqlCommand(sb.ToString(), conn);
try
{
conn.Open();
int cnm = cmd.ExecuteNonQuery();
if (cnm == 1) //如果受影响的行数为1则修改成功
{ MessageBox.Show("修改成功"); }
else
{ MessageBox.Show("数据库中没有此班级!"); }
this.banjiguanliTableAdapter.Fill(this.FATADataSet.banjiguanli);
}
catch (Exception ex)
{ MessageBox.Show("出错,没有完成班级信息的修改!" + ex.Message); }
finally
{
conn.Close();
}
}
是
update table名字 set 列1=值,列2=值...... 最后一个列 后面不要加逗号学什么语言需要先把基本的语法学好
private void button3_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("请输入学号!");
return;
}
SqlConnection conn = new SqlConnection(strcon);
string sqlStr = "update [xueshengdananguanli] set"; if (textBox2.Text.Trim().ToString() != "")
{
sqlStr += "[xm]='" + textBox2.Text.Trim() + "', ";
} if (textBox3.Text.Trim() != "")
{
sqlStr += "[csrq]='" + textBox3.Text.Trim() + "', ";
} if (textBox4.Text.Trim() != "")
{
sqlStr += "[jg]='" + textBox4.Text.Trim() + "', ";
} if (textBox5.Text.Trim() != "")
{
sqlStr += "[zzmm]='" + textBox5.Text.Trim() + "', ";
} if (textBox6.Text.Trim() != "")
{
sqlStr += "[sfzh]='" + textBox6.Text.Trim() + "', ";
} if (textBox6.Text.Trim() != "")
{
sqlStr += "[zydm]='" + textBox7.Text.Trim() + "', ";
} if (FileNamePath != "")
{
sqlStr += "[zp]=@zp,";
}
sqlStr += "[xb]=@xb"; sqlStr += " where xh='" + textBox1.Text.Trim() + "'"; SqlCommand cmd = new SqlCommand(sqlStr, conn); if (radioButton1.Checked == true) //如果性别是男
{ cmd.Parameters.Add("@xb", SqlDbType.Bit).Value = true; }
else if (radioButton2.Checked == true) //如果性别是女
{ cmd.Parameters.Add("@xb", SqlDbType.Bit).Value = false; }
else
{
MessageBox.Show("请选择性别");
return;
}
if (FileNamePath != "") //如果选择了照片
{
FileStream fs = null;
fs = new FileStream(FileNamePath, FileMode.Open, FileAccess.Read);
MemoryStream mem = new MemoryStream();
byte[] data1 = new byte[fs.Length];
fs.Read(data1, 0, (int)fs.Length);
cmd.Parameters.Add("@zp", SqlDbType.VarBinary); //这里选择VarBinary类型
cmd.Parameters["@zp"].Value = data1; //把照片变化成字节数组
}
try
{
conn.Open();
int yxh = cmd.ExecuteNonQuery();
if (yxh == 1) //如果受影响的行数为1则修改成功
{ MessageBox.Show("修改成功"); }
else
{ MessageBox.Show("数据库中没有此学生!"); }
this.xueshengdananguanliTableAdapter.Fill(this.FATADataSet.xueshengdananguanli);
}
catch (Exception ex)
{ MessageBox.Show("出错,没有完成成绩的修改!" + ex.Message); }
finally
{
conn.Close();
FileNamePath = "";
}
}问题
using System.Text; private void button3_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("请输入班级编号!");
return;
}
SqlConnection conn = new SqlConnection(strcon);
StringBuilder sb = new StringBuilder();
sb.Append("update [banjiguanli] set ");
if (textBox2.Text.Trim().ToString() != "")
{
sb.Append(" [bjmc]='" + textBox2.Text.Trim() + "', ");
}
if (textBox3.Text.Trim() != "")
{
sb.Append(" [bzr]='" + textBox3.Text.Trim() + "', ");
}
if (textBox4.Text.Trim() != "")
{
sb.Append(" [zrs]='" + textBox4.Text.Trim() + "',");
}
if (textBox5.Text.Trim() != "")
{
sb.Append(" [zydm]='" + textBox5.Text.Trim() + "',");
}
string strSQL = sb.ToString().TrimEnd(',')
strSQL+= where bjbh='" + textBox1.Text.Trim() + "'";
SqlCommand cmd = new SqlCommand(strSQL, conn);
try
{
conn.Open();
int cnm = cmd.ExecuteNonQuery();
if (cnm == 1) //如果受影响的行数为1则修改成功
{
MessageBox.Show("修改成功");
}
else
{
MessageBox.Show("数据库中没有此班级!");
}
this.banjiguanliTableAdapter.Fill(this.FATADataSet.banjiguanli);
}
catch (Exception ex)
{
MessageBox.Show("出错,没有完成班级信息的修改!" + ex.Message);
}
finally
{
conn.Close();
}
}