public EditPriceForItem(ComboBox comboBox1) { connect = DataBaseConnection.getInstance().getConnect(); String SelectQuery = "SELECT Name FROM [Table]"; SqlCommand cmd = new SqlCommand(SelectQuery, connect); cmd.CommandText = SelectQuery; try { connect.Open(); SqlDataReader drd = cmd.ExecuteReader(); while (drd.Read()) { product p = new product(); p.Name = drd["Name"].ToString(); comboBox1.Items.Add(p); } drd.Close(); } catch (Exception EX) { MessageBox.Show(EX.StackTrace.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { connect.Close(); } }
private void Save_Click(object sender, EventArgs e) { product Product = new product(); Product.Name = "" + NameP.Text; Product.Amount = Convert.ToInt32(Amount.Value); Product.Price = float.Parse(Price.Text); Thread thread = new Thread(new ParameterizedThreadStart(AddProduct.AddProductToDataBase)); thread.Start(Product); // DataRow table = tableDataGridView.NewRowNeeded(); // table["id"] = 1; // table["Name"] = "Ahaa"; //// table["Amount"] = 1; // table["Price"] = 1.3; // table["Date"] = DateTime.Now; // tableDataGridView.Rows.Add(1,"ahaa",1,1.3,DateTime.Now.ToString()); // tableDataGridView.DataSource = table; // this.tableTableAdapter.Fill(this.productsDataSet.Table.AddTableRow()); // this.tableAdapterManager.UpdateAll(this.stockDataSet); }
public void update(DataGridView dataGridView1) { List<product> list = new List<product>(); connect = DataBaseConnection.getInstance().getConnect(); String SelectQuery = "SELECT * FROM [Table]"; SqlCommand cmd = new SqlCommand(SelectQuery,connect); cmd.CommandText = SelectQuery; try { connect.Open(); SqlDataReader drd = cmd.ExecuteReader(); while (drd.Read()) { product p = new product(); p.Name = drd["Name"].ToString(); p.Amount = int.Parse(drd["Amount"].ToString()); p.Price = float.Parse(drd["Price"].ToString()); list.Add(p); } foreach (product pro in list) { dataGridView1.Rows.Add(false,pro.Name,pro.Amount,pro.Price); } } catch (Exception EX) { MessageBox.Show(EX.StackTrace.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { connect.Close(); } //SqlDataAdapter sda; //DataSet ds = new DataSet(); //sda = new SqlDataAdapter(cmd); //sda.Fill(ds); //DataTable dt = ds.Tables[0]; //foreach(DataRow dataRow in dt.Rows) //{ // chekedListBox1.Items.Add(dataRow["Name"]); //} }
//This method featches the content of database and fill them in AllProduct List private void CkeckPoduct() { try { SqlCommand Command = new SqlCommand(FetchQuery, Connection); Connection.Open(); SqlDataReader reader = Command.ExecuteReader(); while (reader.Read()) { product temp = new product(); temp.Name = reader["Name"].ToString(); temp.Amount = int.Parse(reader["Amount"].ToString()); temp.Price = float.Parse(reader["Price"].ToString()); // MessageBox.Show(reader["Name"].ToString(), "Erorr", MessageBoxButtons.OK, MessageBoxIcon.Error); AllProduct.Add(temp); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Connection.Close(); } }
public void selectFromComboBox(TextBox textBox,ComboBox comboBox,NumericUpDown selectAmount) { connect = DataBaseConnection.getInstance().getConnect(); String SelectQuery = "SELECT Amount,Price from [Table] where [Name] = @Name"; SqlCommand cmd = new SqlCommand(SelectQuery, connect); cmd.CommandText = SelectQuery; cmd.Parameters.AddWithValue("@Name",comboBox.Text); connect.Open(); try { SqlDataReader drd = cmd.ExecuteReader(); product p = new product(); while (drd.Read()) { p.Amount = int.Parse(drd[0].ToString()); p.Price = float.Parse(drd[1].ToString()); selectAmount.Value = p.Amount; textBox.Text = p.Price.ToString(); } } catch (Exception EX) { MessageBox.Show(EX.StackTrace.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { connect.Close(); } }