WTL MDI Application with Splitter

public partial class DataGridViewButtons : Form
    {
        private static OrderForm ordForm = null;
        OrderForm[] orderForm = new OrderForm[GlobalForms.TotalTables];
 
        public DataGridViewButtons()
        {
            InitializeComponent();
 
            this.dataGridView1.CellContentClick += new DataGridViewCellEventHandler(dataGridView1_CellContentClick);
 
            for (int i = 0; i < GlobalForms.TotalTables; i++)
            {
                orderForm[i] = new OrderForm();
 
                DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
 
                btn.HeaderText = "Table" + (i + 1);
                btn.Text = "Table" + i;
                btn.Name = "btnTable" + i;
                btn.UseColumnTextForButtonValue = false;
                dataGridView1.Columns.Add(btn);
            }
        }
 
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            //MessageBox.Show((e.RowIndex + 1) + "  Row  " + (e.ColumnIndex + 1) + "  Column button clicked ");
            int tblNo = e.ColumnIndex + 1;
 
            OrderForm.tableName = "Table-" + tblNo;
            orderForm[e.ColumnIndex].ShowDialog();
        }
     
        private void button1_Click(object sender, EventArgs e)
         {
             if (ordForm == null)
             {
                 ordForm = new OrderForm();
                 ordForm.Closed += new EventHandler(ordForm_Closed);
                 ordForm.Show();
             }
             else
             {
                 //MessageBox.Show("Already open.");
                 ordForm.Show();
             }            
        }
 
        private void ordForm_Closed(object sender, EventArgs e)
        {
            ordForm = null;
        }
 
        private void DataGridViewButtons_Load(object sender, EventArgs e)
        {
 
        }
    }

public partial class OrderForm : Form
    {
        public static string tableName;
        AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();
        string strCon = System.Configuration.ConfigurationSettings.AppSettings["connString"].ToString();
        SqlDataReader dr;
        SqlConnection conn = new SqlConnection();
        SqlCommand cmd = new SqlCommand();
        
        public OrderForm()
        {
            InitializeComponent();
           
            this.txtItems.KeyDown += new KeyEventHandler(txtItems_KeyDown);
            conn.ConnectionString = strCon;
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "select distinct ToName from MLApplicationEmail order by ToName";
            conn.Open();
            dr = cmd.ExecuteReader();
            if (dr.HasRows == true)
            {
                while (dr.Read())
                {
                    namesCollection.Add(dr["ToName"].ToString());
                }
            }
            else
            {
                MessageBox.Show("Data not found");
            }
            dr.Close();
            conn.Close();
            txtItems.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
            txtItems.AutoCompleteSource = AutoCompleteSource.CustomSource;
            txtItems.AutoCompleteCustomSource = namesCollection;
        }
        private void OrderForm_Load(object sender, EventArgs e)
        {
            this.Text = "Order for " + tableName;
            label2.Text = "0";
            label4.Text = "0";
            // Column 1 for Items
            DataGridViewColumn  newCol = new DataGridViewColumn(); // add a column to the grid  
            DataGridViewCell cell = new DataGridViewTextBoxCell(); //Specify which type of cell in this column  
            newCol.CellTemplate = cell;  
            newCol.HeaderText = "Item";  
            newCol.Name = "";  
            newCol.Visible = true;  
            newCol.Width = 100;  
            dataGridView1.Columns.Add(newCol);  
            // Column 2 for Price
            DataGridViewColumn newCol2 = new DataGridViewColumn(); // add a column to the grid  
            DataGridViewCell cell2 = new DataGridViewTextBoxCell(); //Specify which type of cell in this column  
            newCol2.CellTemplate = cell2;
            newCol2.HeaderText = "Price";
            newCol2.Name = "";
            newCol2.Visible = true;
            newCol2.Width = 100;
            dataGridView1.Columns.Add(newCol2);
            // Column 3 for Cancel item
            DataGridViewButtonColumn btn = new DataGridViewButtonColumn();
            btn.HeaderText = "Cancel";
            btn.Name = "btnTable";
            btn.Text = "Table";
            dataGridView1.Columns.Add(btn);
            //DataGridViewLinkColumn lnkbtn = new DataGridViewLinkColumn();
            //lnkbtn.HeaderText = "Cancel";
            //lnkbtn.Name = "btnTable";
            //lnkbtn.Text = "Table";            
            //dataGridView1.Columns.Add(lnkbtn);
            txtItems.Focus();
        }
       private void txtItems_TextChanged_1(object sender, EventArgs e)
        {
            //SqlDataReader dr1;
            //cmd.CommandText = "select ApplicationEmailID from MLApplicationEmail where ToName = '" + txtItems.Text + "'";
            //conn.Open();
            //dr1 = cmd.ExecuteReader();
            //if (dr1.HasRows == true)
            //{
            //    while (dr1.Read())
            //    {
            //        //      namesCollection.Add(dr["ToName"].ToString());
            //        label2.Text = dr1["ApplicationEmailID"].ToString();
            //    }
            //}
            //else
            //{
            //    MessageBox.Show("Data not found");
            //}
            //dr1.Close();
            //conn.Close();
        }
        private void txtItems_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                retPrice();
                btnAdd.Focus();
            }
        }
        private void retPrice()
        {
            SqlDataReader dr1;
            cmd.CommandText = "select ApplicationEmailID from MLApplicationEmail where ToName = '" + txtItems.Text + "'";
            conn.Open();
            dr1 = cmd.ExecuteReader();
            if (dr1.HasRows == true)
            {
                while (dr1.Read())
                {                    
                    label2.Text = dr1["ApplicationEmailID"].ToString();
                }
            }
            //else
            //{
            //    MessageBox.Show("Data not found");
            //}
            dr1.Close();
            conn.Close();
        }
        private void btnAdd_Click(object sender, EventArgs e)
        {
            if (txtItems.Text != "")
            {
                if (label2.Text != "" || label2.Text != "0")
                {
                    string[] row = new string[] { txtItems.Text, label2.Text };
                    dataGridView1.Rows.Add(row);
                    label4.Text = "";
                    calculateTotal();
                    txtItems.Clear();
                    label2.Text = "";
                    txtItems.Focus();
                }
            }
            else
            {
                MessageBox.Show("Please Select the item first.","Error",MessageBoxButtons.OK,MessageBoxIcon.Error);
                txtItems.Focus();
            }
        }
        private void calculateTotal()
        {
            double sum = 0;
            //bool isNum = double.TryParse(txtItems.Text.Trim(), out sum);
            
                foreach (DataGridViewRow row in dataGridView1.Rows)
                {
                    sum += Convert.ToDouble(row.Cells[1].Value);
                }
                label4.Text = sum.ToString();
        }
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            dataGridView1.Rows.RemoveAt(e.RowIndex);
            calculateTotal();
        }
        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Hide();
        }
        private void btnCheckOut_Click(object sender, EventArgs e)
        {
            // To insert into the Database
            //foreach (DataGridViewRow row in dataGridView1.Rows)
            //{
            //    string query = "insert into New (a, b, c, d, e) values (@a, @b, @c, @d, @e)";
            //    SqlCommand cmd = new SqlCommand(query, myConnection);
            //    cmd.Parameters.AddWithValue("@a", (row.Cells["ProductId"].Value));
            //    cmd.Parameters.AddWithValue("@b", (row.Cells["Name"].Value));
            //    cmd.Parameters.AddWithValue("@c", (row.Cells["Price"].Value));
            //    cmd.Parameters.AddWithValue("@d", (row.Cells["Quantity"].Value));
            //    cmd.Parameters.AddWithValue("@e", (row.Cells["Total"].Value));
            //    cmd.ExecuteNonQuery();
            //    cmd.Parameters.Clear();   //make sure to use Add() method insted of AddWithValue() method in this approach too
            //}

        }
    }

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Drawing.Printing;
 
