如何在GridView中显示来自SQL Server的数据 [英] how to display data from sql server in gridview

问题描述

如何使用asp.net和C#在gridview中显示来自sqlsrver的数据

how to display data from sqlsrver in gridview using asp.net and C#

推荐答案

这是一个使用SqlDataSource填充GridView的示例:

Hi,
This is a sample which SqlDataSource is used to fill the GridView:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

    DataKeyNames="ProductID" DataSourceID="ProductsDataSource"

    EnableViewState="False">
    <Columns>
        <asp:BoundField DataField="ProductID" HeaderText="ProductID"

            InsertVisible="False" ReadOnly="True" SortExpression="ProductID" />
        <asp:BoundField DataField="ProductName" HeaderText="Product Name"

            SortExpression="ProductName" />
        <asp:BoundField DataField="UnitPrice" HeaderText="Price"

            SortExpression="UnitPrice" DataFormatString="{0:c}"

            HtmlEncode="False" />
    </Columns>
</asp:GridView>

<asp:SqlDataSource ID="ProductsDataSource" runat="server"

    ConnectionString="<%

ConnectionStrings:ConnectionStringNameInConfigFile ％> " SelectCommand =" 从[产品]中选择[产品ID]，[产品名称]，[单价]" < /asp:SqlDataSource >

ConnectionStrings:ConnectionStringNameInConfigFile %>" SelectCommand="SELECT [ProductID], [ProductName], [UnitPrice] FROM [Products]"> </asp:SqlDataSource>

希望对您有所帮助，
欢呼

I hope it will help,
Cheers

尝试向该示例学习:
http://www.dotnetspark.com/kb/643-how-to-editupdatedelete- gridview.aspx [ ^ ]

有关更多信息，请参考:
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.aspx [ ^ ]

try to learn from this sample:
http://www.dotnetspark.com/kb/643-how-to-editupdatedelete-gridview.aspx[^]

for more information refer:
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.aspx[^]

这篇关于如何在GridView中显示来自SQL Server的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！