protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "GetExcel")
            {
                DataTable   DtCsv          = CreateDt();
                Int32       RowId          = Convert.ToInt32(e.CommandArgument);
                GridViewRow CurRow         = (GridViewRow)grdMain.Rows[RowId];
                HiddenField hidLocId       = (HiddenField)CurRow.FindControl("hidLocId");
                HiddenField hidYearId      = (HiddenField)CurRow.FindControl("hidYearId");
                OpenTyreDAL objItemMastDAL = new OpenTyreDAL();
                var         lst            = objItemMastDAL.GetExcel(Convert.ToInt64(hidLocId.Value), Convert.ToInt64(hidYearId.Value));

                if (lst != null && lst.Count > 0)
                {
                    for (int i = 0; i < lst.Count; i++)
                    {
                        ApplicationFunction.DatatableAddRow(DtCsv, Convert.ToString(DataBinder.Eval(lst[i], "SerialNo")), Convert.ToString(DataBinder.Eval(lst[i], "CompanyName")), Convert.ToString(DataBinder.Eval(lst[i], "LoctionName")), Convert.ToString(DataBinder.Eval(lst[i], "ItemName")),
                                                            "", Convert.ToString(DataBinder.Eval(lst[i], "Rate")), "");
                    }
                    if ((DtCsv != null) && (DtCsv.Rows.Count != 0))
                    {
                        DtCsv.Columns["LoctionName"].Caption = "Location";
                        DtCsv.Columns["ItemName"].ColumnName = "TyreName";
                        DtCsv.Columns["Rate"].Caption        = "Rate";

                        DtCsv.Columns["SerialNo"].SetOrdinal(0);
                        DtCsv.Columns["CompanyName"].SetOrdinal(1);
                        DtCsv.Columns["LoctionName"].SetOrdinal(2);
                        DtCsv.Columns["TyreName"].SetOrdinal(3);
                        DtCsv.Columns["Rate"].SetOrdinal(4);

                        DtCsv.Columns.Remove("Qty");
                        DtCsv.Columns.Remove("Amount");

                        DtCsv.AcceptChanges();
                        ExportDataTableToCSV(DtCsv, Convert.ToString("OpeningItemDetails"));
                        Response.Redirect("ManageOpenStock.aspx");
                    }
                }
            }
        }