将数据从一个网格存储到另一个网格,也存储到sqlserver2008(DataBase) [英] Store data from one Grid To another Grid and to sqlserver2008(DataBase) also
问题描述
我正在编写这样的代码...我最后得到的数据是m_dt,tabledata也会被保存到网格中,但是它没有保存在数据库中如何保存在数据库中的时候请大家恭喜
protected void btn_Save_Click(object sender,EventArgs e)
{
DataTable m_dt = new DataTable();
DataRow dr;
m_dt.Columns.Add(new DataColumn(Br_Name));
m_dt.Columns.Add(new DataColumn(Br_BeddedHospital));
m_dt.Columns.Add(new DataColumn(Br_Director));
m_dt.Columns.Add(new DataColumn(Br_Since));
m_dt.Columns.Add(new DataColumn(Br_Fax));
m_dt.Columns.Add(new DataColumn(Br_Address));
m_dt.Columns.Add(new DataColumn(Br_Phone_No1));
m_dt.Columns.Add(new DataColumn(Br_E_Mail_Id));
fo到达(grv_Child.Rows中的GridViewRow gvr)
{
dr = m_dt.NewRow();
dr [Br_Name] =((标签)gvr.Cells [1] .FindControl(Label1))。文字;
dr [Br_BeddedHospital] =((标签)gvr.Cells [2] .FindControl(Label2))。文字;
dr [Br_Director] =((标签)gvr.Cells [3] .FindControl( Label3))。文字;
dr [Br_Since] =((标签)gvr.Cells [4] .FindControl(Label4))。文字;
dr [Br_Fax] =((标签)gvr.Cells [5] .FindControl(Label5))。文字;
dr [Br_Address] =((标签)gvr .Cells [6] .FindControl(Label6))。文字;
dr [Br_Phone_No1] =((标签)gvr.Cells [7] .FindControl(Label7))。文字;
dr [Br_E_Mail_Id] =((标签)gvr.Cells [8] .FindControl(Label8))。文字;
m_dt.Rows。加入(DR);
}
grv_BranchDetails.DataSource = m_dt;
grv_BranchDetails.DataBind();
}
编辑:
protected void btn_Save_Click( object sender,EventArgs e)
{
DataTable m_dt = new DataTable();
DataRow博士;
m_dt.Columns.Add( new DataColumn( Br_Name跨度>));
m_dt.Columns.Add( new DataColumn( Br_BeddedHospital跨度>));
m_dt.Columns.Add( new DataColumn( Br_Director跨度>));
m_dt.Columns.Add( new DataColumn( Br_Since跨度>));
m_dt.Columns.Add( new DataColumn( Br_Fax跨度>));
m_dt.Columns.Add( new DataColumn( Br_Address跨度>));
m_dt.Columns.Add( new DataColumn( Br_Phone_No1跨度>));
m_dt.Columns.Add( new DataColumn( Br_E_Mail_Id跨度>));
foreach (GridViewRow gvr in grv_Child.Rows)
{
dr = m_dt.NewRow();
dr [ Br_Name] =((标签)gvr.Cells [ 1 ]。FindControl( Label1))。文本;
dr [ Br_BeddedHospital] =((Label)gvr.Cells [ 2 ]。FindControl( Label2))。文本;
dr [ Br_Director] =((标签)gvr.Cells [ 3 ]。FindControl( Label3))。文本;
dr [ Br_Since] =((标签)gvr.Cells [ 4 ]。FindControl( Label4))。文本;
dr [ Br_Fax] =((Label)gvr.Cells [ 5 ]。FindControl( Label5))。文本;
dr [ Br_Address] =((Label)gvr.Cells [ 6 ]。FindControl( Label6))。文本;
dr [ Br_Phone_No1] =((标签)gvr.Cells [ 7 ]。FindControl( Label7))。文本;
dr [ Br_E_Mail_Id] =((Label)gvr.Cells [ 8 ]。FindControl( Label8))。文本;
m_dt.Rows.Add(dr);
}
grv_BranchDetails.DataSource = m_dt;
grv_BranchDetails.DataBind();
}
您必须连接到您创建的数据库并为SQL Server编写命令。
赞;
protected void btn_Save_Click( object sender,EventArgs e)
{
DataTable m_dt = new DataTable();
DataRow博士;
m_dt.Columns.Add( new DataColumn( Br_Name跨度>));
m_dt.Columns.Add( new DataColumn( Br_BeddedHospital跨度>));
m_dt.Columns.Add( new DataColumn( Br_Director跨度>));
m_dt.Columns.Add( new DataColumn( Br_Since跨度>));
m_dt.Columns.Add( new DataColumn( Br_Fax跨度>));
m_dt.Columns.Add( new DataColumn( Br_Address跨度>));
m_dt.Columns.Add( new DataColumn( Br_Phone_No1跨度>));
m_dt.Columns.Add( new DataColumn( Br_E_Mail_Id跨度>));
foreach (GridViewRow gvr in grv_Child.Rows)
{
dr = m_dt.NewRow();
dr [ Br_Name] =((标签)gvr.Cells [ 1 ]。FindControl( Label1))。文本;
dr [ Br_BeddedHospital] =((Label)gvr.Cells [ 2 ]。FindControl( Label2))。文本;
dr [ Br_Director] =((标签)gvr.Cells [ 3 ]。FindControl( Label3))。文本;
dr [ Br_Since] =((标签)gvr.Cells [ 4 ]。FindControl( Label4))。文本;
dr [ Br_Fax] =((Label)gvr.Cells [ 5 ]。FindControl( Label5))。文本;
dr [ Br_Address] =((Label)gvr.Cells [ 6 ]。FindControl( Label6))。文本;
dr [ Br_Phone_No1] =((标签)gvr.Cells [ 7 ]。FindControl( Label7))。文本;
dr [ Br_E_Mail_Id] =((Label)gvr.Cells [ 8 ]。FindControl( Label8))。文本;
m_dt.Rows.Add(dr);
}
grv_BranchDetails.DataSource = m_dt;
grv_BranchDetails.DataBind();
SqlConnection sconn = new SqlConnection();
sconn.ConnectionString = 此处的连接字符串;
SqlCommand ins = new SqlCommand();
ins.Connection = sconn;
ins.CommandText = 更新yourtable set Br_Name = @ Br_Name,Br_BeddedHospital = @ Br_BeddedHospital, Br_Director = @ Br_Director,Br_Since = @ Br_Since,Br_Fax = @ Br_Fax,Br_Address = @ Br_Address,Br_Phone_No1 = @ Br_Phone_No1,Br_E_Mail_Id = @ Br_E_Mail_Id;
ins.Parameters.AddWithValue( @ Br_Name,yourgrid.Value的ToString());
ins.Parameters.AddWithValue( @ Br_BeddedHospital,yourgrid.Value.ToString() ;
ins.Parameters.AddWithValue( @ Br_Director,yourgrid.Value.ToString( );
ins.Parameters.AddWithValue( @ Br_Since,yourgrid.Value.ToString ();
ins.Parameters.AddWithValue( @ Br_Fax,yourgrid.Value。 ToString();
ins.Parameters.AddWithValue( @ Br_Address,yourgrid.Value .ToString();
ins.Parameters.AddWithValue( @ Br_Phone_No1,yourgrid。 Value.ToString();
ins.Parameters.AddWithValue( @ Br_E_Mail_Id,yourgrid .Value.ToString();
sco nn.Open();
ins.ExecuteNonQuery();
sconn.Close();
}
顺便说一下,你的SQL数据库表名必须与在命令文本中定义的相同; Br_Name,Br_BeddedHospital,Br_Director,Br_Since,Br_Fax,Br_Address,Br_Phone_No1,Br_E_Mail_Id。
我希望这会有所帮助。
你好亲爱的,您需要在DataBase中保存数据表,您必须遵循SQLBulkCopy的概念,这里是您的参考URL。
http://www.4guysfromrolla.com/articles/102109-1.aspx</a> [< a href =target =_ blank>< / a>]
i am writing the code like this...i am getting data to m_dt at last that tabledata will be saved to grid also but it is not saved in database how to save in database pleaseeeeeeeeee
protected void btn_Save_Click(object sender, EventArgs e)
{
DataTable m_dt = new DataTable();
DataRow dr;
m_dt.Columns.Add(new DataColumn("Br_Name"));
m_dt.Columns.Add(new DataColumn("Br_BeddedHospital"));
m_dt.Columns.Add(new DataColumn("Br_Director"));
m_dt.Columns.Add(new DataColumn("Br_Since"));
m_dt.Columns.Add(new DataColumn("Br_Fax"));
m_dt.Columns.Add(new DataColumn("Br_Address"));
m_dt.Columns.Add(new DataColumn("Br_Phone_No1"));
m_dt.Columns.Add(new DataColumn("Br_E_Mail_Id"));
foreach (GridViewRow gvr in grv_Child.Rows)
{
dr = m_dt.NewRow();
dr["Br_Name"] = ((Label)gvr.Cells[1].FindControl("Label1")).Text;
dr["Br_BeddedHospital"] = ((Label)gvr.Cells[2].FindControl("Label2")).Text;
dr["Br_Director"] = ((Label)gvr.Cells[3].FindControl("Label3")).Text;
dr["Br_Since"] = ((Label)gvr.Cells[4].FindControl("Label4")).Text;
dr["Br_Fax"] = ((Label)gvr.Cells[5].FindControl("Label5")).Text;
dr["Br_Address"] = ((Label)gvr.Cells[6].FindControl("Label6")).Text;
dr["Br_Phone_No1"] = ((Label)gvr.Cells[7].FindControl("Label7")).Text;
dr["Br_E_Mail_Id"] = ((Label)gvr.Cells[8].FindControl("Label8")).Text;
m_dt.Rows.Add(dr);
}
grv_BranchDetails.DataSource = m_dt;
grv_BranchDetails.DataBind();
}
edit:
protected void btn_Save_Click(object sender, EventArgs e) { DataTable m_dt = new DataTable(); DataRow dr; m_dt.Columns.Add(new DataColumn("Br_Name")); m_dt.Columns.Add(new DataColumn("Br_BeddedHospital")); m_dt.Columns.Add(new DataColumn("Br_Director")); m_dt.Columns.Add(new DataColumn("Br_Since")); m_dt.Columns.Add(new DataColumn("Br_Fax")); m_dt.Columns.Add(new DataColumn("Br_Address")); m_dt.Columns.Add(new DataColumn("Br_Phone_No1")); m_dt.Columns.Add(new DataColumn("Br_E_Mail_Id")); foreach (GridViewRow gvr in grv_Child.Rows) { dr = m_dt.NewRow(); dr["Br_Name"] = ((Label)gvr.Cells[1].FindControl("Label1")).Text; dr["Br_BeddedHospital"] = ((Label)gvr.Cells[2].FindControl("Label2")).Text; dr["Br_Director"] = ((Label)gvr.Cells[3].FindControl("Label3")).Text; dr["Br_Since"] = ((Label)gvr.Cells[4].FindControl("Label4")).Text; dr["Br_Fax"] = ((Label)gvr.Cells[5].FindControl("Label5")).Text; dr["Br_Address"] = ((Label)gvr.Cells[6].FindControl("Label6")).Text; dr["Br_Phone_No1"] = ((Label)gvr.Cells[7].FindControl("Label7")).Text; dr["Br_E_Mail_Id"] = ((Label)gvr.Cells[8].FindControl("Label8")).Text; m_dt.Rows.Add(dr); } grv_BranchDetails.DataSource = m_dt; grv_BranchDetails.DataBind(); }
You have to make connection to the database you''ve created and write command for SQL Server.
Like;
protected void btn_Save_Click(object sender, EventArgs e) { DataTable m_dt = new DataTable(); DataRow dr; m_dt.Columns.Add(new DataColumn("Br_Name")); m_dt.Columns.Add(new DataColumn("Br_BeddedHospital")); m_dt.Columns.Add(new DataColumn("Br_Director")); m_dt.Columns.Add(new DataColumn("Br_Since")); m_dt.Columns.Add(new DataColumn("Br_Fax")); m_dt.Columns.Add(new DataColumn("Br_Address")); m_dt.Columns.Add(new DataColumn("Br_Phone_No1")); m_dt.Columns.Add(new DataColumn("Br_E_Mail_Id")); foreach (GridViewRow gvr in grv_Child.Rows) { dr = m_dt.NewRow(); dr["Br_Name"] = ((Label)gvr.Cells[1].FindControl("Label1")).Text; dr["Br_BeddedHospital"] = ((Label)gvr.Cells[2].FindControl("Label2")).Text; dr["Br_Director"] = ((Label)gvr.Cells[3].FindControl("Label3")).Text; dr["Br_Since"] = ((Label)gvr.Cells[4].FindControl("Label4")).Text; dr["Br_Fax"] = ((Label)gvr.Cells[5].FindControl("Label5")).Text; dr["Br_Address"] = ((Label)gvr.Cells[6].FindControl("Label6")).Text; dr["Br_Phone_No1"] = ((Label)gvr.Cells[7].FindControl("Label7")).Text; dr["Br_E_Mail_Id"] = ((Label)gvr.Cells[8].FindControl("Label8")).Text; m_dt.Rows.Add(dr); } grv_BranchDetails.DataSource = m_dt; grv_BranchDetails.DataBind(); SqlConnection sconn = new SqlConnection(); sconn.ConnectionString = "your connection string here"; SqlCommand ins = new SqlCommand(); ins.Connection = sconn; ins.CommandText = "update yourtable set Br_Name=@Br_Name, Br_BeddedHospital=@Br_BeddedHospital, Br_Director=@Br_Director, Br_Since=@Br_Since, Br_Fax=@Br_Fax, Br_Address=@Br_Address, Br_Phone_No1=@Br_Phone_No1, Br_E_Mail_Id=@Br_E_Mail_Id"; ins.Parameters.AddWithValue("@Br_Name",yourgrid.Value.ToString()); ins.Parameters.AddWithValue("@Br_BeddedHospital",yourgrid.Value.ToString(); ins.Parameters.AddWithValue("@Br_Director",yourgrid.Value.ToString(); ins.Parameters.AddWithValue("@Br_Since",yourgrid.Value.ToString(); ins.Parameters.AddWithValue("@Br_Fax",yourgrid.Value.ToString(); ins.Parameters.AddWithValue("@Br_Address",yourgrid.Value.ToString(); ins.Parameters.AddWithValue("@Br_Phone_No1",yourgrid.Value.ToString(); ins.Parameters.AddWithValue("@Br_E_Mail_Id",yourgrid.Value.ToString(); sconn.Open(); ins.ExecuteNonQuery(); sconn.Close(); }
By the way your SQL databases table names must be as same as you define at command text like; Br_Name, Br_BeddedHospital, Br_Director, Br_Since, Br_Fax, Br_Address,Br_Phone_No1, Br_E_Mail_Id.
I hope this will help.
Hi Dear you need to save datatable in DataBase you must follow concept of SQLBulkCopy, here is URL for your refrence.
http://www.4guysfromrolla.com/articles/102109-1.aspx</a>[<a href="" target="_blank"></a>]
这篇关于将数据从一个网格存储到另一个网格,也存储到sqlserver2008(DataBase)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!