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 Insert_update_delete_search_and_print_in_sql
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
SqlConnection conn = new SqlConnection("Data source=.;initial catalog=database3;integrated security=true");
private void Form2_Load(object sender, EventArgs e)
{
bind_data();
}
private void bind_data()
{
SqlCommand cmd1 = new SqlCommand("Select id,fname As firstname,lname As Lastname,sum from Table1", conn);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd1;
DataTable dt = new DataTable();
dt.Clear();
da.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Tahoma", 12, FontStyle.Bold);
dataGridView1.DefaultCellStyle.Font = new Font("arial", 12);
}
private void button1_Click(object sender, EventArgs e)
{
SqlCommand cmd2 = new SqlCommand("Insert into Table1(id,fname,lname,sum)Values(@id,@firstname,@lastname,@sum)", conn);
cmd2.Parameters.AddWithValue("id", textBox1.Text);
cmd2.Parameters.AddWithValue("firstname", textBox2.Text);
cmd2.Parameters.AddWithValue("lastname", textBox3.Text);
cmd2.Parameters.AddWithValue("sum", textBox4.Text);
conn.Open();
cmd2.ExecuteNonQuery();
conn.Close();
bind_data();
}
private void button2_Click(object sender, EventArgs e)
{
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
int index;
index = e.RowIndex;
DataGridViewRow selectedrow = dataGridView1.Rows[index];
textBox1.Text = selectedrow.Cells[0].Value.ToString();
textBox2.Text = selectedrow.Cells[1].Value.ToString();
textBox3.Text = selectedrow.Cells[2].Value.ToString();
textBox4.Text = selectedrow.Cells[3].Value.ToString();
}
private void button3_Click(object sender, EventArgs e)
{
SqlCommand cmd3 = new SqlCommand("Update Table1 Set fname=@firstname,lname=@lastname,sum=@sum where id=@id", conn);
cmd3.Parameters.AddWithValue("firstname", textBox2.Text);
cmd3.Parameters.AddWithValue("lastname", textBox3.Text);
cmd3.Parameters.AddWithValue("sum", textBox4.Text);
cmd3.Parameters.AddWithValue("id", textBox1.Text);
conn.Open();
cmd3.ExecuteNonQuery();
conn.Close();
bind_data();
}
private void button4_Click(object sender, EventArgs e)
{
SqlCommand cmd4 = new SqlCommand("Delete from Table1 where id=@id", conn);
cmd4.Parameters.AddWithValue("id", textBox1.Text);
conn.Open();
cmd4.ExecuteNonQuery();
conn.Close();
bind_data();
}
private void button5_Click(object sender, EventArgs e)
{
SqlCommand cmd1 = new SqlCommand("Select id,fname As firstname,lname As Lastname,sum from Table1 where fname Like @firstname+'%'", conn);
cmd1.Parameters.AddWithValue("firstname", textBox5.Text);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd1;
DataTable dt = new DataTable();
dt.Clear();
da.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Tahoma", 12, FontStyle.Bold);
dataGridView1.DefaultCellStyle.Font = new Font("arial", 12);
}
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
Bitmap imagebmp = new Bitmap(dataGridView1.Width, dataGridView1.Height);
dataGridView1.DrawToBitmap(imagebmp, new Rectangle(0, 0, dataGridView1.Width, dataGridView1.Height));
e.Graphics.DrawImage(imagebmp, 120, 20);
}
private void button6_Click(object sender, EventArgs e)
{
printPreviewDialog1.Document = printDocument1;
printPreviewDialog1.PrintPreviewControl.Zoom = 1;
printPreviewDialog1.ShowDialog();
}
}
}
