C# 数据库更新问题 给分 (1)如何把数据库里(SQL)里查询到的某一个人的记录显示到datagridview上?(2)我成功删除了数据库里的一条记录,但datagridview却不能实时更新往各位高手帮帮忙。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1.先从数据库中把你需要的内容查询出来2.然后进行绑定数据到gridview中3.如果删除了语句后,在进行一次绑定就可以 了 <1>可以将查询到的数据返回到DataTable中,然后将DataGridView的数据源设定为该DataTable this.DataGridView1.DataSource = dt;<2>没有及时更新数据的原因是你没有重新绑定 更改数据后,你要重新设定一下DataGridView的数据源 希望对你有帮助! By 【Hamber_Bao】 查询结果放入DataTable,设置DataSource属性删除后重新DataBind() 传参: private int _bookformId; public UpdateBookForm(int bookform_id) { this._bookformId = bookform_id; InitializeComponent(); }先得到数据 private void UpdateBookForm_Load(object sender, EventArgs e) { string strSql = "from AA where BookId="+_bookformId+""; IList list = basedao.GetDao().Select(strSql); BookInformation book = new BookInformation(); foreach (var aa in list) { book = (BookInformation)aa; } this.text_isbn.Text = book.ISBN; this.text_bookname.Text = book.BookName; this.text_bookPrice.Text = book.Price; this.dateTimePicker1.Text = book.BuyToday; this.text_bookStatues.Text = book.Statues; this.text_description.Text = book.Description; }在在修改事件中写 private void but_update_Click(object sender, EventArgs e) { BookInformation book = new BookInformation(); book.BookId = _bookformId; book.ISBN = this.text_isbn.Text.Trim(); book.BookName = this.text_bookname.Text.Trim(); book.Price = this.text_bookPrice.Text.Trim(); book.BuyToday = this.dateTimePicker1.Text.Trim(); book.Statues = this.text_bookStatues.Text.Trim(); book.Description = this.text_description.Text.Trim(); bool boo = basedao.GetDao().Update(book); if (boo) { MessageBox.Show("修改成功!"); this.Close(); } else { MessageBox.Show("修改失败!"); } }试试 this.DataGridView1.DataSource = dt;这个就是重新绑定 重新加载一次update行不行?纯粹问问... 关于Activator.CreateInstance 数据字典设计求助 关于服务器端验证控件 求: C#与ACCESS合作之案例 vs2008中如何实现eclipse那样的“高亮光标所在关键字”功能? C#读二进制文件,怎么判断读到了文件末尾? c++中的指针在c#中怎么表示的好 直接显示下拉内容 求各位大虾ASP.NET管理windows帐户的问题 请问各位 我想买本C#有关项目的书不知道买哪种的好 C# VS2008开发的程序如何移植到Linux和unix平台运行? 如何把datagridview1中的数量合计显示在datagridview2中
2.然后进行绑定数据到gridview中
3.如果删除了语句后,在进行一次绑定就可以 了
this.DataGridView1.DataSource = dt;<2>没有及时更新数据的原因是你没有重新绑定 更改数据后,你要重新设定一下DataGridView的数据源
希望对你有帮助!
By 【Hamber_Bao】
查询结果放入DataTable,设置DataSource属性删除后重新DataBind()
private int _bookformId;
public UpdateBookForm(int bookform_id)
{
this._bookformId = bookform_id;
InitializeComponent();
}
先得到数据
private void UpdateBookForm_Load(object sender, EventArgs e)
{
string strSql = "from AA where BookId="+_bookformId+"";
IList list = basedao.GetDao().Select(strSql);
BookInformation book = new BookInformation();
foreach (var aa in list)
{
book = (BookInformation)aa;
}
this.text_isbn.Text = book.ISBN;
this.text_bookname.Text = book.BookName;
this.text_bookPrice.Text = book.Price;
this.dateTimePicker1.Text = book.BuyToday;
this.text_bookStatues.Text = book.Statues;
this.text_description.Text = book.Description;
}在在修改事件中写
private void but_update_Click(object sender, EventArgs e)
{
BookInformation book = new BookInformation();
book.BookId = _bookformId;
book.ISBN = this.text_isbn.Text.Trim();
book.BookName = this.text_bookname.Text.Trim();
book.Price = this.text_bookPrice.Text.Trim();
book.BuyToday = this.dateTimePicker1.Text.Trim();
book.Statues = this.text_bookStatues.Text.Trim();
book.Description = this.text_description.Text.Trim(); bool boo = basedao.GetDao().Update(book);
if (boo)
{
MessageBox.Show("修改成功!");
this.Close();
}
else
{
MessageBox.Show("修改失败!");
}
}试试
纯粹问问...