RT~部分代码如下:
//============================================
sqldataadapter.UpdateCommand = new SqlCommand("Update score Set term=@term,cname=@cname,grade=@grade "
+ "WHERE term=@oldterm",myConnection);
sqldataadapter.UpdateCommand.Parameters.Add("@term", SqlDbType.NChar, 5, "term").SourceVersion = DataRowVersion.Original;
sqldataadapter.UpdateCommand.Parameters.Add("@cname", SqlDbType.NChar, 50, "cname").SourceVersion = DataRowVersion.Original;
sqldataadapter.UpdateCommand.Parameters.Add("@grade", SqlDbType.Int, 32, "grade").SourceVersion = DataRowVersion.Original;
SqlParameter parameter=sqldataadapter.UpdateCommand.Parameters.Add("@oldterm", SqlDbType.NChar, 5,"term");
parameter.SourceVersion = DataRowVersion.Original;
sqldataadapter.UpdateCommand.Parameters["@term"].Value = textBox2.Text;
sqldataadapter.UpdateCommand.Parameters["@cname"].Value = textBox3.Text;
sqldataadapter.UpdateCommand.Parameters["@grade"].Value = textBox4.Text; ds.Tables["score"].Rows[this.BindingContext[ds, "score"].Position]["sno"] = textBox1.Text;
ds.Tables["score"].Rows[this.BindingContext[ds, "score"].Position]["term"] = textBox2.Text;
ds.Tables["score"].Rows[this.BindingContext[ds, "score"].Position]["cname"] = textBox3.Text;
ds.Tables["score"].Rows[this.BindingContext[ds, "score"].Position]["grade"] = textBox4.Text; sqldataadapter.Update(ds, "score");
sqldataadapter.Fill(ds, "score");
//===================================================
由于小弟初来乍到,没有很多分数给各位,见谅见谅啊~~
//============================================
sqldataadapter.UpdateCommand = new SqlCommand("Update score Set term=@term,cname=@cname,grade=@grade "
+ "WHERE term=@oldterm",myConnection);
sqldataadapter.UpdateCommand.Parameters.Add("@term", SqlDbType.NChar, 5, "term").SourceVersion = DataRowVersion.Original;
sqldataadapter.UpdateCommand.Parameters.Add("@cname", SqlDbType.NChar, 50, "cname").SourceVersion = DataRowVersion.Original;
sqldataadapter.UpdateCommand.Parameters.Add("@grade", SqlDbType.Int, 32, "grade").SourceVersion = DataRowVersion.Original;
SqlParameter parameter=sqldataadapter.UpdateCommand.Parameters.Add("@oldterm", SqlDbType.NChar, 5,"term");
parameter.SourceVersion = DataRowVersion.Original;
sqldataadapter.UpdateCommand.Parameters["@term"].Value = textBox2.Text;
sqldataadapter.UpdateCommand.Parameters["@cname"].Value = textBox3.Text;
sqldataadapter.UpdateCommand.Parameters["@grade"].Value = textBox4.Text; ds.Tables["score"].Rows[this.BindingContext[ds, "score"].Position]["sno"] = textBox1.Text;
ds.Tables["score"].Rows[this.BindingContext[ds, "score"].Position]["term"] = textBox2.Text;
ds.Tables["score"].Rows[this.BindingContext[ds, "score"].Position]["cname"] = textBox3.Text;
ds.Tables["score"].Rows[this.BindingContext[ds, "score"].Position]["grade"] = textBox4.Text; sqldataadapter.Update(ds, "score");
sqldataadapter.Fill(ds, "score");
//===================================================
由于小弟初来乍到,没有很多分数给各位,见谅见谅啊~~
解决方案 »
- 求个c#做的有关产品的系统,vb的也行,初学者想学学代码积分不够下载
- 求教。net2.0 运行在64位系统时候如何访问32位注册表路径
- OpenFileDialog.ShowDialog()参数问题
- 无窗口(windowless)Form?
- 请问直线和折线能够使用渐变色填充吗?
- 菜鸟问:怎样根据ID获取控件?
- vista 与 VS2005有兼容问题吗?
- 如何能屏蔽掉所有的键盘操作?
- 问一下,如果写一个判断是不是数字的文本框验证。。。
- C#是不是真的跨平台的?
- (很急!在线等答案!)为什么我的DataGridView导出Excel只能到500多行记录?,好象超过570行记录就会出错!!!有没有更好的源代码?顺便问一下,这分数是怎么用的?
- AxPictureClip 控件在C#中怎么使用?
sqldataadapter.UpdateCommand.Parameters.Add("@cname", SqlDbType.NChar, 50, "cname").SourceVersion = DataRowVersion.Current;
sqldataadapter.UpdateCommand.Parameters.Add("@grade", SqlDbType.Int, 32, "grade").SourceVersion = DataRowVersion.Current;
sd.SelectCommand = new SqlCommand("select top 200 ID,NAME from Test", conn); DataSet dataset = new DataSet();
sd.Fill(dataset);
Random r = new Random(1000); sd.UpdateCommand = new SqlCommand("update Test "
+ " set NAME= @name where id = @id", conn);
sd.UpdateCommand.Parameters.Add("@name", SqlDbType.Char, 19, "NAME");
sd.UpdateCommand.Parameters.Add("@id", SqlDbType.Char, 20, "id");
sd.UpdateCommand.UpdatedRowSource = UpdateRowSource.None;
sd.UpdateBatchSize = 0;
再批更新
参考
参考