mdb mysql c#

string sql = string.Format("SELECT sTitle FROM TbQuestionSense WHERE sUrl = '{0}'", sUrl);

 

string sql = string.Format("DELETE FROM TbOtherMembers WHERE dtDateTime BETWEEN CVDATE('{0}') AND CVDATE('{1}') AND sRday = '{2}'      ", _s하루전, _s지금, sRday);

 

_sQuery = string.Format("INSERT INTO TbAllReport(dtDateTime, sCatagory, pk, sBodyHtml) VALUES (@dtDateTime, @sCatagory, @pk, @sBodyHtml)");

comm.Parameters.Add("@dtDateTime", OleDbType.Date);

comm.Parameters["@dtDateTime"].Value = dtDateTime;

 

 

//DESC 내림, ASC 오름

string sql = string.Format("SELECT sTitle, sCodeMajor, sDownCnt FROM TbDgvWebhardContents ORDER BY sTitle DESC")

 

//null 읽을때

string sql = string.Format("SELECT sUrl FROM TbQuestionSense WHERE sUrl = '{0}' AND sState is NULL", sUrl);