菜鸟提问:如何插入相应的数据啊？

Question

string cmdtext = "insert into kaoqin(kdate,kweek,ktime1) values('"+DateTime.Now.ToString("YYYY-MM-dd")+"','"+DateTime.Now.DayOfWeek()+"','" + DateTime.Now.ToString("HH:mm:ss") + "')";
 我想插入 数据 Kdate 显示的为当前的日期     格式为  2008-06-23
               kweek 显示为当前日期是星期几         星期一（要是中文显示）
               ktime1 显示为当前的时间              13：15（根据服务器当前时间）

Answer 1

String week = "";
        switch (DateTime.Now.DayOfWeek)
        {
            case DayOfWeek.Friday:
                week = "星期五";
                break;
            case DayOfWeek.Monday:
                week = "星期一";
                break;
            case DayOfWeek.Saturday:
                week = "星期六";
                break;
            case DayOfWeek.Sunday:
                week = "星期天";
                break;
            case DayOfWeek.Thursday:
                week = "星期四";
                break;
            case DayOfWeek.Tuesday:
                week = "星期二";
                break;
            case DayOfWeek.Wednesday:
                week = "星期三";
                break;
            default:
                break;
        }

Answer 2

当前日期：
DateTime.Now.TOShortDateString();当前时间：
DateTime.Now.ToShortTimeString();