How do I insert data into table

Question

0.00/5 (No votes)

See more:

I have this code in c# to insert data into table programmatically:

 using (SqlConnection conn = new SqlConnection(@"Data source = xxxx; Database=xxxxx; User Id=xxxx; Password=xxxx"))
{
 conn.Open();
 string sqlQuery = @"INSERT INTO UXFaturas(TransDocument, TransSerial, TransDocNumber, 
 Data, Estado) VALUES (@transdocument, @transserial, @transdocnumber, @data, @estado)";
 MessageBox.Show("step1");
 SqlCommand SQLcm = new SqlCommand();
 SQLcm.Connection = conn;
 SQLcm.CommandText = sqlQuery;
 SQLcm.CommandType = CommandType.Text;
 MessageBox.Show("step2");
 SQLcm.Parameters.AddWithValue("@transdocument", transdocument);
 SQLcm.Parameters.AddWithValue("@transsarial", transserial);
 SQLcm.Parameters.AddWithValue("@transdocnumber", transdocnumber);
 SQLcm.Parameters.AddWithValue("@data", data);
 SQLcm.Parameters.AddWithValue("@estado", estado);
 MessageBox.Show("step3");
 SQLcm.ExecuteNonQuery();
 MessageBox.Show("inseriu");
 conn.Close();
}

What I have tried:

I've added the three messagebox.show("");to know where the program stops working but it goes through all three steps and just skips the SQLcm.ExecuteNonQuery();.
I can provide the code to create the table and the variables if you need.

Posted 22-Aug-17 22:42pm

Member 13356973

Updated 22-Aug-17 23:00pm

v2

Add a Solution

Comments

Nowfer Rifkan 23-Aug-17 5:07am

Simply you use this code to insert the data into database
one more thing , create you connection string in global so you can call it whenever you want to use it.... if u write the connection string for all the parts then it won't be a healthy programming. anyway use this code to insert data simply into database

try
{
using (SqlConnection conn = new SqlConnection("Put ur connection string here"))
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into TableName(Column Ids) values('" + values + "')", conn);
cmd.ExecuteNonQuery();
conn.Close();
messagebox.show("Your message here");

}

}
catch (Exception ex)
{
throw ex;
}

Member 13356973 23-Aug-17 5:09am

I'll try this, thanks

Nowfer Rifkan 23-Aug-17 5:13am

it will definitely work... if anything let us know.... good luck

Member 13356973 23-Aug-17 5:18am

I've tried this and got this error: System.InvalidOperationException: 'ExecuteNonQuery: Connection property has not been initialized.'

Patrice T 23-Aug-17 18:48pm

Use Improve question to update your question.
So that everyone can pay attention to this information.

Member 13356973 24-Aug-17 4:29am

My problem as been solved by Mohamed Rifkan

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2017-08-22T22:58:00

Chances are that something to do with your request is failing and that is throwing an exception that is being caught elsewhere.
Change the line to this:

C#

rowsAffected = SQLcm.ExecuteNonQuery();

And add this line at the top of the method:

C#

int rowsAffected = -1;

Now encase that code in a try...catch block and add breakpoints on the ExecuteNonQuery line, and inside the catch block.
Run your code again inside the debugger (you can remove the MessageBoxes for this) and watch what happens. When you run the ExecuteNonQuery statement, one of two things will happen. The first is that control will move to the catch block, and you can look at the exception detail to see why. The other is that rowsAffected will get set to the number of rows inserted. If that's 1, then fine. If not ... well, the catch block should have caught it!

Try that, and see what you find.