下面这段是什么意思啊!
SqlParameter[] parameters = {   
new SqlParameter("@_DanWeiBianHao",this.TextBoxaa.Text.ToString().Trim()),
new SqlParameter("@_StartTime",DateTime.Parse(DDLNianDu1.QsNianDu)),
new SqlParameter("@_EndTime",DateTime.Parse(DDLNianDu1.JzNianDu)),
new SqlParameter("@_condition",ViewState["TiaoJian"].ToString()),
new SqlParameter("@_kind","1"),
new SqlParameter("@MyNianDu",this.DDLNianDu1.MyNianDu)
};

解决方案 »

  1.   

    执行一条sql语句需要参数,这是在构造参数。
    SqlParameter()方法的第一个参数是参数的名称,第二个是参数的值。
      

  2.   

    给你个例子看下: public void AddCarConfiguration(ECUData.DataManage.CarConfiguration carConfiguration)
            {
                int insertID = 0;
                string insertSql = "insert into CarConfiguration(Name,CollateStatus,CollateComment,AuditingStatus,AuditingComment,DFID,EngineModel,VehicelModel,Idle,KTKZMS,QDJKZMS,PQZDMK,DZYMTBCJ,XHGN,PTOGN,RYYSBJGN,BSXXH,HQSB,LTGG,CSXHHQFS,FDJZSSCFS,SWSCFS,JYYLSCFS,SFDCANZX,JQJRMK,CJQDTZGN,Comment) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
                using (Gongfang.Data.OleSql oleSql = new OleSql(conn))
                {
                    System.Data.OleDb.OleDbParameter[] parameters = new OleDbParameter[27];
                    parameters[0] = new System.Data.OleDb.OleDbParameter("@1", carConfiguration.Name);
                    parameters[1] = new System.Data.OleDb.OleDbParameter("@2", carConfiguration.CollateStatus);
                    parameters[2] = new System.Data.OleDb.OleDbParameter("@3", carConfiguration.CollateComment);
                    parameters[3] = new System.Data.OleDb.OleDbParameter("@4", carConfiguration.AuditingStatus);
                    parameters[4] = new System.Data.OleDb.OleDbParameter("@5", carConfiguration.AuditingComment);
                    parameters[5] = new System.Data.OleDb.OleDbParameter("@6", carConfiguration.DFID);
                    parameters[6] = new System.Data.OleDb.OleDbParameter("@7", carConfiguration.EngineModel);
                    parameters[7] = new System.Data.OleDb.OleDbParameter("@8", carConfiguration.VehicelModel);
                    parameters[8] = new System.Data.OleDb.OleDbParameter("@9", carConfiguration.Idle);
                    parameters[9] = new System.Data.OleDb.OleDbParameter("@10", carConfiguration.KTKZMS);
                    parameters[10] = new System.Data.OleDb.OleDbParameter("@11", carConfiguration.QDJKZMS);
                    parameters[11] = new System.Data.OleDb.OleDbParameter("@12", carConfiguration.PQZDMK);
                    parameters[12] = new System.Data.OleDb.OleDbParameter("@13", carConfiguration.DZYMTBCJ);
                    parameters[13] = new System.Data.OleDb.OleDbParameter("@14", carConfiguration.XHGN);
                    parameters[14] = new System.Data.OleDb.OleDbParameter("@15", carConfiguration.PTOGN);
                    parameters[15] = new System.Data.OleDb.OleDbParameter("@16", carConfiguration.RYYSBJGN);
                    parameters[16] = new System.Data.OleDb.OleDbParameter("@17", carConfiguration.BSXXH);
                    parameters[17] = new System.Data.OleDb.OleDbParameter("@18", carConfiguration.HQSB);
                    parameters[18] = new System.Data.OleDb.OleDbParameter("@19", carConfiguration.LTGG);
                    parameters[19] = new System.Data.OleDb.OleDbParameter("@20", carConfiguration.CSXHHQFS);
                    parameters[20] = new System.Data.OleDb.OleDbParameter("@21", carConfiguration.FDJZSSCFS);
                    parameters[21] = new System.Data.OleDb.OleDbParameter("@22", carConfiguration.SWSCFS);
                    parameters[22] = new System.Data.OleDb.OleDbParameter("@23", carConfiguration.JYYLSCFS);
                    parameters[23] = new System.Data.OleDb.OleDbParameter("@24", carConfiguration.SFDCANZX);
                    parameters[24] = new System.Data.OleDb.OleDbParameter("@25", carConfiguration.JQJRMK);
                    parameters[25] = new System.Data.OleDb.OleDbParameter("@26", carConfiguration.CJQDTZGN);
                    parameters[26] = new System.Data.OleDb.OleDbParameter("@27", carConfiguration.Comment);
                    oleSql.Execute(insertSql, parameters);                }
                                 
            }