database connection problem

jeevan mummadi

18y2.8kVisual Basic .NET

private void OnUpdateRichEdit(string msg)

{

SqlConnection con = new SqlConnection("server=localhost;initial catalog=online_application1;user id=sa;pwd=");

//richTextBox1.AppendText(msg);

rtrecvdata.Text = msg;

con.Open();

string st="insert into data(totaldata) values('" + rtrecvdata .Text + "') " ;

SqlCommand cmd = new SqlCommand(st, con);

cmd.ExecuteNonQuery();

con.Close();

}

for every one min data will come into this method,received data is saved in database.but problem is code is executed but data is not saved in database.

tell me the reason...

3 Replies

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

jeevan mummadi18y ago
i placed breakpoint also,but there is no errors.the stmts are executing but data is not saved in db.
0
Dipal Choksi18y ago
(1) Use an Exception handling block and see if you are getting an exception returned from the db

(2) In debug mode, get the contents of the string containing the final SQL statement and run it on the db and see if it is working OK.
0
Ryan Alford18y ago
put a breakpoint where you instantiate the SqlConnection, then step through to see if there is an actual error message.
0