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

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

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

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

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


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


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