private void comboBox1_SelectedIndexChanged_1(object sender, EventArgs e) { string cmdStr = string.Format("select DocNum, DocType, Description from Transactions"); DataTable dt = new DataTable(); dt = Utilities.DataBaseUtility.GetTable(cmdStr); List <string> st = Utilities.DataBaseUtility.GetList(cmdStr); string s = Utilities.DataBaseUtility.Execute(cmdStr, ident); Utilities.DataBaseUtility ud = new Utilities.DataBaseUtility(); foreach (string s1 in st) { string[] items = s1.Split(','); comboBox1.Items.Add(items[0] + " , " + items[1] + " , " + items[2]); //comboBox1.Items.Add(s1); } }
private void OLD_button1_Click(object sender, EventArgs e) { Utilities.DataBaseUtility ins = new Utilities.DataBaseUtility(); DataTable id = new DataTable(); int idnum; // string _supplierValues; //Handles generating a +1 value of the highest ID number in the table. This is to get around the AutoNumber feature missing from the table. id = Utilities.DataBaseUtility.GetTable("Select MAX([SupplierID]) from Suppliers"); idnum = Convert.ToInt32(id.Rows[0][0]) + 1; string _OLD_supplierValues = "('" + idnum.ToString() + "','" + textBox_DocNumber.Text + "','" + textBox_ProcType.Text + "','" + textBox_Employee.Text + "','" + textBox_Department.Text + "','" + textBox_StartDate.Text + "','" + textBox_Comment.Text + "','" + textBox_Status.Text; // txtResultTxt.Text = _supplierValues; // txtSQL.Text = "INSERT INTO Suppliers ([SupplierID],[Name],[Address],[Address2],[City],[Region],[Country],[PostalCode],[Phone],[WebAddress]) VALUES " + _supplierValues; //Turn on the code below when ready to submit to database. //ins.Insert("INSERT INTO Suppliers ([SupplierID],[Name],[Address],[Address2],[City],[Region],[Country],[PostalCode],[Phone],[WebAddress]) VALUES " + values); }
private void OLD_button1_Click(object sender, EventArgs e) { Utilities.DataBaseUtility ins = new Utilities.DataBaseUtility(); DataTable id = new DataTable(); int idnum; // string _supplierValues; //Handles generating a +1 value of the highest ID number in the table. This is to get around the AutoNumber feature missing from the table. id = Utilities.DataBaseUtility.GetTable("Select MAX([SupplierID]) from Suppliers"); idnum = Convert.ToInt32(id.Rows[0][0]) + 1; string _OLD_supplierValues = "('"+idnum.ToString()+"','"+txtName.Text+ "','"+txtAddr.Text+"','"+txtAddr2.Text+"','"+txtCity.Text+"','"+txtState.Text+"','"+txtCountry.Text+"','"+txtZIP.Text+"','"+txtPhone.Text+"','"+txtURL.Text+"')"; // txtResultTxt.Text = _supplierValues; // txtSQL.Text = "INSERT INTO Suppliers ([SupplierID],[Name],[Address],[Address2],[City],[Region],[Country],[PostalCode],[Phone],[WebAddress]) VALUES " + _supplierValues; //Turn on the code below when ready to submit to database. //ins.Insert("INSERT INTO Suppliers ([SupplierID],[Name],[Address],[Address2],[City],[Region],[Country],[PostalCode],[Phone],[WebAddress]) VALUES " + values); }