C#調用預存程序

標籤：io   ar   資料   cti   sp   on   c   ad   new   

        protected void btnQuery_Click(object sender, EventArgs e)        {                using (SqlConnection con =                    new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))                {                    using (SqlCommand cmd = con.CreateCommand())                    {                        cmd.CommandText = "test2";                        cmd.CommandType = CommandType.StoredProcedure;                        con.Open();                        SqlParameter id = new SqlParameter("@id", SqlDbType.TinyInt);                        id.Value = txtId.Text;                        id.Direction = ParameterDirection.Input;                        cmd.Parameters.Add(id);                        SqlParameter name = new SqlParameter("@name", SqlDbType.VarChar, 20);                        name.Direction = ParameterDirection.Output;                        cmd.Parameters.Add(name);                        SqlParameter age = new SqlParameter("@age", SqlDbType.TinyInt);                        age.Direction = ParameterDirection.Output;                        cmd.Parameters.Add(age);                       // cmd.ExecuteNonQuery();                       // lblResult.Text = "姓名:" + name.Value + "\n" + "年齡:" + age.Value;                        SqlDataReader dr = cmd.ExecuteReader();                        if (dr.Read())                        {                            lblResult.Text = "姓名:" + name.Value + "\n" + "年齡:" + age.Value;                        }                        else                        {                            lblResult.Text = "沒有資料";                        }                      }                }            }

C#調用預存程序