Devlec.com Javacstudy.com
MyÆäÀÌÁö |  óÀ½»ç¿ëÀÚ ÀÌ¿ë¾È³» |  ÀÌ¿ë¹®ÀÇ |  ȸ»ç¼Ò°³

¡á Æ©ÅÍ°Ô½ÃÆÇ Article Number : 26230

±èÁø¸¸´ÔÀÌ ÀÛ¼ºÇϽŠ³»¿ëÀÔ´Ï´Ù. 2016-12-22   |   Refer : 474
÷ºÎÆÄÀÏ : None   À̹ÌÁö : None ŸÀÔ : °ø°³±Û

¾È³çÇϼ¼¿ä °­»ç´Ô

AÅ×À̺íÀÇ Çʵ带 ¹Ýº¹ÀûÀ¸·Î ÀÐÀº ÈÄ¿¡ ÀÐÀº µ¥ÀÌŸ¸¦ B·Î ÀúÀåÇÏ´Â ·ÎÁ÷ÀÌ ±Ã±ÝÇÕ´Ï´Ù.

¹Ýº¹Çؼ­ ÀÐÀº°Í±îÁö´Â ¾Ë°Ú´Âµ¥¿ä, ÀÌ°ÍÀ» ¾î¶»°Ô ¹Þ¾Æ¼­ ÀúÀåÀ» ÇÏ´ÂÁö¸¦ ¸ð¸£°Ú½À´Ï´Ù.



protected void btnWrite_Click(object sender, EventArgs e)
{

string strSql = "Select * from TableA order by Num Asc";

SqlConnection objCon = new SqlConnection();
objCon.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
objCon.Open();
SqlCommand objCmd = new SqlCommand();
objCmd.Connection = objCon;
objCmd.CommandText = strSql;
objCmd.CommandType = System.Data.CommandType.Text;

SqlDataReader objDr = objCmd.ExecuteReader();


while (objDr.Read()) //¹Ýº¹Çؼ­ ÀÐÀ½
{
string Name.Text += objDr[1].ToString();
string Email.Text += objDr[2].ToString();
}
objCon.Close();

Áú¹®1) ¿©±â¿¡¼­ WhileÀ» ÀÌ¿ëÇؼ­ ÀÐÀº °ÍÀ» ÀÔ·ÂÇÏ·Á¸é ¾Æ·¡ÀÇ Insert±¸¹®À» ¾î¶² ±¸¹®À» »ç¿ëÇØ¾ß ÇÏ´ÂÁö¿ä?

Áú¹®2) ÇÑ Çʵ常 Àаí ÀúÀåÇÏ°í ¶Ç ÇÑÇʵ常 Àаí ÀúÀåÇÏ´Â ¹æ¹ýµµ ÀÖ´ÂÁö¿ä?À§ÀÇ While ±¸¹® ¾È¿¡ ¾Æ·¡ÀÇ inset±¸¹®À» ³Ö¾î¼­ ¹Ýº¹ÀûÀ¸·Î ÀÔ·ÂÇÏ·Á°í Çߴµ¥ ¿¡·¯°¡ ³ª¼­ ½ÇÆÐÇß½À´Ï´Ù. ¾î¶² ¹æ¹ýÀÌ È¿À²ÀûÀÎÁö¿ä?


string strSql2 = "Insert TableB(Name,Email) Values("+Name+","+Emil");
SqlConnection objCon = new SqlConnection();
objCon.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
objCon.Open();
SqlCommand objCmd = new SqlCommand();
objCmd.Connection = objCon;
objCmd.CommandText = strSql;
objCmd.CommandType = System.Data.CommandType.Text;
objCmd.ExecuteNonQuery();

objCon.Close();

}


·Îµù½Ã°£ : 0.031 sec
±Û ´äº¯   ±Û ¼öÁ¤   ±Û »èÁ¦   ±Û ¸ñ·Ï


   
   
Ȩ ȸ»ç¼Ò°³ ÀÌ¿ë¾à°ü °³ÀÎÁ¤º¸ º¸È£Á¤Ã¥ ÀÌ¿ë¾È³» Q&A FAQ Guide