private void button1_Click(object sender, EventArgs e) { try { OleDbConnection dbConn = new OleDbConnection(); OleDbCommand dbCommand = new OleDbCommand(); String sql = "INSERT INTO [User_tbl] values('" + textBox1.Text + "','" + textBox2.Text + "')"; bool isSave = new clsDB().ADO().ExecuteSql(sql); if (!isSave) { return; } DialogResult dr = MessageBox.Show("Successfully Saved! \n Do you want to add another data?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question); dbConn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private void saveData() { string sql = "Insert Into Shippers(CompanyName,Phone) values('" + textBox2.Text + "','" + textBox3.Text + "')"; bool isSave = new clsDB().ADO().ExecuteSql(sql); if (!isSave) { return; } //invoke the delegate to execute the function(RefreshData) modRefreshData("Activated!!"); DialogResult dr = MessageBox.Show("Successfully Saved! \n Do you want to add another data?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); } //set to exit the form isClosing = true; }
private void updateData() { string sql = "Update Shippers " + "Set CompanyName='" + textBox2.Text + "'," + "Phone='" + textBox3.Text + "'," + "Where ShipperID = " + textBox1.Text; bool isSave = new clsDB().ADO().ExecuteSql(sql); if (!isSave) { return; } //invoke the delegate to execute the function(RefreshData) modRefreshData("Activated!!"); MessageBox.Show("Successfully Updated!", "Update", MessageBoxButtons.OK, MessageBoxIcon.Question); isClosing = true; }
private void updateData() { string sql = "Update Suppliers " + "Set CompanyName='" + textBox2.Text + "'," + "ContactName='" + textBox3.Text + "'," + "ContactTitle='" + textBox4.Text + "'," + "Address='" + textBox5.Text + "'," + "City='" + textBox6.Text + "'," + "Region='" + textBox7.Text + "'," + "PostalCode='" + textBox8.Text + "'," + "Country='" + textBox9.Text + "'," + "Phone='" + textBox10.Text + "'," + "Fax='" + textBox11.Text + "'," + "HomePage='" + textBox12.Text + "' " + "Where SupplierID = " + textBox1.Text; bool isSave = new clsDB().ADO().ExecuteSql(sql); if (!isSave) { return; } //invoke the delegate to execute the function(RefreshData) modRefreshData("Activated!!"); MessageBox.Show("Successfully Updated!", "Update", MessageBoxButtons.OK, MessageBoxIcon.Question); isClosing = true; }
private void saveData() { string sql = "Insert Into Suppliers(CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) values('" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox8.Text + "','" + textBox9.Text + "','" + textBox10.Text + "','" + textBox11.Text + "','" + textBox12.Text + "')"; bool isSave = new clsDB().ADO().ExecuteSql(sql); if (!isSave) { return; } //invoke the delegate to execute the function(RefreshData) modRefreshData("Activated!!"); DialogResult dr = MessageBox.Show("Successfully Saved! \n Do you want to add another data?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); textBox5.Clear(); textBox6.Clear(); textBox7.Clear(); textBox8.Clear(); textBox9.Clear(); textBox10.Clear(); textBox11.Clear(); textBox12.Clear(); } //set to exit the form isClosing = true; }
private void updateData() { string[] reportTo = new string[1]; string[] fname = textBox14.Text.Split(','); new clsDB().ADO().SelectData("Select EmployeeID from Employees Where LastName='" + fname[0] + "' And FirstName='" + fname[1].Trim() + "'", reportTo); string sql = "Update Employees " + "Set LastName='" + textBox2.Text + "'," + "FirstName='" + textBox3.Text + "'," + "Title='" + textBox4.Text + "'," + "TitleOfCourtesy='" + textBox5.Text + "'," + "BirthDate=#" + textBox6.Text + "#," + "HireDate=#" + textBox7.Text + "#," + "Address='" + textBox8.Text + "'," + "City='" + textBox9.Text + "'," + "Region='" + textBox10.Text + "'," + "PostalCode='" + textBox11.Text + "'," + "Country='" + textBox12.Text + "'," + "HomePhone='" + textBox13.Text + "'," + "ReportsTo=" + reportTo[0] + " " + "Where EmployeeID = " + textBox1.Text; bool isSave = new clsDB().ADO().ExecuteSql(sql); if (!isSave) { return; } //invoke the delegate to execute the function(RefreshData) modRefreshData("Activated!!"); MessageBox.Show("Successfully Updated!", "Update", MessageBoxButtons.OK, MessageBoxIcon.Question); isClosing = true; }
private void saveData() { string[] reportTo = new string[1]; string[] fname = textBox14.Text.Split(','); new clsDB().ADO().SelectData("Select EmployeeID from Employees Where LastName='" + fname[0] + "' And FirstName='" + fname[1].Trim() + "'", reportTo); string sql = "Insert Into Employees(LastName,FirstName,Title,TitleOfCourtesy,BirthDate,HireDate,Address,City,Region,PostalCode,Country,HomePhone,ReportsTo) values('" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "',#" + textBox6.Text + "#,#" + textBox7.Text + "#,'" + textBox8.Text + "','" + textBox9.Text + "','" + textBox10.Text + "','" + textBox11.Text + "','" + textBox12.Text + "','" + textBox13.Text + "'," + reportTo[0] + ")"; bool isSave = new clsDB().ADO().ExecuteSql(sql); if (!isSave) { return; } //invoke the delegate to execute the function(RefreshData) modRefreshData("Activated!!"); DialogResult dr = MessageBox.Show("Successfully Saved! \n Do you want to add another data?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); textBox5.Clear(); textBox6.Clear(); textBox7.Clear(); textBox8.Clear(); textBox9.Clear(); textBox10.Clear(); textBox11.Clear(); textBox12.Clear(); textBox13.Clear(); textBox12.Text = ""; } //set to exit the form isClosing = true; }
private void updateData() { //NOTE: BE CAREFUL WITH SINGLE QOUTES QUERY AS SOMETIMES WILL CAUSE //UNWANTED BEHAVIOR string[] obj = new string[1]; new clsDB().ADO().SelectData("Select SupplierID from Suppliers Where CompanyName='" + textBox3.Text + "'", obj); string suppid = obj[0]; new clsDB().ADO().SelectData("Select CategoryID from Categories Where CategoryName='" + textBox4.Text + "'", obj); string catid = obj[0]; string sql = "Update Products " + "Set ProductName='" + textBox2.Text + "'" + ",SupplierID=" + suppid + ",CategoryID=" + catid + ",QuantityPerUnit='" + textBox5.Text + "'" + ",UnitPrice=" + textBox6.Text + ",UnitsInStock=" + textBox7.Text + ",UnitsOnOrder=" + textBox8.Text + ",ReorderLevel=" + textBox9.Text + " Where ProductID=" + textBox1.Text; bool isSave = new clsDB().ADO().ExecuteSql(sql); if (!isSave) { return; } //invoke the delegate to execute the function(RefreshData) modRefreshData("Activated!!"); MessageBox.Show("Successfully Updated!", "Update", MessageBoxButtons.OK, MessageBoxIcon.Question); isClosing = true; }
private void saveData() { //NOTE: BE CAREFUL WITH SINGLE QOUTES QUERY AS SOMETIMES WILL CAUSE //UNWANTED BEHAVIOR string[] obj = new string[1]; new clsDB().ADO().SelectData("Select SupplierID from Suppliers Where CompanyName='" + textBox3.Text + "'", obj); string suppid = obj[0]; new clsDB().ADO().SelectData("Select CategoryID from Categories Where CategoryName='" + textBox4.Text + "'", obj); string catid = obj[0]; //MessageBox.Show(suppid + " | " + catid); //This is a checker string sql = "Insert Into Products(ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) Values('" + textBox2.Text + "'," + suppid + "," + catid + ",'" + textBox5.Text + "'," + textBox6.Text + "," + textBox7.Text + "," + textBox8.Text + "," + textBox9.Text + ")"; //MessageBox.Show(sql); //This is a checker bool isSave = new clsDB().ADO().ExecuteSql(sql); if (!isSave) { return; } //invoke the delegate to execute the function(RefreshData) modRefreshData("Activated!!"); DialogResult dr = MessageBox.Show("Successfully Saved! \n Do you want to add another data?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { textBox1.Clear(); textBox2.Clear(); textBox3.Text = ""; textBox4.Text = ""; textBox5.Clear(); textBox6.Clear(); textBox7.Clear(); textBox8.Clear(); textBox9.Clear(); textBox10.Clear(); } //set to exit the form isClosing = true; }
//THIS IS AN EXAMPLE OF RECURSION(FUNCTION THAT CALL ITSELF) private string generateID(string str,int itr) { string[] obj = new string[1]; string res=""; bool b = new clsDB().ADO().SelectData("Select CompanyName from Customers Where CustomerID='" + str + "'", obj); if (b) { res = generateID(obj[0].Substring(0, 4).ToUpper() + Convert.ToString(itr + 1), itr + 1); } else { res = str; } return res; }