Update更新语句有关问题，求高手

2012-03-14

Update更新语句问题，求高手，在线等以下是我插入时的原码，现在要做修改了，不知道这个语句应该怎么写数据库

Update更新语句问题，求高手，在线等
以下是我插入时的原码，现在要做修改了，不知道这个语句应该怎么写
数据库中满足更新条件的一次只有12条记录，要全部更新，但是12条记录中有一个字段的值都是不同的
希望大家能明白我的意图如果有不明确的地方见回复，在线等...

C# code

public int Add(Model.FCEngineData model)
{
StringBuilder InsertString = new StringBuilder();
InsertString.Append("insert tbFCEngineData(AircraftFlightRecordID,EngineID,PositionDesc,FCParamterGroupID,ParamterID,ParamterValue)");
InsertString.Append("select " + model.AircraftFlightRecordID + "," + "'" + model.EngineIDleft + "'" + "," + "'" + model.PositionDescleft + "'" + "," + model.FCParamterGroupID + "," + 9 + "," + model.Qygd + " union all ");
InsertString.Append("select " + model.AircraftFlightRecordID + "," + "'" + model.EngineIDleft + "'" + "," + "'" + model.PositionDescleft + "'" + "," + model.FCParamterGroupID + "," + 6 + "," + model.Dqwd + " union all ");
InsertString.Append("select " + model.AircraftFlightRecordID + "," + "'" + model.EngineIDleft + "'" + "," + "'" + model.PositionDescleft + "'" + "," + model.FCParamterGroupID + "," + 5 + "," + model.TemLeft + " union all ");
InsertString.Append("select " + model.AircraftFlightRecordID + "," + "'" + model.EngineIDleft + "'" + "," + "'" + model.PositionDescleft + "'" + "," + model.FCParamterGroupID + "," + 4 + "," + model.RevLeft + " union all ");
InsertString.Append("select " + model.AircraftFlightRecordID + "," + "'" + model.EngineIDleft + "'" + "," + "'" + model.PositionDescleft + "'" + "," + model.FCParamterGroupID + "," + 18 + "," + model.MaxtemLeft + " union all ");
InsertString.Append("select " + model.AircraftFlightRecordID + "," + "'" + model.EngineIDleft + "'" + "," + "'" + model.PositionDescleft + "'" + "," + model.FCParamterGroupID + "," + 17 + "," + model.MaxrevLeft + " union all ");
InsertString.Append("select " + model.AircraftFlightRecordID + "," + "'" + model.EngineIDright + "'" + "," + "'" + model.PositionDescright + "'" + "," + model.FCParamterGroupID + "," + 9 + "," + model.Qygd + " union all ");
InsertString.Append("select " + model.AircraftFlightRecordID + "," + "'" + model.EngineIDright + "'" + "," + "'" + model.PositionDescright + "'" + "," + model.FCParamterGroupID + "," + 6 + "," + model.Dqwd + " union all ");
InsertString.Append("select " + model.AircraftFlightRecordID + "," + "'" + model.EngineIDright + "'" + "," + "'" + model.PositionDescright + "'" + "," + model.FCParamterGroupID + "," + 5 + "," + model.TemRight + " union all ");

InsertString.Append("select " + model.AircraftFlightRecordID + "," + "'" + model.EngineIDright + "'" + "," + "'" + model.PositionDescright + "'" + "," + model.FCParamterGroupID + "," + 4 + "," + model.RevRight + " union all ");
InsertString.Append("select " + model.AircraftFlightRecordID + "," + "'" + model.EngineIDright + "'" + "," + "'" + model.PositionDescright + "'" + "," + model.FCParamterGroupID + "," + 18 + "," + model.MaxtemRight + " union all ");
InsertString.Append("select " + model.AircraftFlightRecordID + "," + "'" + model.EngineIDright + "'" + "," + "'" + model.PositionDescright + "'" + "," + model.FCParamterGroupID + "," + 17 + "," + model.MaxrevRight );

string sql = InsertString.ToString();
int count = DbHelperSQL.ExecuteSql(sql);
return count;

}

[解决办法]
首先要知道你数据表的结构，你能截取个图吗
[解决办法]
顶~~~~~
[解决办法]
e
[解决办法]

帮顶
[解决办法]
不懂i。。。。。。。。。。
[解决办法]

引用楼主 mm6268 的帖子:
以下是我插入时的原码，现在要做修改了，不知道这个语句应该怎么写
数据库中满足更新条件的一次只有12条记录，要全部更新，但是12条记录中有一个字段的值都是不同的
希望大家能明白我的意图如果有不明确的地方见回复，在线等...

[解决办法]
用存储过程好了。。

[解决办法]
这样好像没什么问题
insert dbo.Table_1(a, b, c, d, e)
select '1a',2,3,4,5
union all
select '1b',2,3,4,5
union all
select '1c',2,3,4,5
union all
select '1d',2,3,4,5
union all
select '1f',2,3,4,5
union all
select '1e',2,3,4,5
select * from Table_1

select * from Table_1
1a2345
1b2345
1c2345
1d2345
1f2345
1e2345
数据也插入了...

[解决办法]
写存储过程
[解决办法]
没看懂
[解决办法]
写存储过程
顶楼上的
[解决办法]
建议写存储过程
[解决办法]
up
[解决办法]
存储过程up
[解决办法]
这样的写法不是太好。
最好在数据库中写存储过程
[解决办法]
用非连接~~sqldataAdapter帮我们搞定~~不用写那么多代码的~~~

用非连接~~把数据都加载到页面的dataGridVIew里面

在dataGridVIew 里面随意的修改~~

最后在更新按钮单击事件上写

sqlCommandBuilder b=new sqlCommandBuilder(dataAdapter)
dataAdapter.updata(ds,"...");

就搞定了~~有修改的他会自动修改没有动过的它就不管~~
[解决办法]
增删改~~一起可以搞定
[解决办法]
可以加个insert触发器,处理insert表
[解决办法]
我觉得用存储过程写好。
[解决办法]
学习
[解决办法]
up
[解决办法]
觸發下吧
[解决办法]
用存储过程比较方便。

热点排行