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

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

¹Ú¿ëÁØ °­»ç´ÔÀÌ ÀÛ¼ºÇϽŠ³»¿ëÀÔ´Ï´Ù. 2017-03-04   |   Refer : 421
÷ºÎÆÄÀÏ : None   À̹ÌÁö : None ŸÀÔ : °ø°³±Û


¾È³çÇϼ¼¿ä.

ÀÌ¹Ì Á¤´äÀ» ¾Ë°í °è½Å°Í °°Àºµ¥¿ä.

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(); }

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


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