Click here to Skip to main content
11,715,160 members (63,407 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL
I could not insert data into my sql table with the following code.
SqlCommand com = new SqlCommand("insert into txfile mem_id=(@C1), reg_id=(@C2)", con);
                com.Parameters.AddWithValue("@C1", v_mem_id);
                com.Parameters.AddWithValue("@C2", v_reg_id);
                com.ExecuteNonQuery();

I get no error.
Can anyone guide?
Posted 9-Jul-13 22:01pm
Edited 9-Jul-13 22:07pm
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

SqlCommand com = new SqlCommand("INSERT INTO txfile (mem_id, reg_id) VALUES (@C1, @C2);", con);
com.Parameters.AddWithValue("@C1", v_mem_id);
com.Parameters.AddWithValue("@C2", v_reg_id);
com.ExecuteNonQuery();
  Permalink  
v3
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

hi,

you are using wrong way for insert statement


use it like..

SqlCommand com = new SqlCommand("insert into txfile(mem_id,reg_id) values(@C1, @C2)", con);
com.Parameters.AddWithValue("@C1", v_mem_id);
com.Parameters.AddWithValue("@C2", v_reg_id);
con.Open();
com.ExecuteNonQuery();
con.Close();
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 495
1 Richard MacCutchan 275
2 Maciej Los 259
3 ManasKumarM 155
4 Frankie-C 125
0 Sergey Alexandrovich Kryukov 775
1 CHill60 415
2 Richard MacCutchan 405
3 Maciej Los 389
4 OriginalGriff 320


Advertise | Privacy | Mobile
Web02 | 2.8.150901.1 | Last Updated 10 Jul 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100