用OleDbDataAdapter如何在程序里动态的写查询，急!!!在线等待

string conn = @"Provider='SQLOLEDB.1';Data Source=d;User ID=sa;Password=123456;Initial Catalog=pubs";OleDbDataAdapter ada = new OleDbDataAdapter("select * from emp",conn);
DataSet set1 = new DataSet();
ada.Fill(set1,"aaa");
this.dataGrid1.DataSource = set1;
this.dataGrid1.DataMember = "aaa";

解决方案 »

  1.   

    <%@ Page Language="C#" Debug="true" %>
    <%@ Import Namespace="System.Data" %>
    <%@ Import Namespace="System.Data.OleDb" %><html><script runat="server">
    //set a variable to hold the sort expression
    String SortExpression;ICollection CreateDataSource() {
    String DataSource = ConfigurationSettings.AppSettings["OleDBDataSource"];
    OleDbConnection conn = new OleDbConnection(DataSource);
    String sql = "Select * FROM Article_menu Order By ArticleName";
    OleDbDataAdapter db_sqladaptor = new OleDbDataAdapter(sql,conn);DataSet ds = new DataSet();
    db_sqladaptor.Fill(ds,"Article_menu");DataView myView = ds.Tables["Article_menu"].DefaultView;
    myView.Sort=SortExpression;conn.Close();return myView;
    }public void Page_Load(Object sender, EventArgs e) 
       {       if (!IsPostBack) {
             Articles.DataSource = CreateDataSource();
             Articles.DataBind();

          }   }   
        void Sort_Grid(Object sender, DataGridSortCommandEventArgs e) 
          {
             SortExpression = e.SortExpression.ToString();
             Articles.DataSource = CreateDataSource();
             Articles.DataBind();
          }   
    </script>
     
    <body><form runat="server">
    <asp:DataGrid id="Articles" runat="server"
    BorderColor="black"
    BorderWidth="1"
    CellPadding="3"
    AutoGenerateColumns="false"        
    AllowSorting="true"
    OnSortCommand="Sort_Grid">
    <Columns>      <asp:BoundColumn
          HeaderText="Article"
               DataField="ArticleName"
               SortExpression ="ArticleName"/>      <asp:BoundColumn
          HeaderText="Summary"
               DataField="ArticleSubText"
               SortExpression ="ArticleSubText"/></Columns>    
    </asp:DataGrid>   </form> 
    </body></html>
      

  2.   

    OleDbDataAdapter ada = new OleDbDataAdapter("select * from emp where key="+Int32.Parse(TextBox1.Text),conn);实现动态交互
      

  3.   

    OleDbDataAdapter Adp = new OleDbDataAdapter("select * from table where fd = 'test'",Conn);
    Adp.Fill(Dst,"table");