如题啊,我的语句是:(已经可以在DataRow里面删除了,但是就是源数据库里面的么变化!)
我的语句怎么改一下啊!!急死了,搞了3天了!
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
private void button_delet_Click(object sender, System.EventArgs e)
{
if(MessageBox.Show("你想删除记录吗?","消息提示",System.Windows.Forms.MessageBoxButtons.YesNo,System.Windows.Forms.MessageBoxIcon.Warning) == DialogResult.Yes)
{
DataRow dr;
string vSNO = this.textBox_sno.Text;
dr = this.dataSet1.Tables["Table"].Rows.Find(vSNO);
try
{
this.dataSet1.Tables["Table"].Rows.Remove(dr);
//-this.sqlDataAdapter1.Update(dataSet1,"Table");
int vScore = Int32.Parse(this.textBox_score.Text);
string deleteStr = "delete from student where Sno="+vScore.ToString();
SqlCommand deleteCmd=new SqlCommand(deleteStr,sqlConnection1);
deleteCmd.Parameters.Add(new SqlParameter("@Score",SqlDbType.NChar,4));
deleteCmd.Parameters["@Score"].Value = vScore;
deleteCmd.Connection.Open();
deleteCmd.ExecuteNonQuery();
deleteCmd.Connection.Close();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
}
我的语句怎么改一下啊!!急死了,搞了3天了!
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
private void button_delet_Click(object sender, System.EventArgs e)
{
if(MessageBox.Show("你想删除记录吗?","消息提示",System.Windows.Forms.MessageBoxButtons.YesNo,System.Windows.Forms.MessageBoxIcon.Warning) == DialogResult.Yes)
{
DataRow dr;
string vSNO = this.textBox_sno.Text;
dr = this.dataSet1.Tables["Table"].Rows.Find(vSNO);
try
{
this.dataSet1.Tables["Table"].Rows.Remove(dr);
//-this.sqlDataAdapter1.Update(dataSet1,"Table");
int vScore = Int32.Parse(this.textBox_score.Text);
string deleteStr = "delete from student where Sno="+vScore.ToString();
SqlCommand deleteCmd=new SqlCommand(deleteStr,sqlConnection1);
deleteCmd.Parameters.Add(new SqlParameter("@Score",SqlDbType.NChar,4));
deleteCmd.Parameters["@Score"].Value = vScore;
deleteCmd.Connection.Open();
deleteCmd.ExecuteNonQuery();
deleteCmd.Connection.Close();
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
}
解决方案 »
- QQ通信原理
- 如何获得远程IP地址
- C#如何使用雙核?
- 刚学做CS程序,问一个关于C# CS模式窗口的问题
- 2005C# WinForm 一个奇怪的问题 ------在线
- WinForm中的DataGridView绑定到数据库的整型列,一出来就是全选中的,怎样设置可以使得全不选
- 找了好几天,依然没找到好的解决方案,请大牛帮忙~
- 十万火急 求工作流方面的书
- 请问如何截获并保存指定IP发来的网络数据包,然后将其转发?
- 页面刷新的问题
- 关于[此 SqlTransaction 已完成;它再也无法使用。]的另外一种问题
- 请问我用OLE方式连接EXCEL表,遍历SHEET名称,为何出来很多不同的东西呢?(急)
//-this.sqlDataAdapter1.Update(dataSet1,"Table");
int vScore = Int32.Parse(this.textBox_score.Text);
string deleteStr = "delete from student where Sno="+vScore.ToString();
SqlCommand deleteCmd=new SqlCommand(deleteStr,sqlConnection1);
deleteCmd.Connection.Open();
deleteCmd.ExecuteNonQuery();
deleteCmd.Connection.Close();
这里不对
看看你的vScore是什么,是否是正确的参数
是否有左右的空格有关系delete from student干脆你写成上面的,看能不能把整个表都删了
string deleteStr ="delete from Student where Score ="+vScore.ToString();这样写后,再执行有问题提示说
======================
不支持关键字“delete from Student where Score ”
=========================================
什么意思啊??我在sqL里面验证了语句是对的啊!!
deleteCmd.Parameters.Add(new SqlParameter("@Score",SqlDbType.NChar,4));
而是用的你说的那个语句,下面就可以了::
string deleteStr ="delete from Student where (Score ="+vScore.ToString()+")";
SqlConnection conn=new SqlConnection(this.sqlConnection1.ConnectionString);
SqlCommand deleteCmd=new SqlCommand(deleteStr,conn);
conn.Open();
deleteCmd.ExecuteNonQuery();
conn.Close();我新建了个连接的,去掉看行不,还是谢谢你了,感激不尽!
这一句中Rows.Remove(dr)功能是删除行。
要删除期中一条记录的其中一个值的话可以这样
//更新行
DataRow dr = ds.Tables[Table].Rows[0];//Rows[0]为匹配的行
dr["Score"] = "";