在asp.net中操作數據庫的方法

来源：互联网发布：唐山学院网络编辑：程序博客网时间：2024/06/05 02:30

在ado.net中增加了不少新功能

vb.net/////////////////

   Dim strSql As String
        strSql = "SELECT * FROM BOMNOTICE WHERE (RTIME between @BEGTIME and @ENDTIME) "
        Dim da As New (strSql, m_strConn)
        Dim ds As New DataSet
        da.SelectCommand.CommandType = CommandType.Text
        Dim Par1 As New SqlParameter("@BEGTIME", SqlDbType.DateTime)
        Dim Par2 As New SqlParameter("@ENDTIME", SqlDbType.DateTime)
        Par1.Direction = ParameterDirection.Input
        Par2.Direction = ParameterDirection.Input
        da.SelectCommand.Parameters.Add(Par1)
        da.SelectCommand.Parameters.Add(Par2)
        Par2.Value = System.DateTime.Now.AddDays(1)
        Par1.Value = System.DateTime.Now.AddDays(-6)
        da.Fill(ds)
        DataGrid1.DataSource = ds.Tables(0).DefaultView
        DataGrid1.DataBind()

c# ////////////////

string strconn;
   string strSql;
   strconn="data source=MG1116B//AAA;initial catalog=ERPTEST;user =sa;password=zaq12wsx;connection timeout=30";
   strSql="SELECT * FROM BOMHISTRY WHERE TYPE=@TYPE";
   SqlDataAdapter da=new SqlDataAdapter(strSql,strconn);
   SqlParameter Par=new SqlParameter("@TYPE",SqlDbType.NVarChar,10);
   Par.Value=txtMessage.Text;
   da.SelectCommand.Parameters.Add(Par);
   DataSet ds=new DataSet();
   da.Fill(ds,"teng");
   DataGrid1.DataSource=ds.Tables["teng"].DefaultView;
   DataGrid1.DataBind();