¾È³çÇϼ¼¿ä.
A Å×À̺íÀÇ Æ¯Á¤ Ä÷³À» B Å×À̺í·Î ¿Å±â´Â Äõ¸®´Â ¾Æ·¡¿Í °°Àº
Äõ¸®¹®À¸·Î ½ÇÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.
INSERT INTO B SELECT COL1, COL2, COL3 FROM A
ˤ
Äõ¸®¹® ÇüŸ¦ »ç¿ëÇϸé
string strSql = "INSERT INTO B SELECT COL1, COL2, COL3 FROM A";
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();
ÇüÅ·ΠÇϳªÀÇ Ä¿³Ø¼Ç °³Ã¼¸¸À» »ç¿ëÇÏ¿© ±¸¹®À» ó¸®ÇÒ ¼ö ÀÖ½À´Ï´Ù.
¸¸¾à,
Äõ¸®¸¦ µû·Îµû·Î ÇÏ°íÀÚÇÒ ¶§¿¡´Â
while (objDr.Read()) //¹Ýº¹Çؼ ÀÐÀ½
{
// ÀÌ ¾È¿¡¼ objCon2¸¦ »õ·Ó°Ô »ý¼ºÇÏ´Â Äڵ带 ±¸ÇöÇÏ¸é µË´Ï´Ù. Ä¿³Ø¼Ç, Ä¿¸àÆ®, Insert±îÁö
}
Ãß°¡·Î
Insert Into Select±¸¹®°ú
Select Into ±¸¹®À» ±¸±Û¿¡¼ °Ë»öÇغ¸½Ã¸é
Å×À̺í A¿¡¼ Å×À̺í B·Î ÇÊ¿äÇÑ Ä÷³¸¸ º¹»çÇÏ´Â
Äõ¸®¸¦ »ìÆ캸½Ç ¼ö ÀÖ½À´Ï´Ù.
±èÁø¸¸ ´ÔÀÌ ¾²½Å ¿ø¹® ±ÛÀÔ´Ï´Ù.
¾È³çÇϼ¼¿ä °»ç´Ô
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();
}
|