¾È³çÇϼ¼¿ä °»ç´Ô
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();
}
|