namespace TestAsync
{
    public partial class SQLMain : Form
    {
        SQLOrder[] orderForm = new SQLOrder[GlobalForms.TotalTables];
        DataTable emptyDT = null;
        public static DataTable tempDT;
 
        string strCon = System.Configuration.ConfigurationSettings.AppSettings["connString2"].ToString();
        SqlConnection conn;
 
        // The PrintDocument to be used for printing.
        //PrintDocument MyPrintDocument;
        // The class that will do the printing process.
        DataGridViewPrinter MyDataGridViewPrinter;
 
        public SQLMain()
        {
            InitializeComponent();
 
            this.dgvListOrder.CellContentClick += new DataGridViewCellEventHandler(dgvListOrder_CellContentClick);
       
            dgvListOrder.Rows.Clear();
            dgvListOrder.Columns.Clear();
            
            DataGridViewButtonColumn btnTable = new DataGridViewButtonColumn();
 
            btnTable.HeaderText = "Table";
            btnTable.Name = "btnTable";
            btnTable.Text = "Table";
            dgvListOrder.Columns.Add(btnTable);
 
            DataGridViewTextBoxColumn txtTotal = new DataGridViewTextBoxColumn();
 
            txtTotal.HeaderText = "Item";
            txtTotal.Name = "Item";
            //txtTotal.Text = "Table";
            dgvListOrder.Columns.Add(txtTotal);
 
            DataGridViewButtonColumn btnUpdate = new DataGridViewButtonColumn();
 
            btnUpdate.HeaderText = "Update";
            btnUpdate.Name = "btnUpdate";
            btnUpdate.Text = "Table";
            dgvListOrder.Columns.Add(btnUpdate);
 
            //DataGridViewImageColumn img = new DataGridViewImageColumn();

            //Image image = Image.FromFile(@"D:\Table1.bmp");
            //img.Image = image;
            //img.HeaderText = "ImageHeader";
            //img.Name = "Image";

            //dgvListOrder.Columns.Add(img);

            for (int i = 0; i < GlobalForms.TotalTables; i++)
            {
                string[] row = new string[] { "Table" + (i + 1), "TotalPrice", "Update" };
                dgvListOrder.Rows.Add(row);
 
                orderForm[i] = new SQLOrder();
            }
 
            dgvListOrder.Columns[1].ReadOnly = true;
        }
 
        private void dgvListOrder_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            lblTotal.Text = "0";
            if (e.RowIndex > -1 && e.ColumnIndex == 0)
            {
                int tblNo = e.RowIndex + 1;
 
                GlobalForms.strTableNo = "Table-" + tblNo;
                GlobalForms.selectedTable = tblNo;
                
                orderForm[e.RowIndex].ShowDialog();
                fillGrid();
                calculateTotal();
 
                //if (orderForm[e.RowIndex].DialogResult == System.Windows.Forms.DialogResult.OK)
                //    dgvOrderDetails.DataSource = null;
                //else
                //    fillGrid();
            }
 
            if (e.RowIndex > -1 && e.ColumnIndex == 1)
            {
                GlobalForms.selectedTable = e.RowIndex + 1;
                fillGrid();
            }
        }
 
        private void fillGrid()
        {
            // Fill 2nd Grid

            conn = new SqlConnection(strCon);
            SqlDataAdapter da;
            DataTable dt = new DataTable();
            string strCommand;
 
            strCommand = "select Item, Price from zTable" + GlobalForms.selectedTable;
            conn.Open();
 
            da = new SqlDataAdapter(strCommand, conn);
            da.Fill(dt);
            dgvOrderDetails.DataSource = dt;
            conn.Close();
 
            calculateTotal();
        }
 
        private void calculateTotal()
        {
            double sum = 0;
 
            foreach (DataGridViewRow row in dgvOrderDetails.Rows)
            {
                sum += Convert.ToDouble(row.Cells[1].Value);
            }
 
            lblTotal.Text = sum.ToString();
        }
 
        private void button1_Click(object sender, EventArgs e)
        {
            conn = new SqlConnection(strCon);
 
            string[] strCommand = new string[GlobalForms.TotalTables];
 
            for (int i = 0; i < GlobalForms.TotalTables; i++)
            {
                strCommand[i] = "create table zTable" + (i + 1) +
                             " (ID int IDENTITY(1,1) NOT NULL, Item varchar(50), Price numeric(18,2))";
                conn.Open();
                SqlCommand cmd = new SqlCommand(strCommand[i], conn);
 
                cmd.ExecuteNonQuery();
                conn.Close();
            }
        }
 
        private void button2_Click(object sender, EventArgs e)
        {
            conn = new SqlConnection(strCon);
 
            string[] strCommand = new string[GlobalForms.TotalTables];
 
            for (int i = 0; i < GlobalForms.TotalTables; i++)
            {
                strCommand[i] = "drop table zTable" + (i + 1);
                conn.Open();
                SqlCommand cmd = new SqlCommand(strCommand[i], conn);
 
                cmd.ExecuteNonQuery();
                conn.Close();
            }
        }
 
