following is my C# to insert data but it do not get inserted. why?

Inderjeet Kaur

5y996Learn iOS Programming

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace sample1

{

public partial class main : Form

{

SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\lovel\Desktop\inder\Assign3\Assign3\DataG3.mdf;Integrated Security=True;Connect Timeout=30");

SqlCommand cmd;

public main()

{

InitializeComponent();

}

private void studLoginButton_Click(object sender, EventArgs e)

{

conn.Open();

cmd = new SqlCommand("INSERT INTO loginTab('" + txtStudUser.Text + "','" + txtStudPass.Text + "')", conn);

cmd.ExecuteNonQuery();

conn.Close();

MessageBox.Show("Done");

}

7 Replies

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

Satya Karki5y ago
update your query with this
cmd = new SqlCommand("INSERT INTO loginTab values ('" + txtStudUser.Text + "','" + txtStudPass.Text + "')", conn);
Rijwan Ansari5y ago
Your insert query is incorrect. Please correct as shown:
cmd = new SqlCommand("INSERT INTO loginTab values ('" + txtStudUser.Text + "','" + txtStudPass.Text + "')", conn);
Check now with this modification.
Sachin Singh5y ago
Step 1. Make sure your Id coulumn is marked as identity.
Step 2. Recheck the connectionstring and make sure it is pointing to right database.
Step 3. Correct your command query as shown below.
namespace sample1
{
public partial class main : Form
{
string cs = "Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\lovel\\Desktop\\nder\\Assign3\\Assign3\\DataG3.mdf;Integrated Security=True;Connect Timeout=30";

public main()
{
InitializeComponent();
}
private void studLoginButton_Click(object sender, EventArgs e)
{
using(SqlConnection con=new SqlConnection(cs)){
SqlCommand cmd=new SqlCommand("INSERT INTO loginTab values (@UserName,@Password));
cmd.Parameters.AddWithValue("@UserName",txtStudUser.Text);
cmd.Parameters.AddWithValue("@Password",txtStudPass.Text);
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Logged in successfully!");
}
}
Inderjeet Kaur5y ago
It does not show any error but data do not get inserted into database.
Ghanshyam Patel5y ago
Can u show me the error?
Inderjeet Kaur5y ago
NO IT DOES NOT FIX IT.
Ghanshyam Patel5y ago
Hi Inderjeet,

I think you are missing "values" keyword in your insert query.
change your following line

cmd = new SqlCommand("INSERT INTO loginTab('" + txtStudUser.Text + "','" + txtStudPass.Text + "')", conn);

to

cmd = new SqlCommand("INSERT INTO loginTab values ('" + txtStudUser.Text + "','" + txtStudPass.Text + "')", conn);

Hope this will fix your problem.