DataView控件

Question

各位大神 求教下怎么把数据库里面的数据 添加到DataView里面去 我用的vs2005 前台代码如下：
<table style="margin:10px 20px">
            <asp:ScriptManager id="ScriptManager1" runat="server">
            </asp:ScriptManager> 
       <tr>
           <td>店柜代码：
           <asp:TextBox ID="strecode" runat="server"></asp:TextBox>
             &nbsp;&nbsp;
           <button id="chax" runat="server" class="btn3_mouseout" onmouseover="this.className='btn3_mouseover'" onmouseout="this.className='btn3_mouseout'" onmousedown="this.className='btn3_mousedown'" onmouseup="this.className='btn3_mouseup'" style="width: 80px; height: 25px;" onserverclick="save_ServerClick">查询</button>
            &nbsp;&nbsp;
            <%--<button id="del" runat="server" class="btn3_mouseout" onmouseover="this.className='btn3_mouseover'" onmouseout="this.className='btn3_mouseout'" onmousedown="this.className='btn3_mousedown'" onmouseup="this.className='btn3_mouseup'" style="width: 80px; height: 25px;" onserverclick="del_ServerClick">删除</button>
           </td>--%>
       </tr>
       <tr>
       
      <td style="height: 416px;  width:500px">
      <hr style="size:0; height:0;"/><br />
                <asp:Panel ID="Panel1" runat="server" Width="100%" Height="400px"  ScrollBars="Vertical" >
            <asp:UpdatePanel id="UpdatePanel2" runat="server">
                <ContentTemplate>
                <asp:DataGrid ID="DataGrid1" runat="server" AllowSorting="True" AutoGenerateColumns="False"  CellPadding="4" ForeColor="#333333" GridLines="None"  DataKeyField="usercode" Width="100%">
                <Columns>
                <asp:ButtonColumn CommandName="Select" Text="选择">
                    <HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" Wrap="False" />
                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" Wrap="False" />
                </asp:ButtonColumn>
                <asp:BoundColumn DataField="storecode" HeaderText="店柜代码" SortExpression="ColorCode">
                    <HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" Wrap="False" />
                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" Wrap="False" />
                </asp:BoundColumn>
                <asp:BoundColumn DataField="transdate" HeaderText="时间" SortExpression="ColorCode">
                    <HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" Wrap="False" />
                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" Wrap="False" />
                </asp:BoundColumn>
                <asp:BoundColumn DataField="state" HeaderText="次数">
                    <HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" Wrap="False" />
                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" Wrap="False" />
                </asp:BoundColumn>
                <asp:BoundColumn DataField="ts_id" HeaderText="修改时间" SortExpression="ColorCode">
                    <HeaderStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" Wrap="False" />
                    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
                        Font-Underline="False" Wrap="False" />
                </asp:BoundColumn>
                </Columns>
                <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" Wrap="False" />
                <EditItemStyle BackColor="#2461BF" Wrap="False" />
                <SelectedItemStyle BackColor="#8080FF" Font-Bold="True" ForeColor="#333333" Wrap="False" />
                <PagerStyle BackColor="#C9C9C9" ForeColor="Blue" HorizontalAlign="Center" Wrap="False"  />
                <AlternatingItemStyle BackColor="White" Wrap="False" />
                <ItemStyle BackColor="#EFF3FB" Wrap="False" />
                <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" Wrap="False" />
                </asp:DataGrid>
                </ContentTemplate>
                </asp:UpdatePanel>
                </asp:Panel>
              </td>

Answer 1

        OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=c:\\txl.mdb");
        con.Open();
        string sql = "select * from stuff";
        OleDbDataAdapter da = new OleDbDataAdapter(sql, con);
        DataSet ds = new DataSet();
        da.Fill(ds, "stuff");//填充到ds
        GridView1.DataSource = ds.Tables["stuff"];
        GridView1.DataBind();你可以在界面上给GridView1添加列，并绑定字段脚本如下    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        onselectedindexchanged="GridView1_SelectedIndexChanged" 
        onrowcommand="GridView1_RowCommand" 
        onrowdatabound="GridView1_RowDataBound" 
        onrowcreated="GridView1_RowCreated">
        <Columns>
            <asp:HyperLinkField DataNavigateUrlFields="StaName" DataTextField="StaName" 
                HeaderText="姓名" />
            <asp:BoundField DataField="RefName" HeaderText="Ref" />
            <asp:ButtonField ButtonType="Button" Text="按钮" />
        </Columns>
    </asp:GridView>

Answer 2

        DataView dv = new DataView();
        dv = wyj.wyj_select_les_storeValidate();
        dv.Sort = SortExpression + " " + SortDirection;
        DataGrid1.DataSource = dv;
        DataGrid1.DataBind();怎么可以嘛wyj.wyj_select_les_storeValidate(); 
         后台的类文件