        private void SQLMain_Load(object sender, EventArgs e)
        {
            dgvOrderDetails.DataSource = null;
        }
 
        private void btnCheckOut_Click(object sender, EventArgs e)
        {
            conn = new SqlConnection(strCon);
 
            string strCommand;
 
            strCommand = "truncate table zTable" + GlobalForms.selectedTable;
            conn.Open();
            SqlCommand cmd = new SqlCommand(strCommand, conn);
 
            cmd.ExecuteNonQuery();
            conn.Close();
 
            int tempT = GlobalForms.selectedTable - 1;
            orderForm[tempT].dgvOrderList.DataSource = emptyDT;
 
            // Printing DataGridView

            //if (SetupThePrinting())
            //    MyPrintDocument.Print();

            //******

 
            dgvOrderDetails.DataSource = null;
        }      
 
        private void SQLMain_FormClosing(object sender, FormClosingEventArgs e)
        {
            try
            {
                conn = new SqlConnection(strCon);
 
                string[] strCommand = new string[GlobalForms.TotalTables];
 
                for (int i = 0; i < GlobalForms.TotalTables; i++)
                {
                    strCommand[i] = "drop table zTable" + (i + 1);
                    conn.Open();
                    SqlCommand cmd = new SqlCommand(strCommand[i], conn);
 
                    cmd.ExecuteNonQuery();
                    conn.Close();
                }
            }
            catch
            { }
        }
 
        // The printing setup function
        private bool SetupThePrinting()
        {
            PrintDialog MyPrintDialog = new PrintDialog();
            MyPrintDialog.AllowCurrentPage = false;
            MyPrintDialog.AllowPrintToFile = false;
            MyPrintDialog.AllowSelection = false;
            MyPrintDialog.AllowSomePages = false;
            MyPrintDialog.PrintToFile = false;
            MyPrintDialog.ShowHelp = false;
            MyPrintDialog.ShowNetwork = false;
 
            if (MyPrintDialog.ShowDialog() != DialogResult.OK)
                return false;
 
            MyPrintDocument.DocumentName = "Bill Print";
            MyPrintDocument.PrinterSettings = MyPrintDialog.PrinterSettings;
            MyPrintDocument.DefaultPageSettings = MyPrintDialog.PrinterSettings.DefaultPageSettings;
            MyPrintDocument.DefaultPageSettings.Margins = new Margins(40, 40, 40, 40);
 
            if (MessageBox.Show("Do you want the report to be centered on the page",
                "BillManager - Center on Page", MessageBoxButtons.YesNo,
                MessageBoxIcon.Question) == DialogResult.Yes)
                MyDataGridViewPrinter = new DataGridViewPrinter(dgvOrderDetails,
                MyPrintDocument, true, true, "Bill", new Font("Tahoma", 18,
                FontStyle.Bold, GraphicsUnit.Point), Color.Black, true);
            else
                MyDataGridViewPrinter = new DataGridViewPrinter(dgvOrderDetails,
                MyPrintDocument, false, true, "Bill", new Font("Tahoma", 18,
                FontStyle.Bold, GraphicsUnit.Point), Color.Black, true);
 
            return true;
        }
 
        private void btnPrintPreview_Click(object sender, EventArgs e)
        {
            if (SetupThePrinting())
            {
                PrintPreviewDialog MyPrintPreviewDialog = new PrintPreviewDialog();
                MyPrintPreviewDialog.Document = MyPrintDocument;
                MyPrintPreviewDialog.ShowDialog();
            }
        }
 
        private void MyPrintDocument_PrintPage_1(object sender, PrintPageEventArgs e)
        {
            bool more = MyDataGridViewPrinter.DrawDataGridView(e.Graphics);
            if (more == true)
                e.HasMorePages = true;
        }
     }
}
 

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;
using System.Globalization;
 
namespace TestAsync
{
    public partial class SQLOrder : Form
    {
        AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();
        string strCon = System.Configuration.ConfigurationSettings.AppSettings["connString2"].ToString();
        SqlDataReader dr;
        SqlConnection conn;
        SqlCommand cmd = new SqlCommand();
 
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
       
        public SQLOrder()
        {
            InitializeComponent();
 
            this.txtItems.KeyDown += new KeyEventHandler(txtItems_KeyDown);
            //this.txtSearch.KeyDown += new KeyEventHandler(txtSearch_KeyDown);

 
            conn = new SqlConnection(strCon);
            //conn.ConnectionString = strCon;
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "select distinct ItemName from zItemMaster order by ItemName";
            conn.Open();
            dr = cmd.ExecuteReader();
            if (dr.HasRows == true)
            {
                while (dr.Read())
                {
                    namesCollection.Add(dr["ItemName"].ToString());
                }
            }
            else
            {
                MessageBox.Show("Data not found");
            }
            dr.Close();
            conn.Close();
            txtItems.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
            txtItems.AutoCompleteSource = AutoCompleteSource.CustomSource;
            txtItems.AutoCompleteCustomSource = namesCollection;           
        }
 
