城杆

  public DataSet GetPrice(string prdno, DateTime datetime, string shwotop1)
        {


            SqlParameter[] parameter ={
                new SqlParameter("@PrdtNO",SqlDbType.VarChar,7),
                new SqlParameter("@DATETIME",SqlDbType.DateTime,10),
                new SqlParameter("@TOP1",SqlDbType.VarChar,1)
            };
            parameter[0].Value = prdno;
            parameter[1].Value = datetime;
            parameter[2].Value = shwotop1;

            return DbHelperSQL.RunProcedure("sp_OP_Prdt_Alert查產品報價提示", parameter,"sp_alert");
        }

  QST qst = new QST();
    protected void Page_Load(object sender, EventArgs e)
    {
        DateTime dtte = Convert.ToDateTime("2003-04-01");
        this.GridView1.DataSource = qst.GetPrice("2020044", dtte, "");
        this.GridView1.DataBind();
    }