Multiple data insert from one table to another table

 INSERT INTO SaveDoc ( DocName )
SELECT  empname
FROM    EmpDetails

How to remove left row headers

click datagridview --> Properties.

Click a RowHeadersVisible Property and set to false


Output:

Delete Confirmation Message Box

if (MessageBox.Show("Are you sure you want to delete this row?", "Confirm Delete", MessageBoxButtons.OKCancel) == DialogResult.OK)
            {
                               //Delete Query
            }

Convert string into double values

string qw1 = txtWeight.Text.ToString().Trim();
                    if (qw1 != "")
                    {
                       double qw = Convert.ToDouble(qw1);
                    }

Join query in Windows Application

Example 1

query = "select Distinct IBS_ITEM_MST.Item_Cde from IBS_ITEM_MST,IBS_SALESORDER,IBS_SALESORDER_DETAILS where IBS_SALESORDER.SO_No = IBS_SALESORDER_DETAILS.SO_No AND IBS_SALESORDER_DETAILS.Item_Code = IBS_ITEM_MST.Item_Code AND IBS_SALESORDER.Cust_Id = '" + sid + "' AND IBS_ITEM_MST.Item_Cde Like '" + str + "%' and IBS_SALESORDER_DETAILS.Comp_Code ='" + compid + "' and IBS_SALESORDER_DETAILS.Year_Code = '" + yearid + "' and IBS_SALESORDER_DETAILS.SO_Billed = 'N' and (IBS_SALESORDER_DETAILS.SO_Bill_Type = 'N' or IBS_SALESORDER_DETAILS.SO_Bill_Type = 'I')";

Example 2

string query = "select IBS_ITEM_MST.Item_Name,IBS_ITEM_MST.Item_Cde,IBS_ITEM_MST.Item_UOM,IBS_ITEM_MST.Item_UOM1,IBS_ITEM_MST.Item_Srate,IBS_ITEM_MST.Item_Code from IBS_ITEM_MST where Item_Cde = '" + a + "'";

Like Query in windows application

query = "select * from IBS_ITEM_MST where Item_Cde Like '" + str + "%'";

In datagridview temporarily remove a row

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