        private void txtItems_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                //if (itemExists())
                //{
                    retPrice();
                    btnAdd.Focus();
                //}
                //else
                //{
                //    MessageBox.Show("Item already in the list.", "Error");
                //}
            }
        }
 
        private bool IsitemExists()
        {
            int flagFound = 0;
 
            if (dgvOrderList.Rows.Count == 0)
                return false;
            
            if (dgvOrderList.Rows.Count >= 1)
            {
                for (int i = 0; i < (dgvOrderList.Rows.Count); i++)
                {
                    if (dgvOrderList.Rows[i].Cells["Item"].Value.ToString().ToUpper().Equals(txtItems.Text.ToUpper()))
                    {
                        flagFound++;
                    }
                }
            }
                if (flagFound > 0)
                    return true;
                else
                    return false;
        }
 
        private void retPrice()
        {
            SqlDataReader dr1;
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "select ItemPrice from zItemMaster where ItemName = '" + txtItems.Text + "'";
            conn.Open();
            dr1 = cmd.ExecuteReader();
            if (dr1.HasRows == true)
            {
                while (dr1.Read())
                {
                    lblCurrentPrice.Text = dr1["ItemPrice"].ToString();
                }
            }
            dr1.Close();
            conn.Close();
        }
 
        //private void retPrice()
        //{
        //    SqlDataReader dr1;
        //    cmd.Connection = conn;
        //    cmd.CommandType = CommandType.Text;
        //    cmd.CommandText = "select ItemPrice, ItemID from zItemMaster where ItemName = '" + txtItems.Text + "'";
        //    conn.Open();
        //    dr1 = cmd.ExecuteReader();
        //    if (dr1.HasRows == true)
        //    {
        //        while (dr1.Read())
        //        {
        //            lblID.Text = dr1["ItemID"].ToString();
        //            lblCurrentPrice.Text = dr1["ItemPrice"].ToString();
        //        }
        //    }
        //    dr1.Close();
        //    conn.Close();
        //}

        private void btnAdd_Click(object sender, EventArgs e)
        {
            if (txtItems.Text != "")
            {
                if (lblCurrentPrice.Text != "" || lblCurrentPrice.Text != "0")
                {
                    if (txtQuantity.Text == "")
                    {
                        if (IsitemExists() == false)
                        {
                            string[] row = new string[] { txtItems.Text, lblCurrentPrice.Text };
 
                            dgvOrderList.Rows.Add(row);
 
                            // Insert into Database

                            conn = new SqlConnection(strCon);
 
                            string strCommand;
 
                            strCommand = "insert into zTable" + GlobalForms.selectedTable + " (Item, Price)" +
                                         " values ('" + row[0] + "', " + row[1] + ")";
                            conn.Open();
                            //SqlCommand cmd = new SqlCommand(strCommand, conn);
                            cmd.CommandType = CommandType.Text;
                            cmd.CommandText = strCommand;
                            cmd.Connection = conn;
 
                            cmd.ExecuteNonQuery();
                            conn.Close();
 
                            //********************
                            lblTotalPrice.Text = "";
 
                            calculateTotal();
 
                            txtItems.Clear();
                            lblCurrentPrice.Text = "";
                            txtItems.Focus();
                        }
                        else
                        {
                            MessageBox.Show("Item already in list.");
                            txtItems.Focus();
                            return;
                        }
                    }
                }
                if (txtQuantity.Text != "")
                {
                    if (IsitemExists() == false)
                    {
                        double totPrice = Convert.ToDouble(Convert.ToDouble(lblCurrentPrice.Text) * Convert.ToDouble(txtQuantity.Text));
                        string[] row = new string[] { txtItems.Text, totPrice.ToString() };
 
                        dgvOrderList.Rows.Add(row);
 
                        // Insert into Database

                        conn = new SqlConnection(strCon);
 
                        string strCommand;
 
                        strCommand = "insert into zTable" + GlobalForms.selectedTable + " (Item, Price)" +
                                     " values ('" + row[0] + "', " + row[1] + ")";
                        conn.Open();
                        //SqlCommand cmd = new SqlCommand(strCommand, conn);
                        cmd.CommandType = CommandType.Text;
                        cmd.CommandText = strCommand;
                        cmd.Connection = conn;
 
                        cmd.ExecuteNonQuery();
                        conn.Close();
 
                        //********************
                        lblTotalPrice.Text = "";
 
                        calculateTotal();
 
                        txtItems.Clear();
                        lblCurrentPrice.Text = "";
                        txtQuantity.Clear();
                        txtItems.Focus();
                    }
                }
                else
                {
                    MessageBox.Show("Item already in list.");
                    txtItems.Focus();
                    return;
                }
            }
            else
            {
                MessageBox.Show("Please Select the item first.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                txtItems.Focus();
            }
        }
 
        private void calculateTotal()
        {
            double sum = 0;
 
            foreach (DataGridViewRow row in dgvOrderList.Rows)
            {
                sum += Convert.ToDouble(row.Cells[1].Value);
            }
 
            lblTotalPrice.Text = sum.ToString();
        }
 
        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Hide();
        }
 
        private void SQLOrder_Load(object sender, EventArgs e)
        {
            this.Text = GlobalForms.strTableNo;
        }
 
        private void btnCheckOut_Click(object sender, EventArgs e)
        {
            try
            {
                DataTable emptyDT = new DataTable();
                conn = new SqlConnection(strCon);
 
                string strCommand;
 
                strCommand = "truncate table zTable" + GlobalForms.selectedTable;
                conn.Open();
                SqlCommand cmd = new SqlCommand(strCommand, conn);
 
                cmd.ExecuteNonQuery();
                conn.Close();
                emptyDT.Clear();
                //int tempT = GlobalForms.selectedTable - 1;
                this.dgvOrderList.DataSource = emptyDT;
                this.dgvOrderList.DataSource = null;
 
                this.Close();
            }
            catch
            { }
        }
 
        private void dgvOrderList_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            // Remove item Database
            if (e.ColumnIndex == 2)
            {
                conn = new SqlConnection(strCon);
 
                string strCommand;
 
                strCommand = "DELETE FROM zTable" + GlobalForms.selectedTable +
                             " WHERE Item = '" + dgvOrderList.Rows[e.RowIndex].Cells[0].Value + "'";
                conn.Open();
                //SqlCommand cmd = new SqlCommand(strCommand, conn);
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = strCommand;
                cmd.Connection = conn;
 
                cmd.ExecuteNonQuery();
                conn.Close();
 
                //********************

                // Remove from Datagridview List
                dgvOrderList.Rows.RemoveAt(e.RowIndex);
                calculateTotal();
            }
        }
 
        //private void txtSearch_KeyDown(object sender, KeyEventArgs e)
        //{
        //    if (e.KeyCode == Keys.Enter)
        //    {
        //        dgvOrderList.Rows[0].Selected = false;
        //        for (int i = 0; i < (dgvOrderList.Rows.Count); i++)
        //        {
        //            if (dgvOrderList.Rows[i].Cells["Item"].Value.ToString().StartsWith(txtSearch.Text, true, CultureInfo.InvariantCulture))
        //            {
        //                //dgvOrderList.Rows[i].Cells[0].Selected = true;
                        
        //                dgvOrderList.Rows[i].DefaultCellStyle.BackColor = Color.Blue;
        //                //return; // stop looping
        //            }
        //        }

        //    }
        //}

        private void btnSearch_Click(object sender, EventArgs e)
        {
            for (int j = 0; j < (dgvOrderList.Rows.Count); j++)
            {
                dgvOrderList.Rows[j].Selected = false;
            }
 
            for (int i = 0; i < (dgvOrderList.Rows.Count); i++)
            {
                if (dgvOrderList.Rows[i].Cells["Item"].Value.ToString().StartsWith(txtItems.Text, true, CultureInfo.InvariantCulture))
                {
                    //dgvOrderList.Rows[i].Cells[0].Selected = true;

                    dgvOrderList.Rows[i].DefaultCellStyle.BackColor = Color.LightPink;
                    //return; // stop looping
                }
                else
                    dgvOrderList.Rows[i].DefaultCellStyle.BackColor = Color.White;
            }
        }
 
        //private void SQLOrder_FormClosing(object sender, FormClosingEventArgs e)
        //{
        //    SQLMain.tempDT = null;
        //    this.DialogResult = System.Windows.Forms.DialogResult.OK;
        //}
    }
}
 

