Delete cnfrmation Msg

DialogResult result = MessageBox.Show("Are You Sure to Delete This?", "Attention Please...!!!", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
            if (result == DialogResult.Yes)
            {}

SearchBox Text Changed Event

private void txt_Search_TextChanged(object sender, EventArgs e)
        {
            dgv_search.Rows.Clear();
            string aq = "SELECT [Name],[Description],[Date] FROM [City] where Name like '%" + txt_Search.Text + "%'";
            DataTable dt = qc.DataReaderTable(aq);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                dgv_search.Rows.Add();
                dgv_search.Rows[i].Cells[0].Value = Convert.ToString(dt.Rows[i]["Name"]);
                dgv_search.Rows[i].Cells[1].Value = Convert.ToString(dt.Rows[i]["Description"]);
                dgv_search.Rows[i].Cells[2].Value = Convert.ToDateTime(dt.Rows[i]["Date"]);
            }
        }

btn Edit

txt_Name.Text = Convert.ToString(dgv_search.SelectedRows[0].Cells[0].Value);
                txtDesc.Text = Convert.ToString(dgv_search.SelectedRows[0].Cells[1].Value);
                dtp_Date.Text = Convert.ToString(Convert.ToDateTime(dgv_search.SelectedRows[0].Cells[2].Value));

Filling Grid from text fields

int _dgrow = dgvSOUT.Rows.Count;

                    dgvSOUT.Rows.Add();
                    dgvSOUT.Rows[_dgrow].Cells[0].Value = dgvSOUT.Rows.Count;
                    dgvSOUT.Rows[_dgrow].Cells[1].Value = cmblot.Text;
                    dgvSOUT.Rows[_dgrow].Cells[2].Value = txtSName.Text;
                    dgvSOUT.Rows[_dgrow].Cells[3].Value = txtbrand.Text;

Filling textbox

private void fillParty()
        {
string selectPartyCmd = string.Format("SELECT DISTINCT [Cust_Name] FROM [CUSTOMER] where [Loc_Id] = '" + Program.locId + "'");
                txtPName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
                txtPName.AutoCompleteSource = AutoCompleteSource.CustomSource;
                AutoCompleteStringCollection coll = new AutoCompleteStringCollection();
                coll = qc.txtAutoCollection(selectPartyCmd);
                txtPName.AutoCompleteCustomSource = coll;
}

Column Name of GridView

private void dgvstyle()
        {
            dgvSOUT.ColumnCount = 13;

            dgvSOUT.Columns[0].Width = 55;
            dgvSOUT.Columns[0].Name = "S#";

            dgvSOUT.Columns[1].Width = 90;
            dgvSOUT.Columns[1].Name = "LOT#";

            dgvSOUT.Columns[2].Width = 120;
            dgvSOUT.Columns[2].Name = "THREAD NAME";

            dgvSOUT.Columns[3].Width = 100;
            dgvSOUT.Columns[3].Name = "BRAND";
}

Filling data in textboxes on textchange

private void txtRegNo_TextChanged(object sender, EventArgs e)
        {
            string slctCmdEmpId = "SELECT Emp_Id FROM EMPLOYEE WHERE Emp_RegNo='" + txtRegNo.Text + "' and Loc_Id = '" + Program.locId + "'";
            int empId = qc.DataReadInt(slctCmdEmpId);

            string slctCmdData = "SELECT * FROM EMPLOYEE WHERE Emp_Id='" + empId + "' AND Emp_RegNo='" + txtRegNo.Text + "' and Loc_Id = '" + Program.locId + "'";
            SqlDataReader sdr = (null);
            sdr = qc.readData(slctCmdData);
            sdr.Read();
            txtEmpName.Text = sdr["Emp_Name"].ToString();
            txtFatherName.Text = sdr["Emp_FatherName"].ToString();
            txtCNIC.Text = sdr["Emp_CNIC"].ToString();
            cmbGender.Text = sdr["Emp_Gender"].ToString();
            txtPhone.Text = sdr["Emp_Phone"].ToString();
            cmbStatus.Text = sdr["Emp_Status"].ToString();
            cmbDesignation.Text = sdr["Emp_Designation"].ToString();
            txtEmail.Text = sdr["Emp_Email"].ToString();
            rchAddress.Text = sdr["Emp_Address"].ToString();
            rchDetails.Text = sdr["Emp_Details"].ToString();
            txtUserId.Text = sdr["Emp_RegNo"].ToString();
            dtEmpReg.Value = Convert.ToDateTime(sdr["Emp_RegDate"]);
        }

Report Making(GridGame)

