WTL MDI Application with Splitter

DataGridViewButtons

C#

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)
        {

        }
    }

OrderForm

C#

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
            //}

        }
    }

Main Form

C#

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;
        }
     }
}

Order Form

C#

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;
        //}
    }
}

MGlobal Class

C#

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

Printer Class .cs

C#

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;
        }
    }
}

Asynchronous Method call with Thread Safety

C#

// 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();
        }

Background Worker

C#

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);
            }
        }

SN Module Duration Status Remark

1 SQL Tool's Webservice 14-Dec-2011 to 27-Dec-2011 Done Done it after all testing and live issues
2 DB Procedure Improvements 20-Dec-2011 to 23-Dec-2011 Done xyz has changed the dates as 22-Dec-2011 to 27-Dec-2011.

Selecting / Deselecting all the CheckBoxes Inside a GridView[^]

Optimized Paging and Sorting using Object Data Source[^]

C#

<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>

C#

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;
        }

When i try to add a mdiclient to a splitterbar the menubar of the main window doesn't update nothing and the child windows are always not active. I think the problem is because the main window isn't the parent of the mdiclient.. Anyway how can i solve this problem? Sorry for my bad english Frown | :(

i coudl run the exectable file but i am not able to debug the application it says
"Could not find the file atlres.h"
Anysolutions do email me.
I am looking for Splitters to be used in MFC MDI application , if anyother idea
then ur welcome.

Vikas Amin
Embin Technology
Bombay
vikas.amin@embin.com

atlres.h is a part of the WTL installation. You need to make sure that you have WTL installed. There are some other great references in the WTL section for getting WTL installed and running.

-- Rick

It's amazing how good google is. I was going to do the exact same thing, and I had some clues on how to do it. But I figured that someone must've done this before, so I thought I'd spend 5 minutes with google first. I entered "mdi wtl m_hWndMDIClient" and hit "I'm feeling lucky", and it led me straight to your article. Took me less time to actually implement the splitter and MDI setup, than the anticipated google time. Smile | :)

A side note: I've noticed that some paint/erase background messages are lost somewhere when the splitter is inplace. One of the client views I have, contains a listview. It does not receive WM_ERASEBACKGROUND properly as it did earlier. After enough time in spy++ to annoy me, I took the easy route by simply invalidating the listview whenever I receive a WM_WINDOWPOSCHANGED/SWP_FRAMECHANGED message.

Your precious lines of code, saved me some time. Personal time as well, which is something I have very little of. Should you ever be in Karlstad Sweden, let me know. I owe you a beer or two. Smile | :)

--
An eye for an eye will only make the world blind.

actualy when u resize main window (MDIFrame)
splitter resizes also both panes - left & right, but
usualy one of the panes should not be resized...

howto !?

PS: overwise thsi article helped me to realized what i whant to do. thanks!

----------------------------
never stop coding.

actualy i found the answer.

// @params : style, mask
//SPLIT_PROPORTIONAL shoud not be set
m_splitter.SetSplitterExtendedStyle( 0, 0 );

PS: it is bad when there is bad documentation on WTL Frown | :(

----------------------------
never stop coding.

Hey Ed,

Its amazing how fast this stuff becomes rusty when you don't use it all the time Unsure | :~

I have a window that runs in a seperate thread, so I have been making a modal dialog box. It only has one item in it, a static control with a picture. I need to make it so you can size down the dialog box and have scroll bars appear. I have done some work where I use scroll bars with a regular CWindowImpl<>, but I don't know how to make that go modal. The easiest way seems to have scroll bars in my dialog box, and it seems that would be an easy thing to do without manually handling all the scrolling logic and moving things around, but heck if I can figure out how to do any of it. Confused | :confused:

Thanks
-- Rick

Dear Sir ,

Really, it's a good article.
I compile the source after I install platform SDK.
But I got a "can't open include file altres.h", where can I
get this include file.

tsung yu

u must have wtl

Download WTL in Microsoft..
Good Luck..

I'm running it in Win 98, and it keeps crashing on CreateWindowEx in atlframe.h when I create a new file(OnFileNew). It partially works if I comment out the
::SetParent(m_hWndMDIClient, m_splitter.m_hWnd) in CMainFrame::CreateClient(), but it displays incorrectly. Any ideas? Thanks.

"For God so loved the world that He gave His only begotten Son, that whoever believes in Him should not perish but have everlasting life." (John 3:16)

I've tested on Windows ME and NT 4 with no problems. Do you have the latest service packs and stuff installed? Also, have you changed anything in the code that might be supplying a null value where it shouldn't?

I've upgraded everything, and ran only the downloadable executable; but, it still crashes on a new file with a "general protection fault in module user.exe". I think it is failing in user32.dll(4.10.2222)after WinProc exits in atlwin.h. Maybe there's an upgraded user32.dll somewhere? Also, how can this functionality be implemented in MFC?
Thanks.

Another way to implement this functionality without changing the mdiclient's parent window, might be to implement a dockable toolbar like the CCoolDialogBar for MFC, except in WTL. Though I am not sure how.

Hello,

I also use win98 and the same problem happens to me with this code. I implemented then my own mdi client in a splitter from scratch and i had the same error.
I still need to implement mdi in a splitter pane and the problem seems to be that the mdi framework is very dependent on the fact that the mdiclient is a direct child of the frame window. it would be usefull to have a splitter implementation that didnt require its panes to be children of it

Is there anybody who has solved the problem of crashing program with using Windows-98?
Please help

this artical was wrong, please see this URL :

http://tech.groups.yahoo.com/group/wtl/message/15070[^]

Work hunting

Hi! It's Pawel again Wink | ;)

Well, WTL has caught me! So here I am to bother you with a question Wink | ;)

Why does the right window become corrupt when we switch the panes around (SPLIT_PANE_RIGHT and SPLIT_PANE_LEFT)? I tried to figure it out myself but with no results...

Pawel

Hi!
Since I'm new in Windows programming and all I have tried yet is MFC, I have a question if this what you've shown here could be achieved with MFC? If you'd give some hints I'd be grateful.

Pawel

WTL MDI Application with Splitter

Introduction

Main Frame

Child Frame

Additional Stuff

Terms Of Use

License

Comments and Discussions