关于动态生成dataset和datadpter

lcg200x 2003-10-16 10:00:13
有什么好的解决方案可以根据sql语句动态生成dataset,然后根据dataset动态生成该dataset的数据适配器来更新它,或者把动态生成的数据适配器保存起来!但是怎么和这个dataset对应起来呢?请高寿说说自己的想法!谢!
...全文
86 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
Jarod 2003-10-16
  • 打赏
  • 举报
回复

objDataAdapter.FillSchema(objDataSet,SchemaType.Source);
objDataAdapter.AcceptChangesDuringFill = true;
dahuzizyd 2003-10-16
  • 打赏
  • 举报
回复
SqlClient
[Visual Basic]
Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind")

Dim selectCMD As SqlCommand = New SqlCommand("SELECT CustomerID, CompanyName FROM Customers", nwindConn)
selectCMD.CommandTimeout = 30

Dim custDA As SqlDataAdapter = New SqlDataAdapter
custDA.SelectCommand = selectCMD

nwindConn.Open()

Dim custDS As DataSet = New DataSet
custDA.Fill(custDS, "Customers")

nwindConn.Close()
[C#]
SqlConnection nwindConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind");

SqlCommand selectCMD = new SqlCommand("SELECT CustomerID, CompanyName FROM Customers", nwindConn);
selectCMD.CommandTimeout = 30;

SqlDataAdapter custDA = new SqlDataAdapter();
custDA.SelectCommand = selectCMD;

nwindConn.Open();

DataSet custDS = new DataSet();
custDA.Fill(custDS, "Customers");

nwindConn.Close();
OleDb
[Visual Basic]
Dim nwindConn As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;" & _
"Integrated Security=SSPI;Initial Catalog=northwind")

Dim selectCMD As OleDbCommand = New OleDbCommand("SELECT CustomerID, CompanyName FROM Customers", nwindConn)
selectCMD.CommandTimeout = 30

Dim custDA As OleDbDataAdapter = New OleDbDataAdapter
custDA.SelectCommand = selectCMD

Dim custDS As DataSet = New DataSet
custDA.Fill(custDS, "Customers")
[C#]
OleDbConnection nwindConn = new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;" +
"Integrated Security=SSPI;Initial Catalog=northwind");

OleDbCommand selectCMD = new OleDbCommand("SELECT CustomerID, CompanyName FROM Customers", nwindConn);
selectCMD.CommandTimeout = 30;

OleDbDataAdapter custDA = new OleDbDataAdapter();
custDA.SelectCommand = selectCMD;

DataSet custDS = new DataSet();
custDA.Fill(custDS, "Customers");
CSTerry 2003-10-16
  • 打赏
  • 举报
回复
同意 colinfly(Colin)
Jarod 2003-10-16
  • 打赏
  • 举报
回复
objDataAdapter.FillS(objDataSet,SchemaType.Source);
objDataAdapter.AcceptChangesDuringFill = true;
elite2018 2003-10-16
  • 打赏
  • 举报
回复
public DataSet yourMethod (String yourSql)
{
.. your codes

return datasetobj;


}
colinfly 2003-10-16
  • 打赏
  • 举报
回复
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand();
command.Connection = new System.Data.SqlClient.SqlConnection("you sql connect string");
command.CommandText = "select * from order";

adapter.SelectCommand = command;

System.Data.DataSet ds=new System.Data.DataSet();

adapter.Fill(ds);
大户翁 2003-10-16
  • 打赏
  • 举报
回复
定义一datadpter 传入查询的Sql语句
datadpter fill to dataset

110,499

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术 C#
社区管理员
  • C#
  • Web++
  • by_封爱
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