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");
}