public static class GlobalForms
    {
        public static OrderForm ordfrm;
        public static string strTableNo;
        public static int selectedTable = 0;
        public static int TotalTables = 5;
    }

using System;
using System.Text;
using System.Collections;
using System.Collections.Generic;
using System.Drawing;
using System.Drawing.Printing;
using System.Data;
using System.Windows.Forms;
 
class DataGridViewPrinter
{
    private DataGridView TheDataGridView; // The DataGridView Control which will be printed
    private PrintDocument ThePrintDocument; // The PrintDocument to be used for printing
    private bool IsCenterOnPage; // Determine if the report will be printed in the Top-Center of the page
    private bool IsWithTitle; // Determine if the page contain title text
    private string TheTitleText; // The title text to be printed in each page (if IsWithTitle is set to true)
    private Font TheTitleFont; // The font to be used with the title text (if IsWithTitle is set to true)
    private Color TheTitleColor; // The color to be used with the title text (if IsWithTitle is set to true)
    private bool IsWithPaging; // Determine if paging is used

    static int CurrentRow; // A static parameter that keep track on which Row (in the DataGridView control) that should be printed

    static int PageNumber;
 
    private int PageWidth;
    private int PageHeight;
    private int LeftMargin;
    private int TopMargin;
    private int RightMargin;
    private int BottomMargin;
 
    private float CurrentY; // A parameter that keep track on the y coordinate of the page, so the next object to be printed will start from this y coordinate

    private float RowHeaderHeight;
    private List<float> RowsHeight;
    private List<float> ColumnsWidth;
    private float TheDataGridViewWidth;
        
    // Maintain a generic list to hold start/stop points for the column printing
    // This will be used for wrapping in situations where the DataGridView will not fit on a single page
    private List<int[]> mColumnPoints;
    private List<float> mColumnPointsWidth;
    private int mColumnPoint;
        
    // The class constructor
    public DataGridViewPrinter(DataGridView aDataGridView, PrintDocument aPrintDocument, bool CenterOnPage, bool WithTitle, string aTitleText, Font aTitleFont, Color aTitleColor, bool WithPaging)
    {
        TheDataGridView = aDataGridView;
        ThePrintDocument = aPrintDocument;
        IsCenterOnPage = CenterOnPage;
        IsWithTitle = WithTitle;
        TheTitleText = aTitleText;
        TheTitleFont = aTitleFont;
        TheTitleColor = aTitleColor;
        IsWithPaging = WithPaging;
 
        PageNumber = 0;
 
        RowsHeight = new List<float>();
        ColumnsWidth = new List<float>();
 
        mColumnPoints = new List<int[]>();
        mColumnPointsWidth = new List<float>();
 
        // Claculating the PageWidth and the PageHeight
        if (!ThePrintDocument.DefaultPageSettings.Landscape)
        {
            PageWidth = ThePrintDocument.DefaultPageSettings.PaperSize.Width;
            PageHeight = ThePrintDocument.DefaultPageSettings.PaperSize.Height;
        }
        else
        {
            PageHeight = ThePrintDocument.DefaultPageSettings.PaperSize.Width;
            PageWidth = ThePrintDocument.DefaultPageSettings.PaperSize.Height;
        }
 
        // Claculating the page margins
        LeftMargin = ThePrintDocument.DefaultPageSettings.Margins.Left;
        TopMargin = ThePrintDocument.DefaultPageSettings.Margins.Top;
        RightMargin = ThePrintDocument.DefaultPageSettings.Margins.Right;
        BottomMargin = ThePrintDocument.DefaultPageSettings.Margins.Bottom;
 
        // First, the current row to be printed is the first row in the DataGridView control
        CurrentRow = 0;
    }
 
    // The function that calculate the height of each row (including the header row), the width of each column (according to the longest text in all its cells including the header cell), and the whole DataGridView width
    private void Calculate(Graphics g)
    {
        if (PageNumber == 0) // Just calculate once
        {
            SizeF tmpSize = new SizeF();
            Font tmpFont;
            float tmpWidth;
 
            TheDataGridViewWidth = 0;
            for (int i = 0; i < TheDataGridView.Columns.Count; i++)
            {
                tmpFont = TheDataGridView.ColumnHeadersDefaultCellStyle.Font;
                if (tmpFont == null) // If there is no special HeaderFont style, then use the default DataGridView font style
                    tmpFont = TheDataGridView.DefaultCellStyle.Font;
 
                tmpSize = g.MeasureString(TheDataGridView.Columns[i].HeaderText, tmpFont);
                tmpWidth = tmpSize.Width;
                RowHeaderHeight = tmpSize.Height;
 
                for (int j = 0; j < TheDataGridView.Rows.Count; j++)
                {
                    tmpFont = TheDataGridView.Rows[j].DefaultCellStyle.Font;
                    if (tmpFont == null) // If the there is no special font style of the CurrentRow, then use the default one associated with the DataGridView control
                        tmpFont = TheDataGridView.DefaultCellStyle.Font;
 
                    tmpSize = g.MeasureString("Anything", tmpFont);
                    RowsHeight.Add(tmpSize.Height);
 
                    tmpSize = g.MeasureString(TheDataGridView.Rows[j].Cells[i].EditedFormattedValue.ToString(), tmpFont);
                    if (tmpSize.Width > tmpWidth)
                        tmpWidth = tmpSize.Width;
                }
                if (TheDataGridView.Columns[i].Visible)
                    TheDataGridViewWidth += tmpWidth;
                ColumnsWidth.Add(tmpWidth);
            }
 
            // Define the start/stop column points based on the page width and the DataGridView Width
            // We will use this to determine the columns which are drawn on each page and how wrapping will be handled
            // By default, the wrapping will occurr such that the maximum number of columns for a page will be determine
            int k;
 
            int mStartPoint = 0;
            for (k = 0; k < TheDataGridView.Columns.Count; k++)
                if (TheDataGridView.Columns[k].Visible)
                {
                    mStartPoint = k;
                    break;
                }
 
            int mEndPoint = TheDataGridView.Columns.Count;
            for (k = TheDataGridView.Columns.Count - 1; k >= 0; k--)
                if (TheDataGridView.Columns[k].Visible)
                {
                    mEndPoint = k + 1;
                    break;
                }
 
            float mTempWidth = TheDataGridViewWidth;
            float mTempPrintArea = (float)PageWidth - (float)LeftMargin - (float)RightMargin;
            
            // We only care about handling where the total datagridview width is bigger then the print area
            if (TheDataGridViewWidth > mTempPrintArea)
            {
                mTempWidth = 0.0F;
                for (k = 0; k < TheDataGridView.Columns.Count; k++)
                {
                    if (TheDataGridView.Columns[k].Visible)
                    {
                        mTempWidth += ColumnsWidth[k];
                        // If the width is bigger than the page area, then define a new column print range
                        if (mTempWidth > mTempPrintArea)
                        {
                            mTempWidth -= ColumnsWidth[k];
                            mColumnPoints.Add(new int[] { mStartPoint, mEndPoint });
                            mColumnPointsWidth.Add(mTempWidth);
                            mStartPoint = k;
                            mTempWidth = ColumnsWidth[k];
                        }
                    }
                    // Our end point is actually one index above the current index
                    mEndPoint = k + 1;
                }
            }
            // Add the last set of columns
            mColumnPoints.Add(new int[] { mStartPoint, mEndPoint });
            mColumnPointsWidth.Add(mTempWidth);
            mColumnPoint = 0;
        }
    }
 
