How to insert only selected data to table?

Renjith V S

Hi,
I have a table login in sql it contains lots of fields(for example fname,lname,Password,address,Username etc). I need to insert some data only to the table(Username and Password). I use the code in C#
SqlCommand cmd = new SqlCommand("insert into login values(@UserName)", con);
cmd.Parameters.AddWithValue("@UserName", txtUserName.Text);
cmd.Parameters.AddWithValue("@Password", txtPassword.Text);
on clicking submit button it shows an error message:
"Column name or number of supplied values does not match table definition"
Please correct the problem.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munesh Sharma12y ago
Accepted answer
You see your column name which pass in table.
SqlCommand cmd = new SqlCommand("INSERT INTO tablename (UserName,Password) VALUES(@UserName, @Password)", con);
cmd.Parameters.AddWithValue("@UserName", txtUserName.Text);
cmd.Parameters.AddWithValue("@Password", txtPassword.Text);

these username and password should be same as column name which you pass in table.
Abhay Shanker12y ago
In your code password colum is not added.So,modify your code as below

SqlCommand cmd = new SqlCommand("insert into login values(@UserName,@Password)", con);
Brijendra Gautam12y ago
@Munesh: What is @1 and @2 in your query since you are passing @username and @password as a parameter and query contains @1 and @2 it will throw error.

Below is the correct command:

SqlCommand cmd = new SqlCommand("Insert Into login(UserName,Password) values(@UserName,@Password)", con);
cmd.Parameters.AddWithValue("@UserName", txtUserName.Text);
cmd.Parameters.AddWithValue("@Password", txtPassword.Text);

Try this.