Insert Data into Table Problem

Question

5.00/5 (1 vote)

See more:

Hey everyone.

I have a question to ask.

I've a database that has 2 table. One of them is calles Ortam.

Ortam have 4 attributes in it.

- OrtamKB(PK, Auto increment)
- OrtamHarita(nvarchar(max))(This attribute can be null)
- OrtamAdi(nvarchar(100)) (This attribute can be null)
- HucreDosyasi(nvarchar(max)) (This attribute can be null)

What I'm trying to do is insert into Ortam with these peace of code:

SqlConnection con = new SqlConnection("Data Source=İNOVASYONSERVER;Initial Catalog=MKB;Integrated Security=True");
SqlDataAdapter da = new SqlDataAdapter();

if (con.State == ConnectionState.Closed)
    con.Open();

SqlCommand komut1 = new SqlCommand("insert into Ortam Values(@OrtamHaritasi)", con);
komut1.Parameters.AddWithValue("@OrtamHaritasi", OrtamHaritasi);
da = new SqlDataAdapter(komut1);

da.InsertCommand = komut1;

When running this code, that does not insert into table.
Is there a problem with the code?
My best regards...

Posted 18-Dec-11 21:35pm

Un_NaMeD

Add a Solution

3 solutions

Solution 1

SqlCommand komut1 = new SqlCommand("insert into Ortam(OrtamHarita) Values(@OrtamHaritasi)", con);
komut1.Parameters.AddWithValue("@OrtamHaritasi", OrtamHaritasi)

try with the above snippet. It will solve your issue.. When you are about to insert values only for few columns you have to mention the column names.otherwise insert will not happen.

Thanks

Posted 18-Dec-11 21:47pm

doit4dotnet

Comments

Un_NaMeD 19-Dec-11 3:51am

Hi sir,
I've already tried your advice, but couldn't succeed.

Un_NaMeD 19-Dec-11 4:34am

Thank you too, doit4dotnet..

Solution 3

Hi,

Try This one:

C#

SqlConnection con = new SqlConnection("Data Source=İNOVASYONSERVER;Initial Catalog=MKB;Integrated Security=True");
SqlDataAdapter da = new SqlDataAdapter();
 
if (con.State == ConnectionState.Closed)
    con.Open();
 
SqlCommand komut1 = new SqlCommand("insert into Ortam(OrtamHarita)Values(@OrtamHaritasi)", con);
komut1.Parameters.Add(new SqlParameter("@OrtamHaritasi", OrtamHaritasi));

komut1.ExecuteNonQuery();
 con.Close();

Posted 18-Dec-11 22:29pm

Jitendra Parida - Jeetu

Comments

Un_NaMeD 19-Dec-11 4:34am

Thank you Jitendra.
My 5..

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)

Amir Mahfoozi · Accepted Answer · 2011-12-18T22:11:00

Solution 2

How about adding this line of code to your program :

C#

komut1.ExecuteNonQuery();

Also try to mention target columns in your insert statement as doit4dotnet453 said.

If it didn't worked out after these changes try to put a break point at this newly added line and observe parameter values in immediate or watch window.

Good Luck

Posted 18-Dec-11 22:11pm

Amir Mahfoozi

Comments

Un_NaMeD 19-Dec-11 4:34am

O yea, I forgot to add that.
it does the trick.
My 5..

Amir Mahfoozi 19-Dec-11 4:38am

Thanks

Wendelius 19-Dec-11 14:07pm

Good catch, 5'd

Amir Mahfoozi 19-Dec-11 23:44pm

Thanks Mika.