private void RentalViewbtn_Click(object sender, EventArgs e)
{
if (RentalViewrbtn.Checked == true)
{
BalloonKingdomDataSetTableAdapters.Rental_ChecklistTableAdapter view = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.Rental_ChecklistTableAdapter();
DataTable datatable = view.ViewRentalChecklist();
Rental_Checklist_M rpt = new Rental_Checklist_M();
ViewRental vi = new ViewRental();
vi.SetDataSource(datatable);
rpt.Checklist(vi);
rpt.Show();
}
else
{
if (RentalDatetxt.Text == "")
{
MessageBox.Show("Enter date first.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
int a = Convert.ToInt32(RentalDatetxt.Text);
BalloonKingdomDataSetTableAdapters.Rental_ChecklistTableAdapter rent = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.Rental_ChecklistTableAdapter();
DataTable datatable = rent.COFRented(a);
Rental_Checklist_M rpt = new Rental_Checklist_M();
ViewRental vi = new ViewRental();
vi.SetDataSource(datatable);
rpt.Checklist(vi);
rpt.Show();
}
}
}
private void frmRentalChcklst_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'balloonKingdomDataSet.Rental_Checklist' table. You can move, or remove it, as needed.
// this.rental_ChecklistTableAdapter.Fill(this.balloonKingdomDataSet.Rental_Checklist);
try
{
conn = new SqlConnection();
conn.ConnectionString = str_conn;
conn.Open();
if (conn.State != ConnectionState.Open)
{
MessageBox.Show("Unable to connect to database", "Connection Status");
}
}
catch (Exception x)
{ MessageBox.Show(x.GetBaseException().ToString(), "Connection status"); }
BalloonKingdomDataSetTableAdapters.Rental_ChecklistTableAdapter viewrentalchklst = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.Rental_ChecklistTableAdapter();
CheckListDataGV.DataSource = viewrentalchklst.ViewRentalChecklist();
}
