ADO.NET

create procedure studentselectalproc1
as
select * from student

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 WindowsFormsApplication19
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection
	("Data Source=R4R-03\\SQLEXPRESS;Initial 
Catalog=ashish ;Integrated Security=True");
con.Open();
SqlCommand cmd=new SqlCommand("studentselectalproc1",con);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
cmd.CommandType = CommandType.StoredProcedure;
dataGridView1.DataSource = ds.Tables[0];
}  
}
}
}

create procedure  studentinsertproc
@stdid text, @subid text, @subname text, @mark int
as   insert into student
(stdid,   subid,  subname ,mark) values 
      ( @stdid, @subid, @subname, @mark )

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 WindowsFormsApplication19
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection
("Data Source=R4R-03\\SQLEXPRESS;Initial 
Catalog=student ;Integrated Security=True");
con.Open();
SqlCommand cmd=new SqlCommand("studentinsertproc",con);
SqlParameter spm = new SqlParameter();
cmd.Parameters.AddWithValue("@stdid", textBox1.Text);
cmd.Parameters.AddWithValue("@subid", textBox2.Text);
cmd.Parameters.AddWithValue("@subname", textBox3.Text);
cmd.Parameters.AddWithValue("@mark", Convert.ToInt32( textBox4.Text));
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}  
}
}

create proc updatestdrecordproc
@stdid nchar(10),@stdname nchar(10), @mark int
as
update student set stdname=@stdname,mark=@mark where stdid=@stdid

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 WindowsFormsApplication19
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection
("Data Source=R4R-03\\SQLEXPRESS;Initial 
Catalog=studentrecord;Integrated Security=True");
con.Open();
SqlCommand cmd=new SqlCommand("updatestdrecordproc",con);
SqlParameter spm = new SqlParameter();
cmd.Parameters.AddWithValue("@stdid", textBox1.Text);
cmd.Parameters.AddWithValue("@stdname", textBox2.Text);
cmd.Parameters.AddWithValue
("@mark", Convert.ToInt32( textBox3.Text)); 
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}   
}
}

create proc delstdrecordproc
@stdid nchar(10)
as
delete from student where stdid=@stdid

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 WindowsFormsApplication19
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection
("Data Source=R4R-03\\SQLEXPRESS;Initial 
Catalog=studentrecord;Integrated Security=True");
con.Open();
SqlCommand cmd=new SqlCommand("delstdrecordproc",con);
SqlParameter spm = new SqlParameter();
cmd.Parameters.AddWithValue("@stdid", textBox1.Text);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();  
}  
}
}