private void GridGame(DataTable dt)
        {
            DataTable dtbl = new DataTable();
            dtbl.Columns.Add("GP NO", typeof(String));
            dtbl.Columns.Add("DATE", typeof(String));
            dtbl.Columns.Add("PARTY NAME", typeof(String));
            dtbl.Columns.Add("LOT NO", typeof(String));
            dtbl.Columns.Add("STOCK NAME", typeof(String));
            dtbl.Columns.Add("BRAND", typeof(String));
            dtbl.Columns.Add("STOCK TYPE", typeof(String));
            dtbl.Columns.Add("PKNG TYPE", typeof(String));
            dtbl.Columns.Add("QTTY", typeof(String));
            dtbl.Columns.Add("WEIGHT", typeof(String));
            dtbl.Columns.Add("BM QTY", typeof(String));
            dtbl.Columns.Add("BM END", typeof(String));
            dtbl.Columns.Add("BM LENGTH", typeof(String));
            dtbl.Columns.Add("BM TTL LENGTH", typeof(String));
            int count = dt.Rows.Count;

            int totlRows = dt.Rows.Count;
            int rowNum = 0;
            for (int i = 0; i < totlRows; i++)
            {
                dtbl.Rows.Add();
                dtbl.Rows[rowNum]["GP NO"] = dt.Rows[i]["GP NO"].ToString();
                dtbl.Rows[rowNum]["Date"] = dt.Rows[i]["Date"].ToString();
                dtbl.Rows[rowNum]["PARTY NAME"] = dt.Rows[i]["PARTY NAME"].ToString();
                dtbl.Rows[rowNum]["LOT NO"] = dt.Rows[i]["LOT NO"].ToString();
                dtbl.Rows[rowNum]["STOCK NAME"] = dt.Rows[i]["STOCK NAME"].ToString();
                dtbl.Rows[rowNum]["BRAND"] = dt.Rows[i]["BRAND"].ToString();
                dtbl.Rows[rowNum]["STOCK TYPE"] = dt.Rows[i]["STOCK TYPE"].ToString();
                dtbl.Rows[rowNum]["PKNG TYPE"] = dt.Rows[i]["PKNG TYPE"].ToString();
                dtbl.Rows[rowNum]["QTTY"] = dt.Rows[i]["QTTY"].ToString();
                dtbl.Rows[rowNum]["WEIGHT"] = dt.Rows[i]["WEIGHT"].ToString();
                dtbl.Rows[rowNum]["BM QTY"] = dt.Rows[i]["BM QTY"].ToString();
                dtbl.Rows[rowNum]["BM END"] = dt.Rows[i]["BM END"].ToString();
                dtbl.Rows[rowNum]["BM LENGTH"] = dt.Rows[i]["BM LENGTH"].ToString();
                dtbl.Rows[rowNum]["BM TTL LENGTH"] = dt.Rows[i]["BM TTL LENGTH"].ToString();
                rowNum++;
            }

            dsStock_Out ds = new dsStock_Out();
            for (int i = 0; i < count; i++)
            {
                ds.dt_Stock_Out.Rows.Add();
                ds.dt_Stock_Out.Rows[i]["GP NO"] = dtbl.Rows[i]["GP NO"];
                ds.dt_Stock_Out.Rows[i]["Date"] = dtbl.Rows[i]["Date"];
                ds.dt_Stock_Out.Rows[i]["PARTY NAME"] = dtbl.Rows[i]["PARTY NAME"];
                ds.dt_Stock_Out.Rows[i]["LOT NO"] = dtbl.Rows[i]["LOT NO"];
                ds.dt_Stock_Out.Rows[i]["STOCK NAME"] = dtbl.Rows[i]["STOCK NAME"];
                ds.dt_Stock_Out.Rows[i]["BRAND"] = dtbl.Rows[i]["BRAND"];
                ds.dt_Stock_Out.Rows[i]["STOCK TYPE"] = dtbl.Rows[i]["STOCK TYPE"];
                ds.dt_Stock_Out.Rows[i]["PKNG TYPE"] = dtbl.Rows[i]["PKNG TYPE"];
                ds.dt_Stock_Out.Rows[i]["QTTY"] = dtbl.Rows[i]["QTTY"];
                ds.dt_Stock_Out.Rows[i]["WEIGHT"] = dtbl.Rows[i]["WEIGHT"];
                ds.dt_Stock_Out.Rows[i]["BM QTY"] = dtbl.Rows[i]["BM QTY"];
                ds.dt_Stock_Out.Rows[i]["BM END"] = dtbl.Rows[i]["BM END"];
                ds.dt_Stock_Out.Rows[i]["BM LENGTH"] = dtbl.Rows[i]["BM LENGTH"];
                ds.dt_Stock_Out.Rows[i]["BM TTL LENGTH"] = dt.Rows[i]["BM TTL LENGTH"];
            }

            crpStock_Out crp = new crpStock_Out();
            crp.SetDataSource(ds);
            ReportViewer rv = new ReportViewer();
            rv.crystalReportViewer1.ReportSource = crp;
            rv.crystalReportViewer1.Refresh();
            rv.Show();
        }

Report By Date

if (ByDate.Checked)
            {
                DateTime dtfrom = dtpFrom.Value;
                string dtfromdate = dtfrom.ToString("yyyy-mm-dd");
                string dtfromdatetime = dtfromdate + " " + "00:00:00";
                DateTime dtto = dtpTo.Value;
                string dttodate = dtto.ToString("yyyy-mm-dd");
                string dttodatetime = dttodate + " " + "23:59:59";

                string addquery = string.Format("select * from gatepass where date between '" + dtfrom + "' AND '" + dtto + "'");
                DataTable dt = qc.DataReaderTable(addquery);

Filling Combo Box

private void Load_Thread()
        {
            string aq = ("Select Distinct Threads_Type.Name from Threads_Type");
            DataTable ds = qc.getCmbData(aq);
            cbThreadName.DataSource = ds;
            cbThreadName.DisplayMember = "Name";
            cbThreadName.ValueMember = "Name";
        }