public void GridProductBind() { db1.strCommand = "select * from Product order by ProductName Asc"; DataSet ds = db1.selectqry(); if (ds.Tables[0].Rows.Count > 0) { GridView1.DataSource = ds; GridView1.DataBind(); } else { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); GridView1.DataSource = ds; GridView1.DataBind(); int columncount = GridView1.Rows[0].Cells.Count; GridView1.Rows[0].Cells.Clear(); GridView1.Rows[0].Cells.Add(new TableCell()); GridView1.Rows[0].Cells[0].ColumnSpan = columncount; GridView1.Rows[0].Cells[0].Text = "No Records Found"; } }
public void Gridbind() { db1.strCommand = "select * from Traceability_Info"; DataSet ds = db1.selectqry(); if (ds.Tables[0].Rows.Count > 0) { GridViewaddtrace.DataSource = ds; GridViewaddtrace.DataBind(); } else { ds.Tables[0].Rows.Add(ds.Tables[0].NewRow()); GridViewaddtrace.DataSource = ds; GridViewaddtrace.DataBind(); int columncount = GridViewaddtrace.Rows[0].Cells.Count; GridViewaddtrace.Rows[0].Cells.Clear(); GridViewaddtrace.Rows[0].Cells.Add(new TableCell()); GridViewaddtrace.Rows[0].Cells[0].ColumnSpan = columncount; GridViewaddtrace.Rows[0].Cells[0].Text = "No Records Found"; } }
public void db_backup() { db1.strCommand = "select * from LoginTb"; DataSet ds = new DataSet(); ds = db1.selectqry(); //ds.Tables[0].WriteXml(@"D:\resumes\LoginTb.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\LoginTb.xml")); db1.strCommand = "select * from Hospital"; DataSet ds_hospital = new DataSet(); ds_hospital = db1.selectqry(); //ds_hospital.Tables[0].WriteXml(@"D:\resumes\Hospital.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\Hospital.xml")); db1.strCommand = "select * from Calibration_Status"; DataSet ds_calib = new DataSet(); ds_calib = db1.selectqry(); //ds_calib.Tables[0].WriteXml(@"D:\resumes\Calibration_Status.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\Calibration_Status.xml")); db1.strCommand = "select * from Customer_Info"; DataSet ds_customer = new DataSet(); ds_customer = db1.selectqry(); //ds_customer.Tables[0].WriteXml(@"D:\resumes\Customer_Info.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\Customer_Info.xml")); db1.strCommand = "select * from DUT_info"; DataSet ds_dut = new DataSet(); ds_dut = db1.selectqry(); //ds_dut.Tables[0].WriteXml(@"D:\resumes\DUT_info.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\DUT_info.xml")); db1.strCommand = "select * from ElectricalSafety"; DataSet ds_electrical = new DataSet(); ds_electrical = db1.selectqry(); //ds_electrical.Tables[0].WriteXml(@"D:\resumes\ElectricalSafety.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\ElectricalSafety.xml")); db1.strCommand = "select * from Environ_condition"; DataSet ds_environ = new DataSet(); ds_environ = db1.selectqry(); //ds_environ.Tables[0].WriteXml(@"D:\resumes\Environ_condition.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\Environ_condition.xml")); db1.strCommand = "select * from Perf_Category"; DataSet ds_perfcategory = new DataSet(); ds_perfcategory = db1.selectqry(); //ds_perfcategory.Tables[0].WriteXml(@"D:\resumes\Perf_Category.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\Perf_Category.xml")); db1.strCommand = "select * from Perf_SubCategory"; DataSet ds_subcategory = new DataSet(); ds_subcategory = db1.selectqry(); //ds_subcategory.Tables[0].WriteXml(@"D:\resumes\Perf_SubCategory.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\Perf_SubCategory.xml")); db1.strCommand = "select * from Perf_Value"; DataSet ds_value = new DataSet(); ds_value = db1.selectqry(); //ds_value.Tables[0].WriteXml(@"D:\resumes\Perf_Value.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\Perf_Value.xml")); db1.strCommand = "select * from PerformanceTest"; DataSet ds_perftest = new DataSet(); ds_perftest = db1.selectqry(); //ds_perftest.Tables[0].WriteXml(@"D:\resumes\PerformanceTest.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\PerformanceTest.xml")); db1.strCommand = "select * from Product"; DataSet ds_product = new DataSet(); ds_product = db1.selectqry(); //ds_product.Tables[0].WriteXml(@"D:\resumes\Product.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\Product.xml")); db1.strCommand = "select * from Report_Info"; DataSet ds_report = new DataSet(); ds_report = db1.selectqry(); //ds_report.Tables[0].WriteXml(@"D:\resumes\Report_Info.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\Report_Info.xml")); db1.strCommand = "select * from Traceability_Info"; DataSet ds_traceability = new DataSet(); ds_traceability = db1.selectqry(); //ds_traceability.Tables[0].WriteXml(@"D:\resumes\Traceability_Info.xml"); ds.Tables[0].WriteXml(Server.MapPath(@"D:\DB_Backup\Traceability_Info.xml")); }