像这样使用

Use like this

sqlDataSource1.SelectCommand = "spGetProductDetails";
sqlDataSource1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
 
sqlDataSource1.SelectParameters.Add("code",TypeCode.String, "1");
sqlDataSource1.SelectParameters[0].Direction =ParameterDirection.Input; 
 
GridView1.DataSource = sqlDataSource1;
GridView1.DataBind();

Check这是获取更多信息...

http://forums.asp.net/t /1115044.aspx/1 [ ^ ]

cmd.Parameters.AddWithValue("@parameterName",parameterValue);

hi，

SqlCommand sqlCmd = new SqlCommand("[usp_PBCustomWorkFlowJobsList_GroupBy]", sqlcon);
       sqlCmd.CommandType = CommandType.StoredProcedure;
       SqlDataAdapter dataAdapter = new SqlDataAdapter();
       SqlParameter[] sqlparam = new SqlParameter[1];
       sqlparam[0] = new SqlParameter("UserId", SqlDbType.Int);
       sqlparam[0].Value = 148291;
       sqlCmd.Parameters.Add(sqlparam[0]);

或

or

con.Open();
           SqlCommand cmd = new SqlCommand("sp_questions", con);
           cmd.CommandType = CommandType.StoredProcedure;
           cmd.Parameters.Add(new SqlParameter("@question", "sai"));
           cmd.Parameters.Add(new SqlParameter("@answer", 2));
           cmd.Parameters.Add(new SqlParameter("@option1", "saddf"));
           cmd.Parameters.Add(new SqlParameter("@option2", "sagdf"));
           SqlDataReader rdr = cmd.ExecuteReader();
           con.Close();