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 )

Mani Kandan · 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(usernamepassswordemail)values(' +txt1.Text+ '' +txt2.Text+ '' +txt3.Text+ ') con); insert.ExecuteNonQuery(); con.close();

Mani Kandan · Answer

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