开发者

can we assign object value to the label?

开发者 https://www.devze.com 2022-12-29 15:16 出处:网络
I have a label for that i have to assign object value which is returned by stored procedure.my code as following

I have a label for that i have to assign object value which is returned by stored procedure.my code as following

object returnvalue;
SqlConnection con = new SqlConnection("Data S开发者_JAVA百科ource=vela21;              Initial               Catalog=MilkDb;Integrated Security=True");
con.Open();
string sa;
sa = textBox1.Text;
SqlCommand cmd = new SqlCommand("custname", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Cid", SqlDbType.Int).Value = sa;
cmd.Parameters.Add("cname", SqlDbType.NVarChar, 20);
cmd.Parameters["cname"].Direction = ParameterDirection.Output;
returnvalue = cmd.ExecuteNonQuery();
label3.Text = Convert.ToString(returnvalue);
con.Close();

can anyone help me? plz........


label3.Text = Convert.ToString(cmd.Parameters["cname"].Value);


Yeah. Andrey is right... I had the same answer...

label3.Text = Convert.ToString(cmd.Parameters["cname"].Value); 
0

精彩评论

暂无评论...
验证码 换一张
取 消