在c#中填充数据集数据表中的数据 [英] Fill Data in Dataset datatable in c#
问题描述
我有一个数据集名称是DsData
数据集中两个数据表的名称是DtRcd和DtInfo
OleDbConnection Odc = new OleDbConnection();
Odc.ConnectionString =Provider = Microsoft.Jet.OLEDB.4.0; Data Source = E:\\Db_Medical.mdb; Jet OLEDB:Database Password = JSN258 ##;;
Odc.Open();
OleDbDataAdapter da = new OleDbDataAdapter(select id_,name_ from tb_patientdetail where id_ = 1,Odc);
DataSet ds = new DataSet();
da.Fill(ds);
如何填写记录在DtRcd???
谢谢和问候
Manmohan Jha
I have one dataset name is "DsData"
in dataset two datatables name is "DtRcd" and "DtInfo"
OleDbConnection Odc = new OleDbConnection();
Odc.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\Db_Medical.mdb; Jet OLEDB:Database Password=JSN258##;";
Odc.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select id_,name_ from tb_patientdetail where id_=1", Odc);
DataSet ds = new DataSet();
da.Fill(ds);
How to fill record in "DtRcd"???
Thanks & Regards
Manmohan Jha
推荐答案
如下所示,给出正确的DataSet和数据表名称
as below, give correct DataSet and data table name
da.Fill(yourdataset, "datatableName");
这篇关于在c#中填充数据集数据表中的数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!