看我写的 AccessDataSource ad = new AccessDataSource();
ad.DataFile = "~/App_Data/TrainingDB.mdb";
StringBuilder sQueryString = new StringBuilder();
//DB Update Code
ad.SelectCommand = "select * from TaskTable";
sQueryString.Append(" Update TaskTable ");
sQueryString.Append(" set TaskDescription ");
sQueryString.Append(" = @TaskDescription ");
sQueryString.Append(" where TaskID=@TaskID ");
//by the pramary key @TaskID to update the correct row @TaskDescription
ad.UpdateParameters.Add("@TaskDescription", showStruct.TaskDescription);
ad.UpdateParameters.Add("@TaskID", showStruct.TaskID);
ad.UpdateCommand = sQueryString.ToString();
ad.Update();
不知道是不是你要的
ad.DataFile = "~/App_Data/TrainingDB.mdb";
StringBuilder sQueryString = new StringBuilder();
//DB Update Code
ad.SelectCommand = "select * from TaskTable";
sQueryString.Append(" Update TaskTable ");
sQueryString.Append(" set TaskDescription ");
sQueryString.Append(" = @TaskDescription ");
sQueryString.Append(" where TaskID=@TaskID ");
//by the pramary key @TaskID to update the correct row @TaskDescription
ad.UpdateParameters.Add("@TaskDescription", showStruct.TaskDescription);
ad.UpdateParameters.Add("@TaskID", showStruct.TaskID);
ad.UpdateCommand = sQueryString.ToString();
ad.Update();
不知道是不是你要的
"Data Source=" + Application.StartupPath.ToString() + "\\GFNL.mdb;" +
"Persist Security Info=False";
OleDbConnection conn = new OleDbConnection(strConn);
string str ="select FRecord,sum(IIF(FCode='01',FResult,null)) as 身高,"+
"sum(IIF(FCode='02',FResult,null)) as 体重,"+
"sum(IIF(FCode='17',FResult,null)) as 背力 "+
"from GDFResult where FRead=0 group by FRecord";
OleDbDataAdapter sda = new OleDbDataAdapter(str, strConn);
DataSet ds = new DataSet();
sda.Fill(ds,"test");