public IList select_allhoa() { ArrayList list = new ArrayList(); string conn = ConfigurationManager.ConnectionStrings["Ketnoi"].ToString(); SqlConnection objConn = new SqlConnection(conn); objConn.Open(); SqlCommand objComm = new SqlCommand("Xem_loaihang", objConn); objComm.CommandType = CommandType.StoredProcedure; SqlDataReader dr = objComm.ExecuteReader(); LoaiHangInfo hoa = null; while (dr.Read()) { hoa = new LoaiHangInfo(); if (!dr.IsDBNull(0)) { hoa.maloai = dr.GetString(0); } if (!dr.IsDBNull(1)) { hoa.tenloai = dr.GetString(1); } list.Add(hoa); } dr.Close(); objConn.Close(); return(list); }
public int insertLoai(LoaiHangInfo loaihang) { int i = 0; string conn = ConfigurationManager.ConnectionStrings["STR"].ToString(); SqlConnection objConn = new SqlConnection(conn); objConn.Open(); SqlCommand objComm = new SqlCommand("insert_loaihanghoa1", objConn); objComm.CommandType = CommandType.StoredProcedure; SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@maloai", SqlDbType.Int), new SqlParameter("@tenloai", SqlDbType.NVarChar) }; parms[0].Value = loaihang.maloai; parms[1].Value = loaihang.tenloai; objComm.Parameters.AddRange(parms); i = objComm.ExecuteNonQuery(); objConn.Close(); return(i); }