public bool kt_dangnhap(string ten, string matkhau, string tenserver, string matkhauserver) { Lnhanvien nv = new Lnhanvien(); try { if (tenserver != "") { L_Ketnoi.strChuoiKN = L_Ketnoi.strChuoiKN + "; server= " + tenserver; if (matkhauserver != "") { L_Ketnoi.strChuoiKN = L_Ketnoi.strChuoiKN + " ; Password = "******"select * from nhanvien where matkhau = '" + matkhau + "' and tendangnhap = '" + ten + "'"); if (ds.Tables[0].Rows.Count == 0) { L_Ketnoi.HuyKetNoi(); return(false); } else { strmanhanvien = ds.Tables[0].Rows[0]["manhanvien"].ToString(); strhoten = ds.Tables[0].Rows[0]["hoten"].ToString(); strdiachi = ds.Tables[0].Rows[0]["diachi"].ToString(); strquyenhan = ds.Tables[0].Rows[0]["quyenhan"].ToString(); strnguoidung = ds.Tables[0].Rows[0]["tendangnhap"].ToString(); strmatkhau = ds.Tables[0].Rows[0]["matkhau"].ToString(); L_Ketnoi.HuyKetNoi(); return(true); } } catch { return(false); } }
public DataSet getdata(string truyvan) { try { DataSet ds = new DataSet();; SqlCommand cmd = new SqlCommand(truyvan, L_Ketnoi.cn); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds, "bang"); L_Ketnoi.HuyKetNoi(); return(ds); } catch { return(null); } }
public laydulieu() { L_Ketnoi.ThietlapketNoi(); }