Exemple #1
0
        public List <Docgia> Show()
        {
            List <Docgia> lst = new List <Docgia>();

            if (con.State != ConnectionState.Open)
            {
                con.Open();
            }
            SqlCommand sc = new SqlCommand("xem_docgia", con);

            sc.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter da = new SqlDataAdapter(sc);
            DataTable      dt = new DataTable();

            da.Fill(dt);
            foreach (DataRow row in dt.Rows)
            {
                Docgia Docgia = new Docgia();
                Docgia.cmnd     = row[0].ToString();
                Docgia.ten      = row[1].ToString();
                Docgia.ngaysinh = row[2].ToString();
                Docgia.diachi   = row[3].ToString();
                Docgia.gioitinh = row[4].ToString();
                Docgia.taikhoan = row[5].ToString();
                Docgia.matkhau  = row[6].ToString();
                lst.Add(Docgia);
            }
            con.Close();
            return(lst);
        }
Exemple #2
0
        public void Add(Docgia docgia)
        {
            if (con.State != ConnectionState.Open)
            {
                con.Open();
            }
            SqlCommand sc = new SqlCommand("them_docgia", con);

            sc.Parameters.Add(new SqlParameter("cmnd", docgia.cmnd));
            sc.Parameters.Add(new SqlParameter("ten", docgia.ten));
            sc.Parameters.Add(new SqlParameter("ngaysinh", docgia.ngaysinh));
            sc.Parameters.Add(new SqlParameter("diachi", docgia.diachi));
            sc.Parameters.Add(new SqlParameter("gioitinh", docgia.gioitinh));
            sc.Parameters.Add(new SqlParameter("taikhoan", docgia.taikhoan));
            sc.Parameters.Add(new SqlParameter("matkhau", docgia.matkhau));
            sc.CommandType = CommandType.StoredProcedure;
            sc.ExecuteNonQuery();
            con.Close();
        }