用的是access数据库
用的oledb
更新就的是这个
this.oleDbUpdateCommand1.CommandText = "UPDATE fkey SET fname = @fname WHERE (fid = @Original_fid)";
this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("fcheck", System.Data.OleDb.OleDbType.VarWChar, 50, "fcheck"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("fid", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "fid", System.Data.DataRowVersion.Current, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("fname", System.Data.OleDb.OleDbType.VarWChar, 50, "fname"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_fcheck", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "fcheck", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_fcheck1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "fcheck", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_fname", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "fname", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_fname1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "fname", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("@Original_fid", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "fid", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("@fname", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, true, ((System.Byte)(0)), ((System.Byte)(0)), "fname", System.Data.DataRowVersion.Default,null));private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.oleDbDataAdapter1.UpdateCommand.Parameters["@Original_fid"].Value = (int)this.DataGrid1.DataKeys[e.Item.ItemIndex];
this.oleDbDataAdapter1.UpdateCommand.Parameters["@fname"].Value = ((TextBox)e.Item.Cells[1].Controls[0]).Text;
this.oleDbDataAdapter1.UpdateCommand.Connection.Open();
this.oleDbDataAdapter1.UpdateCommand.ExecuteNonQuery();
this.oleDbDataAdapter1.UpdateCommand.Connection.Close();
this.DataGrid1.EditItemIndex = -1;
this.BindGrid();
}
是不是这个this.oleDbUpdateCommand1.Parameters.Add(………………);
这个里面的问题啊?
用的oledb
更新就的是这个
this.oleDbUpdateCommand1.CommandText = "UPDATE fkey SET fname = @fname WHERE (fid = @Original_fid)";
this.oleDbUpdateCommand1.Connection = this.oleDbConnection1;
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("fcheck", System.Data.OleDb.OleDbType.VarWChar, 50, "fcheck"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("fid", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "fid", System.Data.DataRowVersion.Current, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("fname", System.Data.OleDb.OleDbType.VarWChar, 50, "fname"));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_fcheck", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "fcheck", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_fcheck1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "fcheck", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_fname", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "fname", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_fname1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "fname", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("@Original_fid", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "fid", System.Data.DataRowVersion.Original, null));
this.oleDbUpdateCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("@fname", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, true, ((System.Byte)(0)), ((System.Byte)(0)), "fname", System.Data.DataRowVersion.Default,null));private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.oleDbDataAdapter1.UpdateCommand.Parameters["@Original_fid"].Value = (int)this.DataGrid1.DataKeys[e.Item.ItemIndex];
this.oleDbDataAdapter1.UpdateCommand.Parameters["@fname"].Value = ((TextBox)e.Item.Cells[1].Controls[0]).Text;
this.oleDbDataAdapter1.UpdateCommand.Connection.Open();
this.oleDbDataAdapter1.UpdateCommand.ExecuteNonQuery();
this.oleDbDataAdapter1.UpdateCommand.Connection.Close();
this.DataGrid1.EditItemIndex = -1;
this.BindGrid();
}
是不是这个this.oleDbUpdateCommand1.Parameters.Add(………………);
这个里面的问题啊?
解决方案 »
- 使用过C#和JAVA开发过远程系统的高手请解答一下
- 用C#创建window service服务遇到的问题
- 不好意思,问一下大家啊 谢谢啊
- GetPrivateProfileString字符串缓冲区大小设置问题
- datagrid超链接列问题,在线等!(马上给分)
- 在线急等!DateTime.Now.ToString问题!!!!谢谢!
- xml填充DataSet的问题!
- 关于 C#中读EXECL的CELL 中 数据!
- c#做bho插件怎样获取js跳转的值
- 求救!--c#怎么打开ascii的文本文件?(在线等候)
- 如何更好的理解C#中的“方法”?
- 怎样获得窗体改变大小事件(SizeChanged)之前的窗体大小?
this.oleDbUpdateCommand1.CommandText = "UPDATE fkey SET fname = @fname WHERE (fid = @Original_fid)";就要改成:
this.oleDbUpdateCommand1.CommandText = "UPDATE fkey SET fname = ? WHERE (fid = ?)";即在SQL语句中使用?来实现,并且添加 参数对象的顺序必须直接对应于该参数的问号占位符在SQL文本中的位置。