How to insert only selected data to table?

Question

Hi I have a table login in sql it contains lots of fields(for example fnamelnamePasswordaddressUsername 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.

Munesh Sharma · Answer

You see your column name which pass in table. SqlCommand cmd = new SqlCommand( INSERT INTO tablename (UserNamePassword) 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 Shanker · Answer

In your code password colum is not added.Somodify your code as below SqlCommand cmd = new SqlCommand(insert into login values(@UserName@Password) con);

Brijendra Gautam · Answer

@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(UserNamePassword) values(@UserName@Password) con); cmd.Parameters.AddWithValue(@UserName txtUserName.Text); cmd.Parameters.AddWithValue(@Password txtPassword.Text); Try this.