高手解决!!
SqlConnection conn= new SqlConnection();SqlDataAdapter adpt=new SqlDataAdapter();
DataSet dsTemp=new DataSet();
conn.ConnectionString="server=(local);Integrated Security=SSPI;DataBase=test";
conn.Open();
adpt.SelectCommand=new SqlCommand(); adpt.SelectCommand.Connection=conn; adpt.SelectCommand.CommandText="select * from info";
adpt.Fill(dsTemp,"info");
conn.Close();
这些都是什么意思啊? --------------------编程问答-------------------- 依次实例话三个对象
SqlConnection conn= new SqlConnection(); 数据连接对象
SqlDataAdapter adpt=new SqlDataAdapter(); 数据适配器
DataSet dsTemp=new DataSet(); 数据集
赋值连接字符串
conn.ConnectionString="server=(local);Integrated Security=SSPI;DataBase=test";
打开连接
conn.Open();
实例化selectcommand并赋值
adpt.SelectCommand=new SqlCommand();
adpt.SelectCommand.Connection=conn; adpt.SelectCommand.CommandText="select * from info";
填充DataSet
adpt.Fill(dsTemp,"info");
关闭连接
conn.Close();
执行的结果就是,得到一个数据集对象dsTemp,其含有一个info表,里面是select * from info去出来的数据
补充:.NET技术 , C#