protected void Button2_Click(object sender, EventArgs e) { var myquery = string.Format("UPDATE DVD SET Stock = Stock - 1"); da.InsertCommand = new OleDbCommand("INSERT INTO DVD (Stock) VALUES (@MessageLabel)", conn); { da.InsertCommand.Parameters.AddWithValue("@Stock", MessageLabel.Text); conn.Open(); da.InsertCommand.ExecuteNonQuery(); using (OleDbCommand cmd = new OleDbCommand(myquery, conn)) cmd.ExecuteNonQuery(); conn.Close(); conn.Dispose(); } }
public void Latest_DVD() { { using (OleDbDataAdapter dataquer = new OleDbDataAdapter("SELECT Title,Category,Director,Stock,Year FROM DVD ", conn)) { dataquer.Fill(dt); } } DG_Latest.ShowHeader = true; DG_Latest.DataSource = dt; DG_Latest.DataBind(); conn.Close(); conn.Dispose(); } protected void Latest_DVD_SelectedIndexChanged(Object sender, EventArgs e) { GridViewRow row = DG_Latest.SelectedRow; MessageLabel.Text = "You selected to rent " + row.Cells[1].Text + "."; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)