其他信息: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.
解决方案 »
- .net 中,gridview 中,有一个文本框,我想让它的值输入完后,后面的值发生变化
- 一个水晶报表的问题
- 100分求高手解决ClickOne部署问题 : 部署和应用程序没有匹配的安全区域, 送美女QQ!
- 改进的Hough circle detect 方法
- 关于ARM 板子WINCE系统的串口编程问题....大家来看看.
- 关于加密狗,safenet
- 业务逻辑的数据访问类大家一般是怎么设计的
- 请教一下,C#程序里面的 "0x7fffffff" 是什么东西,它代表什么?
- wpf 资源图片转换为byte[]
- 能否将一个窗体完全陷入panel控件里?
- using System 为什么一用它就出错???
- 如何把创建的资源文件和aspx页面关联起来
检查一下SqlDataAdapter的SelectCommand,
或者把代码贴出来.
{
myDBConn = new DBConncetion();
SQL.SqlConnection dbConn = myDBConn.DBConnect();
string attDate = this.attendDate.Year.ToString() + "-" + this.attendDate.Month.ToString() + "-" + this.attendDate.Day.ToString();
string sqlStr = string.Format("SELECT employee_quantity as 编制人数,att_emp_quantity as 出勤人数," +
"worktime as 上班小时,addtime as 加班小时,servicetime as 支援小时,dept_workedtime as 小组工时 FROM Attendance_js " +
"WHERE dept_id = '{0}' AND convert(char(10),created_time,120) = '{1}'",
this.deptID,attDate);
myComm = new SQL.SqlCommand(sqlStr,dbConn);
SQL.SqlDataAdapter dbAdapter;
dbAdapter = new System.Data.SqlClient.SqlDataAdapter(myComm);
ds = new SD.DataSet(); dbConn.Open();
dbAdapter.Fill(ds);
dbConn.Close();
} public void UpdateAttend()
{
SQL.SqlConnection dbConn = null;
SD.DataSet ds = null;
myDBConn = new DBConncetion();
dbConn = myDBConn.DBConnect();
string attDate = this.attendDate.Year.ToString() + "-" + this.attendDate.Month.ToString() + "-" + this.attendDate.Day.ToString();
string sqlStr = string.Format("SELECT employee_quantity as 编制人数,att_emp_quantity as 出勤人数," +
"worktime as 上班小时,addtime as 加班小时,servicetime as 支援小时,dept_workedtime as 小组工时 FROM Attendance_js " +
"WHERE dept_id = '{0}' AND convert(char(10),created_time,120) = '{1}'",
this.deptID,attDate);
myComm = new SQL.SqlCommand(sqlStr,dbConn);
SQL.SqlDataAdapter dbAdapter;
dbAdapter = new System.Data.SqlClient.SqlDataAdapter(myComm); SQL.SqlCommandBuilder dbCmdBuilder;
dbCmdBuilder = new SQL.SqlCommandBuilder(dbAdapter); ds = (SD.DataSet) this.dataGrid1.DataSource; dbConn.Open();
dbAdapter.Update(ds);
dbConn.Close(); SWF.MessageBox.Show("Changes saved!");
}