i got the some error

Question

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

Amit Gupta · Answer

@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 Ranpariya · Answer

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.

Dinesh Santhalingam · Answer

protected void btn_Click(object sender, EventArgs e) { string r = @"server=.;database=romesh;trusted_connecton=true"; SqlConnection con = new SqlConnection(r); con.Open(); SqlCommand cmd = con .CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Insert into table1 values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "')"; cmd.ExecuteNonQuery(); con.Close(); TextBox0.Text = "" ; TextBox1.Text = "" ; TextBox2.Text = "" ; MessageBox.Show("Sucessfully Recorded"); } Try like this.Its perfectly worked for me.

Chetan Ranpariya · Answer

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

Santosh Reddy · Answer

please send me sql code ....

Gnanavel Sekar · Answer

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 A · Answer

Please post your error.

Ramesh Palanivel · Answer

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 Palanivel · Answer

Kindly send your table structure and code!..

Santosh Reddy · Answer

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

Ramesh Palanivel · Answer

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 A · Answer

Hey, I think, you have to change your query like this, string i = "INSERT INTO Tble_sample (username,password,email) VALUES('" + textbox1 + "','" + textbox2 + "', '" + textbox3 + "')" ;

i got the some error

Answers (12)