数据集,数据适配器,数据填充 [英] data set,data adapter,data fill
问题描述
i知道数据集的概念和数据适配器以及数据填充方法但仍然让人感到困惑。
你能用简单的代码和解释告诉我它是如何工作的。
SqlConnection con = new SqlConnection( @ );
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
public void dataBind()
{
con.Open();
cmd.Connection = con;
cmd.CommandText =select * from Emp;
da = new SqlDataAdapter(cmd);
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
con.Close();
}
public class CommClass
{
SqlDataAdapter Da;
DataSet Ds;
DataTable Dt;
SqlCommand Cmd;
SqlConnection Cn;
SqlConnection CnW;
SqlDataReader Dr;
string OnOff;
public CommClass()
{
try
{
Cn = new SqlConnection(ConfigurationManager.ConnectionStrings [ 道道跨度>]的ConnectionString)。
Cn.Open();
OnOff = On;
}
catch (例外情况)
{
// MsgBox(ex.Message)
}
}
public DataSet GetDs( string Crit)
{
DataSet ObjDs = new DataSet();
尝试
{
Cmd = 新 SqlCommand(Crit,Cn );
Cmd.CommandTimeout = 0 ;
// Cmd.ExecuteNonQuery()
Da = new SqlDataAdapter(Cmd);
Da.Fill(ObjDs);
}
catch (例外情况)
{
// MsgBox(ex.Message)
}
return ObjDs;
}
此代码在App_Code中是公共类..
首先声明您在公共类中的所有变量
然后在构造函数中建立连接(connctionstring在web.config中
然后在get ds方法中
(这是你想要学习的)
创建新的数据集,新的命令,你可以在其中传递查询,连接
比新的dataadapter和那个传递命令(已经有查询和连接!!!) />
所以你可以填写ds
并在你的aspx.cs中返回ds
页面你必须要写
CommClass objCls = new CommClass();
ds = objCls.GetDs(Select * from EmployeeMst);
享受......
HAPPY CoDING:)
kindly tell me in detail about the data set and data adapter and data fill method...
i know the concept of the data set and data adapter and data fill method but still its getting confused.
can u tell me how it works with simple code and explanation.
SqlConnection con = new SqlConnection(@""); SqlCommand cmd = new SqlCommand(); SqlDataAdapter da = new SqlDataAdapter(); DataTable dt = new DataTable(); public void dataBind() { con.Open(); cmd.Connection = con; cmd.CommandText = "select * from Emp"; da = new SqlDataAdapter(cmd); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); con.Close(); }
public class CommClass { SqlDataAdapter Da; DataSet Ds; DataTable Dt; SqlCommand Cmd; SqlConnection Cn; SqlConnection CnW; SqlDataReader Dr; string OnOff; public CommClass() { try { Cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Cn"].ConnectionString); Cn.Open(); OnOff = "On"; } catch (Exception ex) { //MsgBox(ex.Message) } } public DataSet GetDs(string Crit) { DataSet ObjDs = new DataSet(); try { Cmd = new SqlCommand(Crit, Cn); Cmd.CommandTimeout = 0; //Cmd.ExecuteNonQuery() Da = new SqlDataAdapter(Cmd); Da.Fill(ObjDs); } catch (Exception ex) { //MsgBox(ex.Message) } return ObjDs; }
this Code is in common class in App_Code..
First of all declare Your all variables in common class
then in constructor make connection(with connctionstring which is in web.config
then in get ds method
(This is what You want to learn)
create new dataset,new command in which You can pass query,connection
than new dataadapter andin that pass command(which have query and connection already!!!)
so You can Fill ds
and return ds
in You aspx.cs
page You have To just write
CommClass objCls=new CommClass();
ds=objCls.GetDs("Select * from EmployeeMst");
Enjoy...
HAPPY CoDING:)
这篇关于数据集,数据适配器,数据填充的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!