Click here to Skip to main content
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 23:01pm
Edited 9-Jul-13 23: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 Kornfeld Eliyahu Peter 275
1 Maciej Los 214
2 Sergey Alexandrovich Kryukov 200
3 King Fisher 185
4 OriginalGriff 163
0 OriginalGriff 6,223
1 DamithSL 4,724
2 Maciej Los 4,196
3 Kornfeld Eliyahu Peter 3,894
4 Sergey Alexandrovich Kryukov 3,496


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 10 Jul 2013
Copyright © CodeProject, 1999-2014
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