minnal datagrid

using System;

using System.Data;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace WindowsFormsApplication1

{

    public partial class Form1 : Form

    {

        SqlCommand sCommand;

        SqlDataAdapter sAdapter;

        SqlCommandBuilder sBuilder;

        DataSet sDs;

        DataTable sTable;       

        public Form1()

        {

            InitializeComponent();

        }

        private void button1_Click(object sender, EventArgs e)

        {

            string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True";

            string sql = "SELECT * FROM Stores";

            SqlConnection connection = new SqlConnection(connectionString);

            connection.Open();

            sCommand = new SqlCommand(sql, connection);

            sAdapter = new SqlDataAdapter(sCommand);

            sBuilder = new SqlCommandBuilder(sAdapter);

            sDs = new DataSet();

            sAdapter.Fill(sDs, "Stores");

            sTable = sDs.Tables["Stores"];

            connection.Close();

            dataGridView1.DataSource = sDs.Tables["Stores"];

            dataGridView1.ReadOnly = true;

            save_btn.Enabled = false;

            dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

        }

        private void new_btn_Click(object sender, EventArgs e)

        {

            dataGridView1.ReadOnly = false;

            save_btn.Enabled = true;

            new_btn.Enabled = false;

            delete_btn.Enabled = false;

        }

        private void delete_btn_Click(object sender, EventArgs e)

        {

            if (MessageBox.Show("Do you want to delete this row ?", "Delete", MessageBoxButtons.YesNo) == DialogResult.Yes)

            {

                dataGridView1.Rows.RemoveAt(dataGridView1.SelectedRows[0].Index);

                sAdapter.Update(sTable);

            }

        }

        private void save_btn_Click(object sender, EventArgs e)

        {

            sAdapter.Update(sTable);

            dataGridView1.ReadOnly = true;

            save_btn.Enabled = false;

            new_btn.Enabled = true;

            delete_btn.Enabled = true;

        }

    }

}

using System;

using System.Data;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace WindowsApplication1

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void button1_Click(object sender, EventArgs e)

        {

            dataGridView1.ColumnCount = 3;

            dataGridView1.Columns[0].Name = "Product ID";

            dataGridView1.Columns[1].Name = "Product Name";

            dataGridView1.Columns[2].Name = "Product Price";

            string[] row = new string[] { "1", "Product 1", "1000" };

            dataGridView1.Rows.Add(row);

            row = new string[] { "2", "Product 2", "2000" };

            dataGridView1.Rows.Add(row);

            row = new string[] { "3", "Product 3", "3000" };

            dataGridView1.Rows.Add(row);

            row = new string[] { "4", "Product 4", "4000" };

            dataGridView1.Rows.Add(row);

            DataGridViewComboBoxColumn cmb = new DataGridViewComboBoxColumn();

            cmb.HeaderText = "Select Data";

            cmb.Name = "cmb";

            cmb.MaxDropDownItems = 4;

            cmb.Items.Add("True");

            cmb.Items.Add("False");

            dataGridView1.Columns.Add(cmb);

        }

    }

}

using System;

using System.Data;

using System.Windows.Forms;

using System.Data.SqlClient;

using System.Drawing;

namespace WindowsFormsApplication1

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void button1_Click(object sender, EventArgs e)

        {

            string connectionString = "Data Source=.;Initial Catalog=pubs;Integrated Security=True";

            string sql = "SELECT * FROM Authors";

            SqlConnection connection = new SqlConnection(connectionString);

            SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);

            DataSet ds = new DataSet();

            connection.Open();

            dataadapter.Fill(ds, "Author_table");

            connection.Close();

            dataGridView1.DataSource = ds;

            dataGridView1.DataMember = "Author_table";

        }

        private void button2_Click(object sender, EventArgs e)

        {

            printDocument1.Print();

        }

        private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)

        {

            Bitmap bm = new Bitmap(this.dataGridView1.Width, this.dataGridView1.Height);

            dataGridView1.DrawToBitmap(bm, new Rectangle(0, 0, this.dataGridView1.Width, this.dataGridView1.Height));

            e.Graphics.DrawImage(bm, 0, 0);

        }

    }

}