![]() |
#2
jingshulove2008-02-20 17:26
|
请问以下红色字体那句中的 "GetOrdersInfo"是什么意思啊,,是字符串没错吧,,但也应该要sql的字符串才对啊,
那位高手能帮帮忙解译一下
SqlConnection myConn = new SqlSqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString());
myConn.Open();
SqlCommand cmd = new SqlCommand("GetOrdersInfo",myConn);
= CommandType.StoredProcedure;
SqlParameter userIP = new SqlParameter("@UserIP",SqlDbType.VarChar,50);
userIP.Value = Convert.ToString(Request.UserHostAddress);
cmd.Parameters.Add(userIP );
cmd.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds,"Orders");
GridView1.DataSource = ds.Tables["Orders"].DefaultView;
GridView1.DataBind();
cmd.Dispose();
myConn.Close();