private void frmJadwalExpedisiLookup_Load(object sender, EventArgs e) { if (GridJdwlExp.Rows.Count > 0) { BindData(); GridJdwlExp.Focus(); } }
public void BindData() { using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_JadwalExpedisi_LIST")); db.Commands[0].Parameters.Add(new Parameter("@RqDate", SqlDbType.DateTime, _DateRq)); db.Commands[0].Parameters.Add(new Parameter("@InitGudang", SqlDbType.VarChar, _gudangID)); dt = db.Commands[0].ExecuteDataTable(); GridJdwlExp.DataSource = dt; if (dt.Rows.Count > 0) { GridJdwlExp.Focus(); } } }