i got the some error

Santosh Reddy

9y1.1k.NET

protected void Page_Load(object sender, EventArgs e)

{

string r = @"server=.;database=romesh;trusted_connecton=true";

SqlConnection con = new SqlConnection(r);

}

protected void btn_insert_Click(object sender, EventArgs e)

{

string i= "insert into sample values('"+txt1.Text+"','"+txt2.Text+"','"+txt3.Text+"')";

con.open();

SqlCommand cmd = con.createcommend();

cmd.CommandType = CommandType.Text;

cmd.CommandText = "i";

cmd.EndExecuteNonQuery();

con.close();

}

// I will get the error my code

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dinesh Santhalingam9y ago
1. protected void btn_Click(object sender, EventArgs e)
2. {
3. string r = @"server=.;database=romesh;trusted_connecton=true";
  SqlConnection con = new SqlConnection(r);
4. con.Open();
5. SqlCommand cmd = con.CreateCommand();
6. cmd.CommandType = CommandType.Text;
7. cmd.CommandText = "Insert into table1 values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "')";
8. cmd.ExecuteNonQuery();
9. con.Close();
10. TextBox0.Text = "";
11. TextBox1.Text = "";
12. TextBox2.Text = "";
13. MessageBox.Show("Sucessfully Recorded");
14. }
Try like this.Its perfectly worked for me.
0

Chetan Ranpariya9y ago

@Santhosh .... did you try the solution I posted?

Santosh Reddy9y ago

please send me sql code ....

Amit Gupta9y ago

@Santosh

Isn't be useful, if you had also mentioned what error did occured?

According to partial code, it have been observed that it will throw compile time error, your code will not get compiled because the connection object has not been accessable on insert method.

Furthermore, you should use your connection from the config file, so that it can be accessed/modified from the central point and will be more maintainable.

Moreover, trying to read the full exception and it will be solved by yourself.

Coming to your partial code

cmd.EndExecuteNonQuery();

will be

cmd.ExecuteNonQuery();

for connection object, you should access from the config file.

Hope you understood :)

Chetan Ranpariya9y ago

You have incorrectly declared objects of SqlConnection.

They should have been declared at the page level of at the function level. You are declaring objects in page_load and trying to use them in btn_inser_Click.

Variables declared in Page_Load are local to it. They are not accessbile in other methods.

So you should do something as following.

private connString = @"server=.;database=romesh;trusted_connecton=true";
private SqlConnection con;
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(connString);
}
protected void btn_insert_Click(object sender, EventArgs e)
{
string commandText= "INSERT INTO SAMPLE VALUES (@value1, @value2, @value3)";
con.open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = commandText;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@value1", txt1.Text);
cmd.Parameters.Add("@value2", txt2.Text);
cmd.Parameters.Add("@value3", txt3.Text);
cmd.ExecuteNonQuery();
con.close();
}

This should resolve all your errors.

Gnanavel Sekar9y ago

you need to open the connection while passing command, so open the connection

example

con.open();

sqlcommand cmd=new sqlcommand("select * from tablename",con)

Abhilash J A9y ago

Please post your error.

Ramesh Palanivel9y ago

Hi santhosh,

I found the issue,

your connection string has issue, declare the connection inside the btn click event,

It should work!..

I think thats the issue !...

Ramesh Palanivel9y ago

Kindly send your table structure and code!..

Santosh Reddy9y ago

change my code but error also will come ......

Ramesh Palanivel9y ago

Hi Santhosh,

try this code,

con.open();
SqlCommand insert=new SqlCommand("insert into sample(username,passsword,email)values('"+txt1.Text+"','"+txt2.Text+"','"+txt3.Text+"')",con);
insert.ExecuteNonQuery();
con.close();

Abhilash J A9y ago

Hey,

I think, you have to change your query like this,

string i = "INSERT INTO Tble_sample (username,password,email) VALUES('"+ textbox1 +"','"+ textbox2 +"', '"+ textbox3 +"')";