你找些OleDbDataAdapter和DataSet方面的资料吧.上面很多的.
http://www.syncfusion.com/FAQ/WinForms/FAQ_c44c.asp#q480q
hope it helps
解决方案 »
- c# 结构中含有结构和结构数组到 byte[] 变量的转换操作?
- 请问如何得到当前的对象
- 网络编程序问题
- 需要自己做个ftp服务,怎么做啊?哪里有例子代码吗?
- 播放声音的问题
- 我是新手现在想学.NET开发个WEB网站,是学C++.NET呢?还是用ASP.NET???还有就是我想买本书看看?大家帮推荐下!
- 进度条问题
- 急!谁有接收邮件的资料和代码,C#中好像没这方面的类可用,请大家一起拿出自己知道的资料和代码,一起交流和学习吧,多谢了!
- 新手提问关于socket的异步和多线程的问题
- C#和VB.net都能对内存直接进行操作吗?
- 关于C#中访问ACCESS数据库的问题,谢谢帮助!
- GDI+滚动问题,在线等待,立解立结
Public Class Form1
Inherits System.Windows.Forms.Form
Private MyTable As DataTable
Private MyAdapter As SqlClient.SqlDataAdapter
Private MyCnn As SqlClient.SqlConnection
Private MyDataSet As DataSet
Private MyBuilder As SqlClient.SqlCommandBuilder
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Open a sqlconnection
MyCnn = New SqlClient.SqlConnection("server=localhost;database=Mycreate;uid=sa;pwd=wjj") 'create a data adapter
MyAdapter = New SqlClient.SqlDataAdapter("select * from mytable", MyCnn) 'create dataset and datatable
MyTable = New DataTable("t")
MyAdapter.Fill(MyTable)
MyBuilder = New SqlClient.SqlCommandBuilder(MyAdapter)
MyDataSet = New DataSet()
MyDataSet.Tables.Add(MyTable) 'set datasource of the datagrid
DataGrid1.DataSource = MyDataSet.Tables("t") AddHandler MyTable.ColumnChanged, AddressOf Me.Table_Changed End Sub Private Sub Table_Changed(ByVal sender As Object, ByVal e As System.Data.DataColumnChangeEventArgs)
MyAdapter.Update(MyTable)
End Sub
End Class
请高手指教
public void row_update(object sender,System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
SqlConnection con=new SqlConnection("server=lhpro;uid=worker;pwd='tpcims';database=movex");
System.Web.UI.WebControls.TextBox Txt_target=new System.Web.UI.WebControls.TextBox();
Txt_target=(System.Web.UI.WebControls.TextBox)e.Item.Cells[3].Controls[0];
string updatecmd="update target set target='"+Txt_target.Text+"' where id="+e.Item.Cells[1].Text;
SqlCommand ucmd=new SqlCommand(updatecmd,con);
con.Open();
Dgd_target.DataSource=ucmd.ExecuteReader();
Dgd_target.DataBind();
Dgd_target.EditItemIndex=-1;
con.Close();
DataBind();
}