数据表脚本
CREATE TABLE [SurveyTaskInfo] (
[SurveyTaskID] [int] IDENTITY (1, 1) NOT NULL ,
[SurveyTaskName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BeginDate] [datetime] NOT NULL ,
[PlanEndDate] [datetime] NOT NULL ,
[EndDate] [datetime] NULL ,
[Re] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[ProjectID] [int] NOT NULL ,
[ProjectProfessionalID] [int] NOT NULL ,
[DirectorID] [int] NOT NULL ,
PRIMARY KEY CLUSTERED
(
[SurveyTaskID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
--------------------------拼装sql(请不要鄙视我有sql拼装,这段代码一起时用参数形式的,为了方便调试才改成这样的)
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SurveyTaskInfo (");
strSql.Append("SurveyTaskName,BeginDate,PlanEndDate,EndDate,Re,ProjectID,ProjectProfessionalID,DirectorID)");
strSql.Append(" values('");
strSql.Append(model.SurveyTaskName + "','" + model.BeginDate + "','" + model.PlanEndDate + " ',' " + model.EndDate + "','" + model.Re + "'," + model.ProjectID + "," + model.ProjectProfessionalID + "," + model.DirectorID + ")"); SqlConnection conn = new SqlConnection(连接语句);
conn.Open();
SqlCommand command = new SqlCommand(strSql.ToString(), conn);
command.ExecuteNonQuery();
conn.Close();
程序运行时总是提示列名 'BeginDate' 无效。
CREATE TABLE [SurveyTaskInfo] (
[SurveyTaskID] [int] IDENTITY (1, 1) NOT NULL ,
[SurveyTaskName] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BeginDate] [datetime] NOT NULL ,
[PlanEndDate] [datetime] NOT NULL ,
[EndDate] [datetime] NULL ,
[Re] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[ProjectID] [int] NOT NULL ,
[ProjectProfessionalID] [int] NOT NULL ,
[DirectorID] [int] NOT NULL ,
PRIMARY KEY CLUSTERED
(
[SurveyTaskID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
--------------------------拼装sql(请不要鄙视我有sql拼装,这段代码一起时用参数形式的,为了方便调试才改成这样的)
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SurveyTaskInfo (");
strSql.Append("SurveyTaskName,BeginDate,PlanEndDate,EndDate,Re,ProjectID,ProjectProfessionalID,DirectorID)");
strSql.Append(" values('");
strSql.Append(model.SurveyTaskName + "','" + model.BeginDate + "','" + model.PlanEndDate + " ',' " + model.EndDate + "','" + model.Re + "'," + model.ProjectID + "," + model.ProjectProfessionalID + "," + model.DirectorID + ")"); SqlConnection conn = new SqlConnection(连接语句);
conn.Open();
SqlCommand command = new SqlCommand(strSql.ToString(), conn);
command.ExecuteNonQuery();
conn.Close();
程序运行时总是提示列名 'BeginDate' 无效。
解决方案 »
- c# 委托和事件什么时候应用呢
- 200分:这个效果谁能实现?——在线结贴
- ICSharpCode.SharpZipLib.dll 该压缩组件 可以将几个txt文件压缩为 一个zip 文件吗?
- ASP.NET 2.0邮件发送问题
- 一个javascript简单的问题(在线)
- JS教本,如何实现两个DropDownList的同步?
- javascript调用ASP.NET脚本问题
- VS 2005中如何点击进入详细信息?
- 100分 !!! 分享视频资源 !!!!!!!!!
- 我想实现这样的功能,最好能有关键的代码,高手请进
- asp.net 等待3秒后跳转到其他页面,不用js,后台写就可以谢谢
- 求教如何用Js控制datagrid和gridview这样的列表控件中的某一列的隐藏和显示
strSql.ToString()
不久明白了,啊
conn.ConnectionString = "Data Source=.;Initial Catalog=db_OAChang;Persist Security Info=True;User ID=sa;Password=123456";
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SurveyTaskInfo (");
strSql.Append("SurveyTaskName,BeginDate,PlanEndDate,EndDate,Re,ProjectID,ProjectProfessionalID,DirectorID)");
strSql.Append(" values('");
strSql.Append(SurveyTaskName + "','" + BeginDate + "','" + PlanEndDate + " ',' " + EndDate + "','" + Re + "'," + ProjectID + "," + ProjectProfessionalID + "," + DirectorID + ")");
conn.Open();
SqlCommand command = new SqlCommand(strSql.ToString(), conn);
command.ExecuteNonQuery();
conn.Close();
本人试了一下没有错
自己先断点找出插入数据库的SQL语句. 看那个执行有没有错误.
要不就是你数据库的字段与插入字段的格式不匹配,要不就是你要插入的数据没处理好.
是不是少了个单引号啊?
strSql.Append("'" + SurveyTaskName + "','" + BeginDate + "',……
试试
StringBuilder sb=new StringBuilder();
sb.Append(string.Format("insert into xxx (x,x,x) values({0},{1},{2})",x,x,x));这样, 好检查错误,
其次, 你出错了, 要断点一下, 将sb的最终字符串贴出来, 这样, 人家才好看嘛
你的BeginDate有值否???
还有有值的话,格式是否正确??
model.BeginDate在实体类中BeginDate是神马类型,数据库中是DateTime类型的,检查下实体类中的类型
还有就是什么单引号,逗号字符啥的仔细检查一下
strSql.Append("insert into SurveyTaskInfo (");
strSql.Append("SurveyTaskName,BeginDate,PlanEndDate,EndDate,Re,ProjectID,ProjectProfessionalID,DirectorID)");
strSql.Append(" values(");
strSql.Append(model.SurveyTaskName + ",'" + model.BeginDate + "','" + model.PlanEndDate + " ','" + model.EndDate + "','" + model.Re + "'," + model.ProjectID + "," + model.ProjectProfessionalID + "," + model.DirectorID + ")");
2,查看model中的BeginDate 字段类型