i hav a parameter procedure in mysql i have to insert value in table through it .
the scenario is as below
three radio button is there how can i get text of all these button in one procedure
string landline = txtcountry.Text + txtcity1.Text + txtphone.Text;
MySqlConnection con = new MySqlConnection("server=localhost;database=infrainvest;uid=root;pwd=root123");
MySqlCommand cmd = new MySqlCommand("regis", con);
cmd.Parameters.Add("utype", rbtnindividual.Text);// here i hav to pass radio button text on desire selection of user
cmd.Parameters.Add("uname", txtname.Text);
cmd.Parameters.Add("uemail", txtemail.Text);
cmd.Parameters.Add("upwd", txtpassword.Text);
cmd.Parameters.Add("mobile", txtmobile.Text);
cmd.Parameters.Add("landln",landline);
cmd.Parameters.Add("city",ddlcity.Text);
//cmd.Parameters.Add("@message", MySqlDbType.VarChar, 50);
//cmd.Parameters["@message"].Direction = ParameterDirection.Output;
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.ExecuteNonQuery();
//Label2.Text = (string)cmd.Parameters["@message"].Value;
con.Close();
Reply |
Reply with attachment |
Alert Moderator