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