procedure getNew
(
@id int,
@revalue varchar(400)
)asselect @revalue=content from news where id=@id
return @revalue
SqlConnection conn=new SqlConnection(ConfigurationManager.AppSettings["Connstr"]);
SqlCommand cmd = new SqlCommand("getNew", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parContent = new SqlParameter("revalue", SqlDbType.VarChar, 400);
parContent.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parContent);
SqlParameter parID = new SqlParameter("@id", SqlDbType.Int);
parID.Value = strID;
cmd.Parameters.Add(parID);
conn.Open();
cmd.ExecuteNonQuery();
string strContent = parContent.Value.ToString();
conn.Close();哪里错了哈。。获取content字段值!
(
@id int,
@revalue varchar(400)
)asselect @revalue=content from news where id=@id
return @revalue
SqlConnection conn=new SqlConnection(ConfigurationManager.AppSettings["Connstr"]);
SqlCommand cmd = new SqlCommand("getNew", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parContent = new SqlParameter("revalue", SqlDbType.VarChar, 400);
parContent.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parContent);
SqlParameter parID = new SqlParameter("@id", SqlDbType.Int);
parID.Value = strID;
cmd.Parameters.Add(parID);
conn.Open();
cmd.ExecuteNonQuery();
string strContent = parContent.Value.ToString();
conn.Close();哪里错了哈。。获取content字段值!
楼主不防试下下面的代码:
procedure getNew
(
@id int,
@revalue varchar(400) output
) as select @revalue=content from news where id=@id
///
cmd.Parameters["parContent"].Value.ToString();