private void BindGridDB() { OpenTyreDAL objOpeningStock = new OpenTyreDAL(); DataTable dtItem = objOpeningStock.SelectPartFromExcel(ApplicationFunction.ConnectionString()); if (dtItem.Rows.Count > 0) { for (int i = 0; i < dtItem.Rows.Count; i++) { dtTemp = (DataTable)ViewState["dt"]; if ((dtTemp != null) && (dtTemp.Rows.Count > 0)) { foreach (DataRow row in dtTemp.Rows) { if (Convert.ToString(row["SerialNo"]) == Convert.ToString(dtItem.Rows[i]["SerialNo"].ToString())) { string msg = "Serial No. Already Exist For Same Item"; ddlItemName.Focus(); ShowMessageErr(msg); return; } } } Int32 ROWCount = Convert.ToInt32(dtTemp.Rows.Count) - 1; int id = dtTemp.Rows.Count == 0 ? 1 : (Convert.ToInt32(dtTemp.Rows[ROWCount]["id"])) + 1; string compName = dtItem.Rows[i]["CompanyName"].ToString(); string strSerialNo = dtItem.Rows[i]["SerialNo"].ToString(); string TypeID = dtItem.Rows[i]["Type_Idno"].ToString(); string strType = dtItem.Rows[i]["Type"].ToString(); string strPur = dtItem.Rows[i]["PurchaseFrom"].ToString(); string strItemName = dtItem.Rows[i]["Item_Name"].ToString(); string strItemIdno = dtItem.Rows[i]["Item_Idno"].ToString(); string openRate = Convert.ToDouble(dtItem.Rows[i]["Item_Rate"].ToString()).ToString("N2"); ApplicationFunction.DatatableAddRow(dtTemp, id, strSerialNo, compName, TypeID, strType, strPur, openRate, strItemName, strItemIdno); } } ViewState["dt"] = dtTemp; this.BindGridT(); }