DataView控件解决思路

DataView控件
各位大神 求教下怎么把数据库里面的数据 添加到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>

[解决办法]

C# code

        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();