Hai,
I want to add multiple rows when click on datagridview cell.
I have written below code in cell leave event of datagridview.
but it is getting error. can u pls solve this if possible.
string selsql = "select * from tempPRODUCT";
dap = new SqlDataAdapter(selsql, cn);
DataSet ds = new DataSet();
dap.Fill(ds, "tempPRODUCT");
table = ds.Tables[0];
foreach (DataRow dgr in table.Rows)
{
i = dataGridViewEx1.CurrentRow.Index;
dbl_GetOnHand = cfs.ONhand(str);
dataGridViewEx1["Description", i].Value = cfs.singlequotconver(dgr["PRODUCT_NAME"].ToString());
dataGridViewEx1["UOM", i].Value = dgr["UOM"].ToString();
dataGridViewEx1["Rec", i].Value = "N";
dataGridViewEx1["GlCode", i].Value = dgr["IF_SALES"].ToString();
dataGridViewEx1["GL_Desc", i].Value = cfs.getGlDesc(dgr["IF_SALES"].ToString()); ;
if (dataGridViewEx1["GlCode", i].Value == "" || dataGridViewEx1["GlCode", i].Value == null)
{
dataGridViewEx1["GlCode", i].Value = strTaxCode;
dataGridViewEx1["GL_Desc", i].Value = strTaxDesc;
}
dataGridViewEx1["Discount", i].Value = dbl_DiscPer;
dataGridViewEx1["Rate", i].Value = "1";
dataGridViewEx1["Project", i].Value = "";
dataGridViewEx1["TaxCode", i].Value = "SR";
dataGridViewEx1["gstperc", i].Value = "7";
if (chbox_gst.Checked)
dataGridViewEx1["GST", i].Value = "Yes";
else
dataGridViewEx1["GST", i].Value = "No";
dataGridViewEx1["InvoiceNo", i].Value = txt_Transno.Text;
dataGridViewEx1["Price", i].Value = cfs.IsNumber(dgr["UNIT_PRICE"].ToString());
dataGridViewEx1["cate", i].Value = dgr["CATEGORY"].ToString();
{
Reset_toolStripButton.Enabled = false;
}
i = i + 1;
}
dr.Close();
cn.Close();