我要显示的数据是数据库到网格视图控制 [英] i want to display data that is in database into grid view control

问题描述

我要检索存储在数据库中插入GridView控件的表中的数据和我的ADO code是

 公共无效retrieve_client（）
    {
        SqlConnection的CON =新的SqlConnection（DBconnection.connectstr）;
        con.Open（）;
        COM的SqlCommand =新的SqlCommand（retrieve_clientCON）;
        com.CommandType = CommandType.StoredProcedure;
        com.Parameters.Add（@名，SqlDbType.VarChar）.value的= this.name;
        SqlDataReader的R = com.ExecuteReader（）;
        如果（r.HasRows）
        {
            如果（r.Read（））
            {
                this.name = R [0]的ToString（）;
                this.address = R [1]的ToString（）;
                this.phone = R [1]的ToString（）;
            }
        }
        r.Close（）;
        con.Close（）;
    }
 

和我的web表单来源是我想输入文本框中的名称和检索数据并显示他们到网格视图控件，请回答我：

我的Web表单来源是：

 ＆LT;表＆gt;
＆所述; TR＆GT;
    ＆所述; TD＆GT;        ＆LT;标签类=labelclient＆GT;名称和LT; /标签＆gt;
            ＆LT; / TD＆GT;    ＆LT; TD类=clientpadding＆GT;        ＆LT; ASP：文本框ID =Textbox_retrieveclientbyname_first=服务器占位符=名的CssClass =textboxstyle所需=需要＆GT;＆LT; / ASP：文本框＆GT;        ＆安培; NBSP; ＆安培; NBSP;
            ＆LT; ASP：文本框ID =Textbox_retrieveclientbyname_second=服务器占位符=第二个名字的CssClass =textboxstyle所需=需要＆GT;＆LT; / ASP：文本框＆GT;         ＆安培; NBSP; ＆安培; NBSP;    ＆LT; ASP：文本框ID =Textbox_retrieveclientbyname_third=服务器占位符=第三名的CssClass =textboxstyle所需=需要＆GT;＆LT; / ASP：文本框＆GT;      ＆LT; / TD＆GT;＆LT; / TR＆GT;
＆LT; /表＆gt;
＆LT; BR /＆GT;
＆LT; BR /＆GT;
＆LT;表＆gt;
    ＆所述; TR＆GT;
        ＆LT; TD类=buttontd＆GT;
            ＆LT; ASP：按钮的ID =btn_find_clientbyname=服务器文本=查找的CssClass =addclientbutton的OnClick =btn_find_clientbyname_Click/＆GT;
        ＆LT; / TD＆GT;
        ＆所述; TD＆GT;
            ＆LT; ASP：标签ID =lbl_ermsg=服务器＆GT;＆LT; / ASP：标签＆gt;
        ＆LT; / TD＆GT;
    ＆LT; / TR＆GT;
＆LT; /表＆gt;
＆LT; D​​IV＆GT;
    ＆LT; ASP：GridView控件ID =GridView_clientbyname=服务器＆GT;
        ＆LT; HeaderStyle的CssClass =gridheader/＆GT;
        ＆LT; RowStyle的CssClass =gridrow/＆GT;
        ＆LT; AlternatingRowStyle的CssClass =gridaltrow/＆GT;
    ＆LT; / ASP：GridView的＆GT;
＆LT; / DIV＆GT;
 

`

解决方案

  

使用的DataAdapter 来填充数据表和绑定的 GridView控件随着
  这数据表

 公共无效retrieve_client（）
    {
        SqlConnection的CON =新的SqlConnection（DBconnection.connectstr）;
        con.Open（）;
        COM的SqlCommand =新的SqlCommand（retrieve_clientCON）;
        com.CommandType = CommandType.StoredProcedure;
        com.Parameters.Add（@名，SqlDbType.VarChar）.value的= this.name;
        SqlDataAdapter的大=新SqlDataAdapter的（COM）;
        DataTable的DT =新DatTable（）;
        da.Fill（DT）;
        con.Close（）;
        GridView_clientbyname.DataSource = DT;
        GridView_clientbyname.DataBind（）;    }
 

i want to retrieve the data stored in the table of the database into gridview control and my ado code is

   public void retrieve_client()
    {
        SqlConnection con = new SqlConnection(DBconnection.connectstr);
        con.Open();
        SqlCommand com = new SqlCommand("retrieve_client", con);
        com.CommandType = CommandType.StoredProcedure;
        com.Parameters.Add("@name", SqlDbType.VarChar).Value = this.name;
        SqlDataReader r = com.ExecuteReader();
        if(r.HasRows)
        {
            if(r.Read())
            {
                this.name =    r[0].ToString();
                this.address = r[1].ToString();
                this.phone =   r[1].ToString();
            }
        }
        r.Close();
        con.Close();
    }

and my web form source is i want to enter the name in text box and retrieve the data and displaying them into grid view control please answer me:

my web form source is:

    <table>
<tr>
    <td>

        <label class="labelclient">Name</label>
            </td>

    <td class="clientpadding">

        <asp:TextBox ID="Textbox_retrieveclientbyname_first" runat="server" placeholder=" First Name" cssclass="textboxstyle" required="required"></asp:TextBox>

        &nbsp; &nbsp; 


            <asp:TextBox ID="Textbox_retrieveclientbyname_second" runat="server" placeholder=" Second Name" CssClass="textboxstyle" required="required"></asp:TextBox>

         &nbsp; &nbsp; 

    <asp:TextBox ID="Textbox_retrieveclientbyname_third" runat="server" placeholder=" Third Name" CssClass="textboxstyle" required="required"></asp:TextBox>

      </td>

</tr>
</table>
<br />
<br />
<table>
    <tr>
        <td class="buttontd">
            <asp:Button ID="btn_find_clientbyname" runat="server" Text="Find" CssClass="addclientbutton" OnClick="btn_find_clientbyname_Click"/>
        </td>
        <td>
            <asp:Label ID="lbl_ermsg" runat="server" ></asp:Label>
        </td>
    </tr>
</table>
<div>
    <asp:GridView ID="GridView_clientbyname" runat="server" >
        <HeaderStyle CssClass="gridheader"/>
        <RowStyle CssClass="gridrow" />
        <AlternatingRowStyle cssclass="gridaltrow" />
    </asp:GridView>
</div>

`

解决方案

Use DataAdapter to Fill DataTable And bind the GridView With That DataTable

 public void retrieve_client()
    {
        SqlConnection con = new SqlConnection(DBconnection.connectstr);
        con.Open();
        SqlCommand com = new SqlCommand("retrieve_client", con);
        com.CommandType = CommandType.StoredProcedure;
        com.Parameters.Add("@name", SqlDbType.VarChar).Value = this.name;
        SqlDataAdapter da = New SqlDataAdapter(com);
        DataTable dt=New DatTable();
        da.Fill(dt);
        con.Close();
        GridView_clientbyname.DataSource=dt;
        GridView_clientbyname.DataBind();

    }

这篇关于我要显示的数据是数据库到网格视图控制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！