选定的行在父网格中保存问题 [英] Selected row Save problem in parent Grid

问题描述

我想在父gridview中保存选定的行，如何选择特定的行并保存在数据库中，您可以帮助我任何正文吗?

I want to save Selected row in parent gridview how to select particular row and save in database can u help me any body

推荐答案

请参阅以下内容可能对您有帮助:

http://stackoverflow.com/Questions/2680664/how-to-insert-selected-rows-value-of-gridview-to-to-to-insert-rows-value-of-gridview-into-database-in-net [ ^ ]

看到一次.这不是您问题的确切解决方案，但可以给您一些想法

http://www.eggheadcafe.com/community/asp-net/17/10336021/saving-selected-rows-in-gridview-table-to-access-database.aspx [

Refer this may help you:

http://stackoverflow.com/questions/2680664/how-to-insert-selected-rows-value-of-gridview-into-database-in-net[^]

See this once. It is not exact solution for your question but give you some idea

http://www.eggheadcafe.com/community/asp-net/17/10336021/saving-selected-rows-in-gridview-table-to-access-database.aspx[^]

本示例将指导您.

Hi ,
This Example will guide you .

protected void Page_Load(object sender, EventArgs e)
   {
       if (!IsPostBack)
       {
           SqlConnection con = new SqlConnection(@"Data Source=IT-DEV2\SQLEXPRESS;Initial Catalog=test;Integrated Security=True");
           string statment = "select item_code, Item_name, brand, size, section, price, Material, Qty, tax, tt  from Items ";
           SqlDataAdapter da = new SqlDataAdapter(statment, con);
           DataSet ds = new DataSet();
           da.Fill(ds);
           GridView1.DataSource = ds.Tables[0];
           GridView1.DataBind();
       }
   }
   protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
   {
       string  v1 = GridView1.Rows[e.NewSelectedIndex].Cells[1].Text;
       string v2 = GridView1.Rows[e.NewSelectedIndex].Cells[1].Text;
       string v3 = GridView1.Rows[e.NewSelectedIndex].Cells[1].Text;
       string v4 = GridView1.Rows[e.NewSelectedIndex].Cells[1].Text;
       SqlConnection con = new SqlConnection(@"Data Source=IT-DEV2\SQLEXPRESS;Initial Catalog=test;Integrated Security=True");
       con.Open();
       string statment = string.Format("insert into Items (Item_name, brand, size, section) values ('{0}' ,' {1}' , {2} , '{3}' )", v1,v2,Convert.ToInt32( v3),v4);
         SqlCommand cmd = new SqlCommand(statment,con);
       cmd.CommandType =  CommandType.Text;
       cmd.ExecuteNonQuery();
       cmd.Dispose();
       con.Close();

   }

<div>
       <asp:GridView ID="GridView1" runat="server"

           onselectedindexchanging="GridView1_SelectedIndexChanging">
           <Columns>
               <asp:CommandField ShowSelectButton="True" />
           </Columns>
       </asp:GridView>
   </div>

最好的问候
米特瓦里(M.Mitwalli)

Best Regards
M.Mitwalli

这篇关于选定的行在父网格中保存问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！