multiple statements through single procedure by appcode clas

Hi,

Below lines to be updated/added -

cmd.CommandType = CommandType.StoredProcedure;

Hi,

If you are stored procedure, just check below link to understand how to call stored procedure from C#. In case of any further clarification, just write here -

http://www.c-sharpcorner.com/article/using-stored-procedures-with-Asp-Net/

MY QUESTION IS. I HAVE ALL QUERIES IN ONE PROCEDURE. BUT NOT ABLE TO ACCESS THESE QUERIES SIMULTANEOUSLY .

cmd.Parameters.AddWithValue("@mode", "update")-- update query execute

is there any way through which i can use these there conditions

because in my code i am using strings and these are not accepting cmd.parameters.AddWithValue ()

like this.

ANOTHER CODE FOR UPDATE. I DON'T WANNA WRITE QUERIES ON THE CODE, I HAVE PROCEDURES BUT MY METHOD DOESN'T ALLOW ME TO USE STORED PROCEDURE OF MULTIPLE QUERIES. BUT I WANNA USE IT. I AM BIGGINER IN ASP.NET AND SQL. PLEASE HELP ME:-

public partial class adminPanel_editCustomer : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{


string un = Request.QueryString.Get("userName").ToString();
string q = "select * from customerRegistration where userName='" + un + "'";
Connections con = new Connections();
con.ExecuteSelect(q);

con.dr.Read();
userNameText.Text = con.dr["userName"].ToString();
clientNameText.Text = con.dr["nameClient"].ToString();
addressText.Text = con.dr["cAddress"].ToString();
cityText.Text = con.dr["city"].ToString();
stateText.Text = con.dr["state"].ToString();
ctDropDownList.Text = con.dr["clientType"].ToString();
cPersonText.Text = con.dr["contactPerson"].ToString();
emailText.Text = con.dr["email"].ToString();
pNumberText.Text = con.dr["phone"].ToString();
mNumberText.Text = con.dr["mobile"].ToString();
vatText.Text = con.dr["vatNumber"].ToString();

}
}
protected void updateButton_Click(object sender, EventArgs e)
{
string un, cn, add, ct, st, cLt, cp, eMail, phn, mob, vat;
un = Request.QueryString.Get(0).ToString();
cn = clientNameText.Text;
add = addressText.Text;
ct = cityText.Text;
st = stateText.Text;
cLt = ctDropDownList.Text;
cp = cPersonText.Text;
eMail= emailText.Text;
phn = pNumberText.Text;
mob = mNumberText.Text;
vat = vatText.Text;

string q = "update customerRegisteration set nameClient='" + cn + "', cAddress='" + add + "', city='" + ct + "', state='" + st + "', clientType='" + cLt + "', contactPerson='" + cp + "', email='" + eMail + "', phone='" + phn + "', mobile='" + mob + "', vatNumber='" + vat + "' where userName='" + un + "'";
Connections con = new Connections();
con.ExecuteNonSelect(q);

exLabel.Text = "Record Updated Successfully.";
}

}

thanks Midhun ji,

i am using this code yet i have stored procedure for SELECT QUERY. i want to use stored procedure there ..... i do not know the method by which i can use procedure.

you can see in this code, when i use stored procedure. i have to use sqlcoonection instead of my connections class.

here is the code:- RED PART IS MY PROBLEM. I AM GETTING EVERYTHING BY THIS CODE BUT IF I AM NOT ABLE TO SELECT SOMTHING FROM PROCEDURE THEN PROCEDURE IS WAIST FOR ME. HOPEYOU CAN UNDERSTAND.

string u, p;
u = userNameText.Text;
p = passwordText.Text;

string q = "select * from userRegister where userName='" + u + "' and password='" + p + "'";

SqlConnection con = new SqlConnection("Data Source=sam-pc;Initial Catalog=decentComputers;uid=sa;pwd=123");
SqlCommand cmd = new SqlCommand(q, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
Response.Redirect("userPanel/queryPage.aspx");
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "validation", "");
}

Hi,

You can use same method in class also. You can pass parameters to your method. What is your issue with using