如何将选定的行从GRIDVIEW插入到Sqlserver 2005数据库表中。 [英] How to Insert the Selected Row From GRIDVIEW into Sqlserver 2005 Database Table.

问题描述

亲爱的朋友们，



我有一个包含表格数量的数据库。



我有一个表，它将记录显示在gridview中。



我需要在SqlServer 2005数据库中将Gridview Row插入新表。当选择按钮单击Gridview时...... SELECT按钮将是Cell [0]。



如何将选定的行从GRIDVIEW插入到Sqlserver 2005数据库新表中。





请帮帮我，谢谢。

Dear Friends,

I have a Database with No.of Tables in it.

I have a one Table in it, which displays records into gridview.

I need to Insert Gridview Row to New Table in SqlServer 2005 database. when Select button Click in Gridview.....SELECT button will be Cell[0].

How to Insert the Selected Row From GRIDVIEW into Sqlserver 2005 Database New Table.


Please help me, Thanks.

推荐答案

退房以下代码

Check out the following code

protected void grdVacancy_SelectedIndexChanged(object sender, EventArgs e)
    {
       string query= "insert into tablename (columnname) values('"+ grdVacancy.SelectedRow.Cells[1].Text+"')";
    }

标记解决方案如果你得到答案并且不要忘记评价..







谢谢

Ashish

mark it solution if you got your answer and dont forget to rate..



Thanks
Ashish

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        GridViewRow r = GridView1.SelectedRow;
        string strQuery = "insert into table values('" + r.Cells[0] + "','" + r.Cells[1] + "')";
    }

仅在制作代码时有所改进

improved only for making in code

写下你的在 selectedindexchange gridview事件中插入查询。

write your insert query in selectedindexchange event of gridview.

这篇关于如何将选定的行从GRIDVIEW插入到Sqlserver 2005数据库表中。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！