Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Public Static String: //lay Danh Sach Hien Len Datagirdview

    Uploaded by

    Nguyen Cong Huy
    The document contains code for connecting to a SQL database and performing queries. It defines methods for getting a SQL connection, executing queries, getting employee names and datasets of employee data, loading combo boxes with department data, and loading a data grid view with employee data from a dataset.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd

    Public Static String: //lay Danh Sach Hien Len Datagirdview

    Uploaded by

    Nguyen Cong Huy
    21 views2 pages
    The document contains code for connecting to a SQL database and performing queries. It defines methods for getting a SQL connection, executing queries, getting employee names and datasets of employee data, loading combo boxes with department data, and loading a data grid view with employee data from a dataset.

    Original Title

    BM

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains code for connecting to a SQL database and performing queries. It defines methods for getting a SQL connection, executing queries, getting employee names and datasets of employee data, loading combo boxes with department data, and loading a data grid view with employee data from a dataset.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    21 views2 pages

    Public Static String: //lay Danh Sach Hien Len Datagirdview

    Uploaded by

    Nguyen Cong Huy
    The document contains code for connecting to a SQL database and performing queries. It defines methods for getting a SQL connection, executing queries, getting employee names and datasets of employee data, loading combo boxes with department data, and loading a data grid view with employee data from a dataset.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    You are on page 1of 2

    public static SqlConnection ketnoidl()

    {
    string str = @"Data
    Source=.\SQLEXPRESS;AttachDbFilename=J:\TONG
    HOP\BTL_KI5\QUANLYNHANSU\QUANLYNHANSU\TABUCHI1.MDF;Integrated
    Security=True;Connect Timeout=30;User Instance=True ";
    SqlConnection conn = new SqlConnection(str);
    conn.Open();
    return conn;
    }
    public static void thucthi(string sql)
    {
    SqlConnection conn = ketnoidata.ketnoidl();
    SqlCommand cmd = new SqlCommand(sql,conn);
    cmd.ExecuteNonQuery();
    conn.Close();
    }

    public string TenNV(string manv)


    {
    string sql = "SELECT Ten FROM NhanVien WHERE MaNV =
    '"+manv+"'";
    SqlConnection con = DataProvider.ketnoidulieu();
    SqlDataAdapter dad = new SqlDataAdapter(sql, con);
    DataSet ds = new DataSet();
    dad.Fill(ds);
    string tmp = ds.Tables[0].Rows[0]["Ten"].ToString();
    return tmp;
    }

    public DataSet laydanhsach()


    {

    string sql = "select * FROM NhanVien";


    string tenbang = "NhanVien";
    SqlConnection con = DataProvider.ketnoidulieu();
    SqlDataAdapter dad = new SqlDataAdapter(sql, con);
    DataSet ds = new DataSet();
    dad.Fill(ds, tenbang);
    return ds;
    }

    //Lay danh sach hien len datagirdview


    public DataSet LayDanhSach()
    {
    NhanVienDao nvdao = new NhanVienDao();
    DataSet ds = nvdao.laydanhsach();
    return ds;
    }

    public void hienthiconbobox(ComboBoxEx combox)


    {
    Phong_dao phongdao = new Phong_dao();
    combox.DataSource = phongdao.Laydsphong();
    combox.DisplayMember = "Tenphong";
    combox.ValueMember = "Maphong";
    }

    public void loaddtgv()


    {
    NhanVienBus nvBus = new NhanVienBus();
    DataSet ds = nvBus.LayDanhSach();
    dataGridViewX1.DataSource = ds.Tables["NhanVien"];
    dataGridViewX1.AutoResizeColumns();
    // dataGridViewX1.AutoSize();
    }

    You might also like