void BindDevice()
{
string sql = "SELECT * FROM tbl_device_damaged dd JOIN tbl_device d ON d.device_id = dd.device_id where claim_id = '" + Session["CodePK"].ToString() + "' AND device_damaged_delete <> '1' ";
MySqlDataAdapter da = function.MySqlSelectDataSet(sql);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
DeviceGridView.DataSource = ds.Tables[0];
DeviceGridView.DataBind();
lbClaimDetailNull.Text = "อุปกรณ์ที่ได้รับความเสียหาย " + ds.Tables[0].Rows.Count + " ชิ้น";
}
void BindData(string key)
{
string sql = "";
try
{
sql = "SELECT * FROM tbl_device WHERE davice_delete <> 1 AND device_name Like '%" + key + "%' ORDER BY device_name ASC";
MySqlDataAdapter da = function.MySqlSelectDataSet(sql);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
DeviceGridView.DataSource = ds.Tables[0];
DeviceGridView.DataBind();
lbDeviceNull.Text = "พบข้อมูลจำนวน " + ds.Tables[0].Rows.Count + " แถว";
}
catch { }
}
