[Message Deleted]

[musefan]

Vivek Vijayan wrote:

i don feel that pasting the code for close is necessary....

Your right, it is not necessary... when you provide a better description of what the problem is. But as everyone is having to guess how bad your code is, people are going to ask questions.

Life goes very fast. Tomorrow, today is already yesterday.

[moon_stick]

A database profiler is a tool which monitors a database and reports back when certain events occur, such as connections to the database, queries, triggers etc. SQL Server comes with its own profiler called (originally enough) SQL Server Profiler - I don't tend to use other databases but I'm sure there are similar tools available for other platforms.

It definitely isn't definatley

[Vivek Vijayan]

yes i tried specifying the columns but no use any prob with insert query????? String query = "insert into mydb(username,password) values('" + textBox1.Text + "','" + textBox2.Text + "')";

This code was posted by me...

[Vivek Vijayan]

i debuggged the code but no exception is caught may be prob with insert statemnt??? any prob with insert query????? String query = "insert into mydb(username,password) values('" + textBox1.Text + "','" + textBox2.Text + "')";

This code was posted by me...

[Vivek Vijayan]

this community is for helping not for findng mistakes only

This code was posted by me...

[musefan]

try... INSERT INTO mydb ([username],[password]) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "') Also... - Confirm that 'mydb' is a table name and not the name of your database. - make sure your database columns have the corrent datatype - look into using parameters

Life goes very fast. Tomorrow, today is already yesterday.

[Vivek Vijayan]

do we use cmd.ExecuteNonQuery() for inserting??

This code was posted by me...

[moon_stick]

Try changing your code to this:

SqlConnection con = connection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
cmd.Dispose();

and see if you get an exception - if the insert has failed, the database should indicate this.

It definitely isn't definatley

[moon_stick]

Yes that's fine. Broadly speaking, you use ExecuteNonQuery() to execute a SQL statement that doesn't return a result set, ExecuteQuery() to execute a statement that returns tabular data and ExecuteScalar() to execute a query which returns a single value (i.e. if you've done a count(*) or other scalar operation).

It definitely isn't definatley

[musefan]

Vivek Vijayan wrote:

this community is for helping not for findng mistakes only

Finding mistakes is helping

Life goes very fast. Tomorrow, today is already yesterday.