There are basically four functions each one for a database operation. Parameters are used in insert, update and select.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace AddressBook
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
//INSERT
private void button2_Click(object sender, EventArgs e)
{
try
{
string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Thangamani\Documents\visual studio 2010\Projects\AddressBook\AddressBook\Database1.mdf;Integrated Security=True;User Instance=True";
string na = textBox1.Text;
int ag = int.Parse(textBox2.Text);
string ci = textBox3.Text;
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand insertCommand = connection.CreateCommand())
{
insertCommand.CommandText = "INSERT INTO address(name,age,city) VALUES (@na,@ag,@ci)";
insertCommand.Parameters.AddWithValue("@na", na);
insertCommand.Parameters.AddWithValue("@ag", ag);
insertCommand.Parameters.AddWithValue("@ci", ci);
insertCommand.Connection.Open();
insertCommand.ExecuteNonQuery();
insertCommand.Connection.Close();
MessageBox.Show("Data Successfully Inserted");
}
//connection.Close();
}
}
finally { }
}
//SELECT
private void button1_Click(object sender, EventArgs e)
{
try
{
string s = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Thangamani\Documents\visual studio 2010\Projects\AddressBook\AddressBook\Database1.mdf;Integrated Security=True;User Instance=True";
SqlConnection a = new SqlConnection(s);
a.Open();
SqlCommand comm = new SqlCommand("SELECT * FROM address");
comm.Connection = a;
SqlDataReader re = comm.ExecuteReader();
while (re.Read())
{
textBox1.Text = re["name"].ToString();
textBox2.Text = re["age"].ToString();
textBox3.Text = re["city"].ToString();
MessageBox.Show("Data Selected");
}
}
finally
{
}
}
//DELETE
private void button3_Click(object sender, EventArgs e)
{
try
{
string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Thangamani\Documents\visual studio 2010\Projects\AddressBook\AddressBook\Database1.mdf;Integrated Security=True;User Instance=True";
string na = textBox1.Text;
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand insertCommand = connection.CreateCommand())
{
insertCommand.CommandText = "DELETE FROM address WHERE name LIKE @na";
insertCommand.Parameters.AddWithValue("@na", na);
insertCommand.Connection.Open();
insertCommand.ExecuteNonQuery();
insertCommand.Connection.Close();
MessageBox.Show("Data successfully Deleted");
}
}
}
finally { }
}
//UPDATE
private void button4_Click(object sender, EventArgs e)
{
try
{
string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Thangamani\Documents\visual studio 2010\Projects\AddressBook\AddressBook\Database1.mdf;Integrated Security=True;User Instance=True";
string na = textBox1.Text;
int ag = int.Parse(textBox2.Text);
string ci = textBox3.Text;
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand insertCommand = connection.CreateCommand())
{
insertCommand.CommandText = "UPDATE address SET age=@ag, city=@ci WHERE name LIKE @na";
insertCommand.Parameters.AddWithValue("@na", na);
insertCommand.Parameters.AddWithValue("@ag", ag);
insertCommand.Parameters.AddWithValue("@ci", ci);
insertCommand.Connection.Open();
insertCommand.ExecuteNonQuery();
insertCommand.Connection.Close();
MessageBox.Show("Data successfully Updated");
}
}
}
finally { }
}
}
}
