请问sqlcommand怎么插入不进去记录！

Question

如题，总是提示“CommandText 属性尚未初始化”，晕菜了！
public partial class Form1 : Form
    {
        private const string SQL_INSERT_AFFICHE = "INSERT INTO game_Affiche VALUES(game_type,game_qishu,game_number,game_time);";
        private const string PARM_GAME_TYPE = "@game_type";
        private const string PARM_GAME_QISHU = "@game_qishu";
        private const string PARM_GAME_NUMBER = "@game_number";
        private const string PARM_GAME_TIME = "@game_time";
        public Form1()
        {
            InitializeComponent();
        }        private void button1_Click(object sender, EventArgs e)
        { 
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = "Data Source=COMPANY-675F440\\SQLEXPRESS;Initial Catalog=keno_tablet;User Id=sa;Password=beijing;";//此处设置链接字符串
             StringBuilder strSQL = new StringBuilder();
            SqlCommand cmd = new SqlCommand();
            SqlParameter[] afficheParms = GetafficheParameters();
            afficheParms[0].Value = "s";
            afficheParms[1].Value = "s";
            afficheParms[2].Value = "s";
            afficheParms[3].Value = "s";            foreach (SqlParameter parm in afficheParms)
            {
                cmd.Parameters.Add(parm);
            }
                conn.Open();
                cmd.Connection = conn;
                cmd.CommandType = CommandType.Text;
                cmd.ExecuteNonQuery();
        }
        private static SqlParameter[] GetafficheParameters()
        {
            SqlParameter[] parms = SQLHelper.GetCachedParameters(SQL_INSERT_AFFICHE);            if (parms == null)
            {
                parms = new SqlParameter[]{
                    new SqlParameter(PARM_GAME_TYPE,SqlDbType.VarChar,50),
                    new SqlParameter(PARM_GAME_QISHU,SqlDbType.VarChar,50),
                    new SqlParameter(PARM_GAME_NUMBER,SqlDbType.VarChar,80),
                    new SqlParameter(PARM_GAME_TIME,SqlDbType.VarChar,50)};                SQLHelper.CacheParameters(SQL_INSERT_AFFICHE, parms);
            }
            return parms;
        }
    }

Answer 1

conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = SQL_INSERT_AFFICHE;
cmd.ExecuteNonQuery();

Answer 2

...被楼上的抢了，刚刚回的时候CSDN数据库挂了
555～～～

Answer 3

using(SqlConnection conn = new SqlConnection(""))
{
  SqlCommand cmd = new SqlCommand();
  conn.Open();
  cmd.Connection = conn;}
字符串是否正确

Answer 4

cmd.CommandText = SQL_INSERT_AFFICHE； 

Answer 5

哦！谢谢！但是现在又出现一个新的问题private const string SQL_INSERT_AFFICHE = "INSERT INTO game_Affiche VALUES(game_type,game_qishu,game_number,game_time);";这个查询语句，是错的！但我是仿照PetShop的写法写的，怎么不行呢。是不是缺什么方法！

Answer 6

郁闷 就这个贴回的贴写了半天，提交
CSDN挂了。
过了2分钟好了，1楼回了，于是郁闷的跟贴，提交
CSDN又挂了。。人间悲剧啊～

Answer 7

private const string SQL_INSERT_AFFICHE = "INSERT INTO game_Affiche VALUES(@game_type,@game_qishu,@game_number,@game_time);"; 

Answer 8

private const string SQL_INSERT_AFFICHE = "INSERT INTO game_Affiche VALUES(" +PARM_GAME_TYPE +","+PARM_GAME_QISHU +","+PARM_GAME_NUMBER +","+PARM_GAME_TIME +");"; 

Answer 9

private const string SQL_INSERT_AFFICHE = "INSERT INTO game_Affiche VALUES(@game_type,@game_qishu,@game_number,@game_time);"; 

Answer 10

8楼的写法，肯定是正确的，但是我不想这样写，想像private const string SQL_INSERT_AFFICHE = "INSERT INTO game_Affiche VALUES(game_type,game_qishu,game_number,game_time);";这样写！后面程序处理的时候自动给填上！

Answer 11

  parms = new SqlParameter[]{
                    new SqlParameter(PARM_GAME_TYPE,SqlDbType.VarChar,50),
                    new SqlParameter(PARM_GAME_QISHU,SqlDbType.VarChar,50),
                    new SqlParameter(PARM_GAME_QISHU,SqlDbType.VarChar,80),
                    new SqlParameter(PARM_GAME_QISHU,SqlDbType.VarChar,50)};
你这里的PARM_GAME_TYPE，PARM_GAME_QISHU，PARM_GAME_QISHU，PARM_GAME_QISHU都赋值没有？

Answer 12

建议这么写  好习惯StringBuilder sqlCmd = "Select * From [TAB] Where id = [ID]";
sqlCmd.replace("[TAB]", "HelloWorld");
sqlCmd.replace("[ID]", id.ToString());
SqlCommand cmd = new SqlCommand(sqlCmd.ToString());