retrieving textbox data to sql from asp.net

Question

i have a code to move data from asp.net (c# code) to sql. In the following code i have inserted values directly (i.e) xxx and yyy.This works too. Now i want to insert the values which was entered in text boxes. What will be the code to do so?. Help me friends.

protected void Button2_Click(object sender, EventArgs e)
{ 
    string  comm="insert into login values('xxx','yyy')";
    con = new SqlConnection();
    con.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ConnectionString.ToString();
    cmd = new SqlCommand(comm, con);
    cmd.Connection.Open();
    con.Open();
    int i = cmd.ExecuteNonQuery();
    cmd.Connection.Close();  
}

TBohnen.jnr · Accepted Answer · 2011-05-12 11:24:31Z

2

protected void Button2_Click(object sender, EventArgs e) 
{ 
     string  comm="insert into login values(@val1,@val2)";         
    con = new SqlConnection();         
    con.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ConnectionString.ToString();         
    cmd = new SqlCommand(comm, con);         
    cmd.Connection.Open();

    cmd.Parameters.Add("@val1",TextBox1.Text); //Replace TextBox1.Text with your first textbox
    cmd.Parameters.Add("@val2",TextBox2.Text); //Replace TextBox2.Text with your second textbox         

    con.Open();         
    int i = cmd.ExecuteNonQuery();         
    cmd.Connection.Close();      
}

edited May 12, 2011 at 11:24

answered May 12, 2011 at 9:52

TBohnen.jnr

5,1191 gold badge22 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

anvisha Over a year ago

also, i tried with "insert into login values('" + TextBox1.Text + "','" + TextBox2.Text + "')";

TBohnen.jnr Over a year ago

@anvisha Pleasure, please don't use: ('" + TextBox1.Text + "','" + TextBox2.Text + "') as that opens it up to sql injection which isn't good, a quick google will show you why. Please also remember to mark as correct.

Collectives™ on Stack Overflow

retrieving textbox data to sql from asp.net

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related