¾È³çÇϼ¼¿ä °»ç´Ô
SqlDataReade¸¦ ÀÌ¿ëÇؼ »ó¼¼ÆäÀÌÁö¸¦ ¸¸µé¶§ °ü·Ã Áú¹®ÀÔ´Ï´Ù.
public SqlDataReader SelectReplyByNum(int num)
{
SqlConnection objCon = new SqlConnection(_ConnectionString);
objCon.Open();
SqlCommand objCmd = new SqlCommand("ViewReply", objCon);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@Num", num);
SqlDataReader objDr = objCmd.ExecuteReader();
return objDr; // Close() ->using () { }»ç¿ëÇؼ Close() ó¸® ÇÊ¿ä
}
-----------------------------------------------------------------------
Áú¹®Àº¿ä
1. À§¿¡´Â ½ÇÀç·Î using±¸¹®À» »ç¿ëÇؼ Ŭ·Î¡ÇÏÁö ¾Ê°í //Àο뿡¼¸¸ Ŭ·Î¡ó¸®°¡ ÇÊ¿äÇÏ´Ù°í ¸»¾¸Çϼ̽À´Ï´Ù.
±×·±µ¥ Ŭ·Î¡ 󸮸¦ ¾Æ·¡¿Í °°ÀÌ
Using(SqlDataReader objDr = objCmd.ExecuteReader())
{
return objDr;
}
·Î ¾Ë°í Àִµ¥¿ä....
À§Ã³·³ Ŭ·Î¡ 󸮸¦ ¾ÈÇصµ ¶È °°Àº ÀǹÌÀÎÁö¸¦ ¾Ë°í ½Í½À´Ï´Ù.
2¹ø° Áú¹®Àº SqlDataReder¸¦ »ç¿ëÇÒ¶§
SqlDataReader objDr = objCmd.ExecuteReader();
While(objDr.Read( ))
{
lblName.Text = objDr["Name"].ToString();
lblEmail.Test = objDr["Email"].ToString()
}
ÀÌ·¸°Ô Read ¸Þ¼µå¸¦ ÀÌ¿ëÇؼ ¹Ýº¹ÀûÀ¸·Î ¹ÙÀεùÀ» ÇÏ´Â °ÍÀ¸·Î ¾Ë°í Àִµ¥¿ä
¸Ç À§ÀÇ ¿¹Á¦´Â While°ú Read¸Þ¼µå¸¦ »ç¿ëÇÏÁö ¾Ê¾Ò´Âµ¥ ±×Â÷À̸¦ ¾Ë°í½Í½À´Ï´Ù.
Áñ°Å¿î ÁÖ¸» µÇ½Ê½Ã¿À
|