CRUD operations with SQL Server Management Studio

sugitha sugi

Hi,

i have designed a form with some 4 labels and 4 textboxes with 3 buttons which is (save update and delete ) once i click the save button the records i enter should be stored in the sql server mgmt., studio,then i need to make some changes and update the record & it should reflect in the DATABASE also.Please send me the source code for this

Regards,

Sugitha

20 Replies

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

Rafnas T P8y ago
Accepted answer
hi,
SqlConnection con = new SqlConnection("");

have you provide your database connectionn string inside that red double quote

like as below

SqlConnection con = new SqlConnection("datasource=servername;database=dbname;user id=youruserid;password=yourpassword");
Rafnas T P8y ago
hi,
did you solve the recent question if yes then please accept the answer then make another question
Nitin Sontakke8y ago
Is your code now modified after it is posted before? The error messages is actually in real plain English. It cannot be any simpler than that.

Did you google that error message? The simplest thing you could do on your own.

In your insert statement if you mentioned 3 columns then 3 values must be supplied. If you do not mention column names then values for all columns must be supplied.

Share your code and table definition. Does table have an Identity column? If yes, which one?
sugitha sugi8y ago
Hi ,

Can anyone please help me in solving this issue,look the below Error

"Column name or number of supplied values does not match table definition"
Rafnas T P8y ago
can you send me your connection string. and are you using windows authantication or what
sugitha sugi8y ago
i couldn't get you please explain me clearly
Rafnas T P8y ago
can you open directly via sql server management studio
sugitha sugi8y ago
c this is how the page is there and the connectivity data source is also given

But it is not inserting the values into the table
sugitha sugi8y ago
yes i have provided but where the defect is couldn't identify
Nitin Sontakke8y ago
If you read the error, you will notice, that you are not connected to SQL Server. The Error is Login failed for user ''.

Where is your connection string? Do you have SQL Server Management Studio installed? Are you been able to login to SQL Server? Which authentication method are you using? Windows Authentication or SQL Server Login? Check your connection string it is the problem there.
sugitha sugi8y ago
No it is not inserted
Rafnas T P8y ago
or
in update statement, instead of where ID, youcan give where USERNAME=@uname and PASSWORD=@pwd
Rafnas T P8y ago
did the record insreted,if insrted check ID column what is there, any thing is insertd.
sugitha sugi8y ago
I have used Insert option instead of the word save , the way it take is insert the records in the table .once it gets inserted it should be updated in the db right but it doesn't
sugitha sugi8y ago
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace CRUD
{
public partial class Form1 : Form
{
SqlConnection con = new SqlConnection("");
SqlCommand cmd;
SqlDataAdapter adapt;
//ID variable used in Updating and Deleting Record
int ID = 0;
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && textBox2.Text != "")
{
cmd = new SqlCommand("insert into LOGIN(USERNAME,PASSWORD) values(@USERNAME,@PASSWORD)", con);
con.Open();
cmd.Parameters.AddWithValue("@Username", textBox1.Text);
cmd.Parameters.AddWithValue("@Password", textBox2.Text);
//cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted Successfully");
DisplayData();
ClearData();
}
else
{
MessageBox.Show("Please Provide Details!");
}
}
private void DisplayData()
{
con.Open();
DataTable dt = new DataTable();
adapt = new SqlDataAdapter("select * from LOGIN", con);
adapt.Fill(dt);
//dataGridView1.DataSource = dt;
con.Close();
}
//Clear Data
private void ClearData()
{
textBox1.Text = "";
textBox2.PasswordChar = '*';
ID = 0;
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && textBox2.Text != "")
{
cmd = new SqlCommand("update LOGIN set Name=@name,State=@state where ID=@id", con);
con.Open();
cmd.Parameters.AddWithValue("@id", ID);
cmd.Parameters.AddWithValue("@Username", textBox1.Text);
cmd.Parameters.AddWithValue("@Password", textBox2.Text);
cmd.ExecuteNonQuery();
MessageBox.Show("Record Updated Successfully");
con.Close();
DisplayData();
ClearData();
}
else
{
MessageBox.Show("Please Select Record to Update");
}
}
private void button3_Click(object sender, EventArgs e)
{
if (ID != 0)
{
cmd = new SqlCommand("delete LOGIN where ID=@id", con);
con.Open();
cmd.Parameters.AddWithValue("@id", ID);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Deleted Successfully!");
DisplayData();
ClearData();
}
else
{
MessageBox.Show("Please Select Record to Delete");
}
}
}
}
Rafnas T P8y ago
to save data into sql you have to use insert query.refer below video
https://www.youtube.com/watch?v=sSBx9_eddmo
Rafnas T P8y ago
ok, can provide your button click code how you are saving.
sugitha sugi8y ago
i need an idea of tht how can we save the new data into database.iam stuck in that my records is not saving in the db which im providing.
Rafnas T P8y ago
hi friend,

this platform is not for sending source code, but ya this website is for helping developer like we ,this site is greate community, you can ask any qustions where you need help, not full source code, no one can give you that,if they can also, you can not learn, if you need help i can help you where you got stuck, just message me or post a real problem here.

thank you.
sugitha sugi8y ago
Meanwhile i am working on windows forms application in c# for this CRUD operations