想要使用面板中的SP从sql数据库中检索radiobutton检查值

问题描述

SqlConnection con = new SqlConnection("server=localhost;database=bankadmin;Integrated Security=SSPI");

protected void Page_Load(object sender, EventArgs e)
{
    Panel1.Visible = true;
}


protected void Button1_Click(object sender, EventArgs e)
{
    Panel1.Visible = true;
    SqlCommand cmd = new SqlCommand("select * from bankadmin where Accountno=@Accountno");
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.CommandText = "spbankregsearch";
    
    SqlParameter p1 = new SqlParameter("@Gender", SqlDbType.VarChar);
    p1.Direction = ParameterDirection.Output;
    cmd.Parameters.Add(p1);

    con.Open();
    cmd.ExecuteNonQuery();
    con.Close();
    RadioButtonList1.SelectedValue = p1.ToString();
}

推荐答案

这篇关于想要使用面板中的SP从sql数据库中检索radiobutton检查值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！