ÁúÀÇ »çÇ×ÀÌ ÀÖ½À´Ï´Ù.
1.¾Æ·¡ page_load ADO.NETÀÇ connectionÀº ¹Ýµå½Ã close()¸¦ ÇØÁà¾ßÇÏ´ÂÁö¿ä?
ÇØ´ç ±¸¹®ÀÌ ¸ðµÎ ½ÇÇà µÉ °æ¿ì °¡ºñÁö Ä÷ºÅÍ¿¡ ÀÇÇؼ ÀÚµ¿À¸·Î ÇØÁ¦°¡ µÇ´ÂÁö ¿ä?
2. ¾Æ·¡¿Í °°Àº ¹®Á¦°¡ ¹ß»ýÇßÀ» °æ¿ì ÀÚµ¿À¸·Î close()ÇÒ¼ö ÀÖ´Â µðÀÚÀÎ ÆÐÅÏÀ̳ª ¹æ¹ýÀ» ¾Ë·ÁÁÖ¼¼¿ä.
protected void Page_Load(object sender, EventArgs e)
{
// [1] º¯¼ö ¼±¾ð ¹× ÃʱâÈ
int intcount = 0;
string strresult = "success";
// [2] µ¥ÀÌÅͺ£À̽º ¿±â
DBconnst1 conn = new DBconnst1();
conn.Open();
// [3] SQL ¹® ½ÇÇà
string sql = string.Empty;
sql = "SELECT count(nkey) as f_count " +
"FROM item WHERE o_no=@o_no and o_state <> 2";
// [4] ÆĶó¹ÌÅÍÁöÁ¤ - ÆĶó¹ÌÅÍ ÄÝ·º¼ÇÀ» »ý¼º
List parameters = new List();
parameters.Add(new SqlParameter("@o_no", parao_no));
SqlDataReader reader = conn.ExecuteReader(sql, 0, parameters, true);
// [5] ½ÇÇà °á°ú Ãâ·Â
while (reader.Read())
{
intcount = int.Parse(reader["f_count"].ToString());
}
// [6] µ¥ÀÌÅͺ£À̽º ´Ý±â
reader.Close();
}
|