¾È³çÇϼ¼¿ä.
ÀÌ¹Ì Á¤´äÀ» ¾Ë°í °è½Å°Í °°Àºµ¥¿ä.
ASP.NET¿¡¼ µû·Î ½ºÄÌÁÙ¸µÇØÁÖ´Â ±â´ÉÀº Á¦°øÇÏ°í ÀÖÁö ¾Ê½À´Ï´Ù.
¾Æ½±°Ôµµ Á¦ °ÀÇ Àüü¸¦ ÅëÅоµ
Áú¹® ÁֽŠºÎºÐ°ú °ü·ÃµÈ ¿¹Á¦´Â Á¦°øÇÏ°í ÀÖÁö ¾Ê½À´Ï´Ù.
°ü·ÃÇؼ´Â
Á¦°¡ µµ¿òµÉ ÀÚ·á°¡ ¾ø±â¿¡, ±¸±Û °Ë»öÀ» Çغ¸½Ã¸é ÁÁÀ» °Í °°½À´Ï´Ù.
±èÁø¸¸ ´ÔÀÌ ¾²½Å ¿ø¹® ±ÛÀÔ´Ï´Ù.
¾È³çÇϼ¼¿ä °»ç´Ô
SQL ½ºÄÉÁì·¯¸¦ »ç¿ëÇÏÁö ¾Ê°í
´å³Ý ÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© ÁÖ±âÀûÀ¸·Î(¿¹: ¸Å 10ºÐ¸¶´Ù) ƯÁ¤ÇÑ µ¥ÀÌŸ¸¦ ÀÔ·ÂÇÏ´Â ¹æ¹ýÀÌ ÀÖ³ª¿ä?
±×¸®°í ³ª¸§ TimeSpanÀ» ÀÌ¿ëÇؼ ¸¸µé¾îºÃ´Âµ¥¿ä.
¸·»ó µ¹·Áº¸´Ï insert°¡ ¾ÈµË´Ï´Ù.
¾î¶² ·ÎÁ÷ÀÌ À߸øµÇ¾ú´ÂÁö ¾Ë°í½Í½À´Ï´Ù.
string strSql = "Insert into Students_Test(StudentName, Score) Values('±èö¼ö', 80)";
DateTime PostDate = Convert.ToDateTime("2017-03-03 15:29:30.257");
TimeSpan ts1 = DateTime.Now - Convert.ToDateTime(PostDate);
while ( ts1.TotalMinutes % 10 == 0) //¸Å 10ºÐ¸¶´Ù ¹Ýº¹
{
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();
}
|