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"));
}