    // The funtion that print the title, page number, and the header row
    private void DrawHeader(Graphics g)
    {
        CurrentY = (float)TopMargin;
 
        // Printing the page number (if isWithPaging is set to true)
        if (IsWithPaging)
        {
            PageNumber++;
            string PageString = "Page " + PageNumber.ToString();
 
            StringFormat PageStringFormat = new StringFormat();
            PageStringFormat.Trimming = StringTrimming.Word;
            PageStringFormat.FormatFlags = StringFormatFlags.NoWrap | StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
            PageStringFormat.Alignment = StringAlignment.Far;
 
            Font PageStringFont = new Font("Tahoma", 8, FontStyle.Regular, GraphicsUnit.Point);
 
            RectangleF PageStringRectangle = new RectangleF((float)LeftMargin, CurrentY, (float)PageWidth - (float)RightMargin - (float)LeftMargin, g.MeasureString(PageString, PageStringFont).Height);
 
            g.DrawString(PageString, PageStringFont, new SolidBrush(Color.Black), PageStringRectangle, PageStringFormat);
 
            CurrentY += g.MeasureString(PageString, PageStringFont).Height;
        }
 
        // Printing the title (if IsWithTitle is set to true)
        if (IsWithTitle)
        {
            StringFormat TitleFormat = new StringFormat();
            TitleFormat.Trimming = StringTrimming.Word;
            TitleFormat.FormatFlags = StringFormatFlags.NoWrap | StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
            if (IsCenterOnPage)
                TitleFormat.Alignment = StringAlignment.Center;
            else
                TitleFormat.Alignment = StringAlignment.Near;
 
            RectangleF TitleRectangle = new RectangleF((float)LeftMargin, CurrentY, (float)PageWidth - (float)RightMargin - (float)LeftMargin, g.MeasureString(TheTitleText, TheTitleFont).Height);
 
            g.DrawString(TheTitleText, TheTitleFont, new SolidBrush(TheTitleColor), TitleRectangle, TitleFormat);
 
            CurrentY += g.MeasureString(TheTitleText, TheTitleFont).Height;
        }
 
        // Calculating the starting x coordinate that the printing process will start from
        float CurrentX = (float)LeftMargin;
        if (IsCenterOnPage)            
            CurrentX += (((float)PageWidth - (float)RightMargin - (float)LeftMargin) - mColumnPointsWidth[mColumnPoint]) / 2.0F;
 
        // Setting the HeaderFore style
        Color HeaderForeColor = TheDataGridView.ColumnHeadersDefaultCellStyle.ForeColor;
        if (HeaderForeColor.IsEmpty) // If there is no special HeaderFore style, then use the default DataGridView style
            HeaderForeColor = TheDataGridView.DefaultCellStyle.ForeColor;
        SolidBrush HeaderForeBrush = new SolidBrush(HeaderForeColor);
 
        // Setting the HeaderBack style
        
        // Edited by Prafull START
        Color HeaderBackColor = Color.White;// TheDataGridView.ColumnHeadersDefaultCellStyle.BackColor;
        // Edited by Prafull END

        if (HeaderBackColor.IsEmpty) // If there is no special HeaderBack style, then use the default DataGridView style
            HeaderBackColor = TheDataGridView.DefaultCellStyle.BackColor;
        SolidBrush HeaderBackBrush = new SolidBrush(HeaderBackColor);
 
        // Setting the LinePen that will be used to draw lines and rectangles (derived from the GridColor property of the DataGridView control)
        
        // Edited by Prafull START
        //Pen TheLinePen = new Pen(TheDataGridView.GridColor, 1);
        Pen TheLinePen = new Pen(Color.White);
        // Edited by Prafull END

        // Setting the HeaderFont style
        Font HeaderFont = TheDataGridView.ColumnHeadersDefaultCellStyle.Font;
        if (HeaderFont == null) // If there is no special HeaderFont style, then use the default DataGridView font style
            HeaderFont = TheDataGridView.DefaultCellStyle.Font;
 
        // Calculating and drawing the HeaderBounds        
        RectangleF HeaderBounds = new RectangleF(CurrentX, CurrentY, mColumnPointsWidth[mColumnPoint], RowHeaderHeight);
        g.FillRectangle(HeaderBackBrush, HeaderBounds);
 
        // Setting the format that will be used to print each cell of the header row
        StringFormat CellFormat = new StringFormat();
        CellFormat.Trimming = StringTrimming.Word;
        CellFormat.FormatFlags = StringFormatFlags.NoWrap | StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
 
        // Printing each visible cell of the header row
        RectangleF CellBounds;
        float ColumnWidth;        
        for (int i = (int)mColumnPoints[mColumnPoint].GetValue(0); i < (int)mColumnPoints[mColumnPoint].GetValue(1); i++)
        {
            if (!TheDataGridView.Columns[i].Visible) continue; // If the column is not visible then ignore this iteration

            ColumnWidth = ColumnsWidth[i];
 
            // Check the CurrentCell alignment and apply it to the CellFormat
            if (TheDataGridView.ColumnHeadersDefaultCellStyle.Alignment.ToString().Contains("Right"))
                CellFormat.Alignment = StringAlignment.Far;
            else if (TheDataGridView.ColumnHeadersDefaultCellStyle.Alignment.ToString().Contains("Center"))
                CellFormat.Alignment = StringAlignment.Center;
            else
                CellFormat.Alignment = StringAlignment.Near;
 
            CellBounds = new RectangleF(CurrentX, CurrentY, ColumnWidth, RowHeaderHeight);
 
            // Printing the cell text
            g.DrawString(TheDataGridView.Columns[i].HeaderText, HeaderFont, HeaderForeBrush, CellBounds, CellFormat);
 
            // Drawing the cell bounds
            if (TheDataGridView.RowHeadersBorderStyle != DataGridViewHeaderBorderStyle.None) // Draw the cell border only if the HeaderBorderStyle is not None
                g.DrawRectangle(TheLinePen, CurrentX, CurrentY, ColumnWidth, RowHeaderHeight);
 
            CurrentX += ColumnWidth;
        }
 
        // Edited by Prafull START
        // To add new blank row after header text
        CurrentY += RowHeaderHeight + 10;
        // Edited by Prafull END
        
    }
 
