通过在Gridview中选择值来使用sqlDataReader绑定文本框? [英] Bind textbox by using sqlDataReader by selecting value in Gridview ?

问题描述

如何通过在Gridview中选择值来使用sqlDataReader绑定文本框?

*文本框不在gridview中.

我的代码是:

Hi,

How do I bind textbox by using sqlDataReader by selecting value in Gridview?

* Textbox not in gridview.

My Code is:

protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
    {   
        SqlConnection conn = new SqlConnection(ConnString);
        SqlCommand cmd = new SqlCommand("Select  * from Customer where Sr_No='" +   GridView2.EditIndex + "' ", conn);

        conn.Open();
        SqlDataReader reader = cmd.ExecuteReader();
        reader.Read();
        {
            txtCity.Text = reader["City"].ToString();          
            reader.Close();
        }
        conn.Close();     
    }

我的HTML代码是:

My HTML Code is:

City : <asp:textbox id="txtCity" runat="server" />
<asp:gridview id="GridView2" runat="server" autogeneratecolumns="False"

AutoGenerateDeleteButton="True"

onrowdeleting="GridView2_RowDeleting" DataKeyNames="Sr_No"

onrowediting="GridView2_RowEditing"

onselectedindexchanged="GridView2_SelectedIndexChanged" >
    <asp:boundfield headertext="Sr_No" datafield="Sr_No"

    <headerstyle forecolor="CadetBlue" />

    <asp:boundfield headertext="City" datafield="City"

    <headerstyle forecolor="CadetBlue" />

    <asp:commandfield showeditbutton="True" showcancelbutton="false" />
<asp:gridview />

推荐答案

try这个..

try this ..

protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
    {   
        SqlConnection conn = new SqlConnection(ConnString);

        int srNo = Convert.ToInt32(GridView1.DataKeys[e.NewEditIndex].Value);
        SqlCommand cmd = new SqlCommand("Select  * from Customer where Sr_No= @SrNo", conn);
        Cmd.parameters.AddwithValue("@SrNo",srNo);
 
        conn.Open();
        SqlDataReader reader = cmd.ExecuteReader();
        reader.Read();
        {
            txtCity.Text = reader["City"].ToString();          
            reader.Close();
        }
        conn.Close();     
    }

这篇关于通过在Gridview中选择值来使用sqlDataReader绑定文本框?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！