public void supp_insrt() { String iisql = "SELECT*FROM tbl_AddS_Supplier"; SqlDataAdapter iiget = new SqlDataAdapter(iisql, ConnectionDB.Connection_tmp()); DataTable iins = new DataTable(); iiget.Fill(iins); for (int ii = 0; ii < iins.Rows.Count; ii++) { string Supplier_No, First_Name, Last_Name, Business_Name, Address_Line1, Address_Line2, City, Phone, Mobile, Fax, Zip_Postal_Code, Email, Notes; Supplier_No = iins.Rows[ii]["Supplier_No"].ToString(); First_Name = iins.Rows[ii]["First_Name"].ToString(); Business_Name = iins.Rows[ii]["Business_Name"].ToString(); Address_Line1 = iins.Rows[ii]["Address_Line1"].ToString(); Address_Line2 = iins.Rows[ii]["Address_Line2"].ToString(); Last_Name = iins.Rows[ii]["Last_Name"].ToString(); City = iins.Rows[ii]["City"].ToString(); Zip_Postal_Code = iins.Rows[ii]["Zip_Postal_Code"].ToString(); Phone = iins.Rows[ii]["Phone"].ToString(); Mobile = iins.Rows[ii]["Mobile"].ToString(); Fax = iins.Rows[ii]["Fax"].ToString(); Email = iins.Rows[ii]["Email"].ToString(); Notes = iins.Rows[ii]["Notes"].ToString(); suppOp.insert(Supplier_No, First_Name, Last_Name, Business_Name, Address_Line1, Address_Line2, City, Phone, Mobile, Fax, Zip_Postal_Code, Email, Notes); } }
private void custormizeRestorToolStripMenuItem_Click(object sender, EventArgs e) { try { OpenFileDialog R_path = new OpenFileDialog(); R_path.Filter = "Backup Files(*.bak)|*.bak|All Files(*.*)|*.*"; R_path.FilterIndex = 0; if (R_path.ShowDialog() == DialogResult.OK) { Rpth = R_path.FileName; string sql = "Alter Database [" + System.Windows.Forms.Application.StartupPath + "\\InventoryDB_tmp.mdf] Set SINGLE_USER WITH ROLLBACK IMMEDIATE use master;"; sql += "Restore Database [" + System.Windows.Forms.Application.StartupPath + "\\InventoryDB_tmp.mdf] FROM Disk = '" + Rpth + "' WITH REPLACE;"; SqlCommand com = new SqlCommand(sql, ConnectionDB.Connection_tmp()); com.ExecuteNonQuery(); ConnectionDB.Connection().Close(); ConnectionDB.Connection().Dispose(); Restor reto = new Restor(); reto.ShowDialog(); } } catch (Exception w) { MessageBox.Show(w.Message); } }
public void invetry_insert() { String iisql = "SELECT*FROM tbl_catogory"; SqlDataAdapter iiget = new SqlDataAdapter(iisql, ConnectionDB.Connection_tmp()); DataTable iins = new DataTable(); iiget.Fill(iins); for (int ii = 0; ii < iins.Rows.Count; ii++) { string ctgy = iins.Rows[ii]["catogory"].ToString(); itemdb.catogary(ctgy); } String iisqls = "SELECT*FROM tbl_sub_catogory"; SqlDataAdapter iigets = new SqlDataAdapter(iisqls, ConnectionDB.Connection_tmp()); DataTable iinss = new DataTable(); iigets.Fill(iinss); for (int iis = 0; iis < iinss.Rows.Count; iis++) { string ctgy = iinss.Rows[iis]["catogory"].ToString(); string subCty = iinss.Rows[iis]["sub_catogory"].ToString(); itemdb.Subcatogary(subCty, ctgy); } String iisqlb = "SELECT*FROM tbl_brande"; SqlDataAdapter iigetb = new SqlDataAdapter(iisqlb, ConnectionDB.Connection_tmp()); DataTable iinsb = new DataTable(); iigetb.Fill(iinsb); for (int iib = 0; iib < iinsb.Rows.Count; iib++) { string brnd = iinsb.Rows[iib]["Brande"].ToString(); itemdb.brande(brnd); } String iisqlt = "SELECT*FROM tbl_itype"; SqlDataAdapter iigett = new SqlDataAdapter(iisqlt, ConnectionDB.Connection_tmp()); DataTable iinst = new DataTable(); iigett.Fill(iinst); for (int iit = 0; iit < iinst.Rows.Count; iit++) { string ttyp = iinst.Rows[iit]["Item_type"].ToString(); itemdb.itype(ttyp); } }