public void SelectAll(ref DataTable dt, GridControl grd)
{
LoadComBo();
try
{
if (searchLookUpEdit1.EditValue != null)
{
dt = TextUtils.Select("SELECT * FROM vSanPham WHERE (ProjectsID = N'" + searchLookUpEdit1.EditValue.ToString() + "')");
if (dt == null)
{
dt = SanPhamDABO.KhoiTaoGrid();
}
grdData.DataSource = dt;
}
}
catch (Exception)
{
throw;
}
//leWeek_EditValueChanged(null, null);
}
private void lookUpEdit1_EditValueChanged(object sender, EventArgs e)
{
try
{
if (lookUpEdit1.EditValue != null)
{
DataTable dt = TextUtils.Select("SELECT * FROM vSanPham WHERE (ProjectsID = N'" + lookUpEdit1.EditValue.ToString() + "')");
if (dt.Rows.Count <= 0)
{
dt = SanPhamDABO.KhoiTaoGrid();
}
grdDataSP.DataSource = dt;
}
else
{
grdDataSP.DataSource = null;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
