private void button2_Click(object sender, EventArgs e) { ShwTitle = this.comboBox1.GetItemText(this.comboBox1.SelectedItem); string query = "select g.contentgenre from genre g join shows_genre sh_g on g.genreid = sh_g.genreid join tvshows sh on sh.showid = sh_g.showid where sh.showtitle = :showtitle"; OracleDataAdapter adapter2 = new OracleDataAdapter(query, ordb); adapter2.SelectCommand.Parameters.Add("showtitle", ShwTitle); DataSet ds1 = new DataSet(); adapter2.Fill(ds1); genre = ds1.Tables[0].Rows[0]["contentgenre"].ToString(); NewListID += 1; // add columns to datatable // add rows to datatable //DataTable dtbl = new DataTable(); //DataRow row; //row = dtbl.NewRow(); //row["CONTENTID"] = 7; //row["CONTENTNAME"] = "ELKEF"; //row["CONTENTGENRE"] = "DRAMA"; //row["CUSTOMERID"] = 1; //dataGridView1.DataSource = dtbl; DataTable dt = new DataTable(); dt = (DataTable)dataGridView1.DataSource; DataRow row = dt.NewRow(); row[0] = NewListID.ToString(); row[1] = ShwTitle.ToString(); row[2] = genre.ToString(); row[3] = Custid.ToString(); dt.Rows.Add(row); // dataGridView1.Rows.Add(7, "alKEf", "DRAMA", 1); // dataGridView1.Rows.Add(NewListID, ShwTitle, genre, Custid); }
private void button1_Click(object sender, EventArgs e) { //// B3 builder = new OracleCommandBuilder(adapter); adapter.Update(ds.Tables[0]); conn = new OracleConnection(ordb); conn.Open(); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "insert into FAVORITE_SHOWS values(:showid , :contentid)"; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("showid", ShowID.ToString()); cmd.Parameters.Add("contentid", NewListID.ToString()); cmd.ExecuteReader(); MessageBox.Show("Your Data Save Successfully"); }