我想在按钮上点击sqlserver表数据到asp，C＃.net中的datagrid视图..我想要c＃.net中的代码 [英] i want to fetch sqlserver table data on button click into datagrid view in asp, C#.net.. i want code in c# .net

问题描述

我想获取sqlserver表数据按钮点击进入asp，C＃.net的datagrid视图..我想要c＃.net中的代码

i want to fetch sqlserver table data on button click into datagrid view in asp, C#.net.. i want code in c# .net

推荐答案

<asp:gridview id="GridView1" runat="server" autogeneratecolumns="False" borderwidth="1px" bordercolor="Black" xmlns:asp="#unknown">
 <rowstyle cssclass="RowStyle" backcolor="#C9C9C9" horizontalalign="Center" font-names="Calibri" forecolor="Black" />
 <headerstyle cssclass="HeaderStyle" backcolor="#4DB4EE" horizontalalign="Center" font-names="Calibri" forecolor="Black" />      
 <columns>
     <asp:boundfield datafield="database column" headertext="abc" sortexpression="abc" />
     <asp:boundfield datafield="database column" headertext="xyz" sortexpression="xyz" /> 
 </columns>
 </asp:gridview>                                                             
<asp:button id="Button1" runat="server" text="Update" onclick="Button1_Click" />   

protected void Button1_Click(object sender, EventArgs e)
{ 
      /*Open database connection,fill gridview,close the connection*/
     SqlConnection conn = new SqlConnection();
            conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring name"].ConnectionString;
            conn.Open();    
            string xyz=textbox1.text;
            SqlCommand cmd = new SqlCommand("select * from tablename where name=@xyz", conn);
            cmd.Parameters.Add(new SqlParameter("@xyz",xyz));
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();         
} 

浏览项目 ASP .NET GridView控件演示（CSASPNETGridView） [ ^ ]探索。

这篇关于我想在按钮上点击sqlserver表数据到asp，C＃.net中的datagrid视图..我想要c＃.net中的代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！