    // The function that print a bunch of rows that fit in one page
    // When it returns true, meaning that there are more rows still not printed, so another PagePrint action is required
    // When it returns false, meaning that all rows are printed (the CureentRow parameter reaches the last row of the DataGridView control) and no further PagePrint action is required
    private bool DrawRows(Graphics g)
    {
        // Setting the LinePen that will be used to draw lines and rectangles (derived from the GridColor property of the DataGridView control)
        //Pen TheLinePen = new Pen(TheDataGridView.GridColor, 1);
        Pen TheLinePen = new Pen(Color.White);
 
        // The style paramters that will be used to print each cell
        Font RowFont;
        Color RowForeColor;
        Color RowBackColor;
        SolidBrush RowForeBrush;
        SolidBrush RowBackBrush;
        SolidBrush RowAlternatingBackBrush;
 
        // Setting the format that will be used to print each cell
        StringFormat CellFormat = new StringFormat();
        CellFormat.Trimming = StringTrimming.Word;
        CellFormat.FormatFlags = StringFormatFlags.NoWrap | StringFormatFlags.LineLimit;
 
        // Printing each visible cell
        RectangleF RowBounds;
        float CurrentX;
        float ColumnWidth;
        while (CurrentRow < TheDataGridView.Rows.Count)
        {
            if (TheDataGridView.Rows[CurrentRow].Visible) // Print the cells of the CurrentRow only if that row is visible
            {
                // Setting the row font style
                RowFont = TheDataGridView.Rows[CurrentRow].DefaultCellStyle.Font;
                if (RowFont == null) // If the there is no special font style of the CurrentRow, then use the default one associated with the DataGridView control
                    RowFont = TheDataGridView.DefaultCellStyle.Font;
 
                // Setting the RowFore style
                RowForeColor = TheDataGridView.Rows[CurrentRow].DefaultCellStyle.ForeColor;
                if (RowForeColor.IsEmpty) // If the there is no special RowFore style of the CurrentRow, then use the default one associated with the DataGridView control
                    RowForeColor = TheDataGridView.DefaultCellStyle.ForeColor;
                RowForeBrush = new SolidBrush(RowForeColor);
 
                // Setting the RowBack (for even rows) and the RowAlternatingBack (for odd rows) styles
                RowBackColor = TheDataGridView.Rows[CurrentRow].DefaultCellStyle.BackColor;
                if (RowBackColor.IsEmpty) // If the there is no special RowBack style of the CurrentRow, then use the default one associated with the DataGridView control
                {
                    RowBackBrush = new SolidBrush(TheDataGridView.DefaultCellStyle.BackColor);
                    RowAlternatingBackBrush = new SolidBrush(TheDataGridView.AlternatingRowsDefaultCellStyle.BackColor);
                }
                else // If the there is a special RowBack style of the CurrentRow, then use it for both the RowBack and the RowAlternatingBack styles
                {
                    RowBackBrush = new SolidBrush(RowBackColor);
                    RowAlternatingBackBrush = new SolidBrush(RowBackColor);
                }
 
                // Calculating the starting x coordinate that the printing process will start from
                CurrentX = (float)LeftMargin;
                if (IsCenterOnPage)                    
                    CurrentX += (((float)PageWidth - (float)RightMargin - (float)LeftMargin) - mColumnPointsWidth[mColumnPoint]) / 2.0F;
 
                // Calculating the entire CurrentRow bounds                
                RowBounds = new RectangleF(CurrentX, CurrentY, mColumnPointsWidth[mColumnPoint], RowsHeight[CurrentRow]);
 
                // Filling the back of the CurrentRow
                if (CurrentRow % 2 == 0)
                    g.FillRectangle(RowBackBrush, RowBounds);
                else
                    g.FillRectangle(RowAlternatingBackBrush, RowBounds);
 
                // Printing each visible cell of the CurrentRow                
                for (int CurrentCell = (int)mColumnPoints[mColumnPoint].GetValue(0); CurrentCell < (int)mColumnPoints[mColumnPoint].GetValue(1); CurrentCell++)
                {
                    if (!TheDataGridView.Columns[CurrentCell].Visible) continue; // If the cell is belong to invisible column, then ignore this iteration

                    // Check the CurrentCell alignment and apply it to the CellFormat
                    if (TheDataGridView.Columns[CurrentCell].DefaultCellStyle.Alignment.ToString().Contains("Right"))
                        CellFormat.Alignment = StringAlignment.Far;
                    else if (TheDataGridView.Columns[CurrentCell].DefaultCellStyle.Alignment.ToString().Contains("Center"))
                        CellFormat.Alignment = StringAlignment.Center;
                    else
                        CellFormat.Alignment = StringAlignment.Near;
                    
                    ColumnWidth = ColumnsWidth[CurrentCell];
                    RectangleF CellBounds = new RectangleF(CurrentX, CurrentY, ColumnWidth, RowsHeight[CurrentRow]);
 
                    // Printing the cell text
                    g.DrawString(TheDataGridView.Rows[CurrentRow].Cells[CurrentCell].EditedFormattedValue.ToString(), RowFont, RowForeBrush, CellBounds, CellFormat);
                    
                    // Drawing the cell bounds
                    if (TheDataGridView.CellBorderStyle != DataGridViewCellBorderStyle.None) // Draw the cell border only if the CellBorderStyle is not None
                        g.DrawRectangle(TheLinePen, CurrentX, CurrentY, ColumnWidth, RowsHeight[CurrentRow]);
 
                    CurrentX += ColumnWidth;
                }
                CurrentY += RowsHeight[CurrentRow];
 
                // Checking if the CurrentY is exceeds the page boundries
                // If so then exit the function and returning true meaning another PagePrint action is required
                if ((int)CurrentY > (PageHeight - TopMargin - BottomMargin))
                {
                    CurrentRow++;
                    return true;
                }
            }
            CurrentRow++;
        }
 
        CurrentRow = 0;
        mColumnPoint++; // Continue to print the next group of columns

        if (mColumnPoint == mColumnPoints.Count) // Which means all columns are printed
        {
            mColumnPoint = 0;
            return false;
        }
        else
            return true;
    }
 
