public DataTable f_lay_tt_nv()
{
string str = "Select Manhanvien,Hotennhanvien,ngaysinh,diachi,dienthoai,tenbangcap from NhanVien n,bangcap b where n.MaBangCap=b.MaBangCap";
return db.f_Thucthi_select(str);
}
public DataTable LayDSBangCap()
{
return db.f_Thucthi_select("select * from BangCap");
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.Data;
namespace WindowsFormsApplication1
{
class C_database
{
SqlConnection conn= new SqlConnection();
public C_database(string s, string db)
{
string str = string.Format("server={0};database={1};integrated security=true", s, db);
conn.ConnectionString = str;
f_moketnoi();
}
public C_database(string s, string db, string u, string p)
{
string str = string.Format("server={0};database={1};uid={2};pwd={3}", s, db, u, p);
conn.ConnectionString = str;
f_moketnoi();
}
private bool f_moketnoi()
{
try
{
conn.Open();
MessageBox.Show("Thanh cong");
return true;
}
catch (Exception ex)
{
MessageBox.Show("ko thanh cong" + ex.Message);
return false;
}
}
public DataTable f_Thucthi_select(string sqlstr)
{
try
{
SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);
DataSet ds = new DataSet();
da.Fill(ds);
return ds.Tables[0];
}
catch(Exception ex)
{
MessageBox.Show("loi select"+ex.Message);
return new DataTable();
}
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.Data;
namespace WindowsFormsApplication1
{
class C_database
{
SqlConnection conn= new SqlConnection();
public C_database(string s, string db)
{
string str = string.Format("server={0};database={1};integrated security=true", s, db);
conn.ConnectionString = str;
f_moketnoi();
}
public C_database(string s, string db, string u, string p)
{
string str = string.Format("server={0};database={1};uid={2};pwd={3}", s, db, u, p);
conn.ConnectionString = str;
f_moketnoi();
}
private bool f_moketnoi()
{
try
{
conn.Open();
MessageBox.Show("Thanh cong");
return true;
}
catch (Exception ex)
{
MessageBox.Show("ko thanh cong" + ex.Message);
return false;
}
}
public DataTable f_Thucthi_select(string sqlstr)
{
try
{
SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);
DataSet ds = new DataSet();
da.Fill(ds);
return ds.Tables[0];
}
catch(Exception ex)
{
MessageBox.Show("loi select"+ex.Message);
return new DataTable();
}
}
}
}