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 lab12_1
{
public partial class Form1 : Form
{
SqlConnection con=new SqlConnection("Data Source=TANISH;Initial Catalog=department;User ID=sa;Password=seed");
SqlDataAdapter da;
DataSet ds = new DataSet();
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
SqlDataAdapter sqlda = new SqlDataAdapter("insert into dept1 values("+textBox1.Text+",'"+textBox2.Text+"')", con);
//da = new SqlDataAdapter("select * from dept1", con);
//SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(sqlda);
// DataSet ds = new DataSet();
sqlda.Fill(ds,"dept1");
dataGridView1.DataSource = ds.Tables[0];
}
private void button5_Click(object sender, EventArgs e)
{
da = new SqlDataAdapter("select * from dept1", con);
da.Fill(ds);
// dataGridView1.Refresh();
dataGridView1.DataSource = ds.Tables[0];
}
private void button3_Click(object sender, EventArgs e)
{
SqlDataAdapter sqlda = new SqlDataAdapter("Update dept1 set name='"+textBox2.Text+"' where id="+textBox1.Text+"", con);
//da = new SqlDataAdapter("select * from dept1", con);
//SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(sqlda);
// DataSet ds = new DataSet();
sqlda.Fill(ds, "dept1");
dataGridView1.DataSource = ds.Tables[0];
}
private void button4_Click(object sender, EventArgs e)
{
SqlDataAdapter sqlda = new SqlDataAdapter("delete from dept1 where id="+textBox1.Text+"" , con);
//da = new SqlDataAdapter("select * from dept1", con);
//SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(sqlda);
// DataSet ds = new DataSet();
sqlda.Fill(ds, "dept1");
dataGridView1.DataSource = ds.Tables[0];
}
private void button2_Click(object sender, EventArgs e)
{
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
textBox1.DataBindings.Add("text", ds.Tables[0], "id");
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
textBox2.DataBindings.Add("text", ds.Tables[0], "name");
}
private void button2_Click_1(object sender, EventArgs e)
{
BindingContext[ds.Tables[0]].Position = ds.Tables[0].Rows.Count - 1;
}
private void button7_Click(object sender, EventArgs e)
{
if (BindingContext[ds.Tables[0]].Position < ds.Tables[0].Rows.Count - 1)
BindingContext[ds.Tables[0]].Position = BindingContext[ds.Tables[0]].Position + 1;
}
private void button6_Click(object sender, EventArgs e)
{
if(BindingContext[ds.Tables[0]].Position>0)
BindingContext[ds.Tables[0]].Position=BindingContext[ds.Tables[0]].Position-1;
}
private void button8_Click(object sender, EventArgs e)
{
BindingContext[ds.Tables[0]].Position = 0;
}
}
}