    // The method that calls all other functions
    public bool DrawDataGridView(Graphics g)
    {
        try
        {
            Calculate(g);
            DrawHeader(g);
            bool bContinue = DrawRows(g);
            return bContinue;
        }
        catch (Exception ex)
        {
            MessageBox.Show("Operation failed: " + ex.Message.ToString(), Application.ProductName + " - Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            return false;
        }
    }
}
 

// Declare Delagate for the Method
delegate void MyDelegate(string text);
 
// Method for the Label to set the text
private void SetText(string msgtext)
        {
            if (this.lblCurrentPrice.InvokeRequired)
            {              
               this.lblCurrentPrice.Invoke(new MyDelegate(SetText), new object[] { msgtext });
            }
            else
            {
                this.lblCurrentPrice.Text = msgtext;
            }
        }
 
// call the delegate
private void retPrice()
        {
            OleDbDataReader dr1;
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "select ItemPrice from ItemMaster where ItemName = '" + txtItems.Text + "'";
            conn.Open();
            dr1 = cmd.ExecuteReader();
            if (dr1.HasRows == true)
            {
                while (dr1.Read())
                {
                    SetText(dr1["ItemPrice"].ToString());
                    //lblCurrentPrice.Text = dr1["ItemPrice"].ToString();
                }
            }
            dr1.Close();
            conn.Close();
        }

public delegate void MyDelegate(string text);
        
        private void button1_Click(object sender, EventArgs e)
        {
            this.backgroundWorker1.RunWorkerAsync();
        }
 
        private void SetText(string msgtext)
        {
            if (this.label1.InvokeRequired)
            {
                this.label1.Invoke(new MyDelegate(SetText), new object[] { msgtext });
            }
            else
            {
                this.label1.Text = msgtext;
            }
        }
 
        private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
        {
            for (int i = 1; i < 3; i++)
            {
                Thread.Sleep(2000);
                SetText("Thread - " + i);
            }
        }

<asp:ScriptManager ID="ScriptManager1" runat="server">
                    </asp:ScriptManager>
                    <asp:UpdatePanel ID="UpdatePanelStates" UpdateMode="Conditional" runat="server">
                        <ContentTemplate>
                            <asp:DropDownList ID="ddlStates" runat="server" AutoPostBack="true"
                                onselectedindexchanged="ddlStates_SelectedIndexChanged">
                            </asp:DropDownList>
                        </ContentTemplate>
                        <Triggers>
                            <asp:AsyncPostBackTrigger ControlID="ddlStates" EventName="SelectedIndexChanged" />
                        </Triggers>
                    </asp:UpdatePanel>
                    <br />
                </td>
                <td class="style3" valign="top">
                    <asp:UpdatePanel ID="UpdatePanelCity" runat="server">
                        <ContentTemplate>
                            <asp:DropDownList ID="ddlCity" runat="server" AutoPostBack="true"
                                onselectedindexchanged="ddlCity_SelectedIndexChanged">
                            </asp:DropDownList>
                        </ContentTemplate>
                        <Triggers>
                            <asp:AsyncPostBackTrigger ControlID="ddlCity" EventName="SelectedIndexChanged" />
                        </Triggers>
                    </asp:UpdatePanel>
                    <br />
                </td>
                <td valign="top">
                    <asp:UpdatePanel ID="UpdatePanelArea" runat="server">
                        <ContentTemplate>
                            <asp:DropDownList ID="ddlArea" runat="server">
                            </asp:DropDownList>
                        </ContentTemplate>
                    </asp:UpdatePanel>

jQuery Script
 
<script type="text/javascript">
    $(function () {
        var listString = document.getElementById('HiddenField1').value;
        var listArray = listString.split('~');
        $("#txtAutoComplete").autocomplete({
            source: listArray
        });
 
    });
</script>
 
User HiddenField
 
<asp:HiddenField ID="HiddenField1" runat="server" />
 

****************************
 
In .CS file
 

OleDbConnection conn = new OleDbConnection(WebConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString);
        ArrayList rowList = new ArrayList();
 
        protected void Page_Load(object sender, EventArgs e)
        {
            string strCommand = @"SELECT ItemName FROM ItemMaster";
            OleDbDataReader dr = null;
            OleDbCommand cmd = new OleDbCommand(strCommand, conn);
            conn.Open();
            dr = cmd.ExecuteReader();            
            
            while (dr.Read())
            {
                rowList.Add(dr.GetValue(0).ToString());
            }
            HiddenField1.Value = ArrayListToString(rowList);
            conn.Close();
        }
 
        private string ArrayListToString(ArrayList _ArrayList)
        {
            int intCount;
            string strFinal = "";
 
            for (intCount = 0; intCount <= _ArrayList.Count - 1; intCount++)
            {
                if (intCount > 0)
                {
                    strFinal += "~";
                }
 
                strFinal += _ArrayList[intCount].ToString();
            }
 
            return strFinal;
        }