各位大哥,幫幫忙吧,俺現在是沒有一分的窮光蛋,分以後一定補上.
你們行行好,幫俺看以下這段代碼.其他都沒有問題,就是在將stringgrid的值賦給數據庫表單joy的時候,說'violation of primary KEY constraint'PK_JOY',can't insert duplicate key in object 'JOY'',能告訴是深麼原因嗎
procedure TForm1.Button1Click(Sender: TObject);
var i:integer;
s:string;
begin
opendialog1.InitialDir:=ExtractFileDir(paramstr(0));
opendialog1.Execute;
Try
ExcelApplication1.Connect;
Except
MessageDlg('Excel may not be installed',mtError, [mbOk], 0);
Abort;
End;
ExcelApplication1.Visible[0]:=True;
ExcelApplication1.Caption:='Excel Application';
try
excelapplication1.Workbooks.Open(opendialog1.FileName,
null,null,null,null,null,null,null,null,null,null,null,null,0);except
begin
ExcelApplication1.Disconnect;
ExcelApplication1.Quit;showmessage('???EXCEL?!');
exit;
end;
end;
ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks[1]);ExcelWorksheet1.ConnectTo(ExcelWorkbook1.Worksheets[1] as _Worksheet);
for i:=1 to advstringgrid1.rowCount-1 do
begin
adoQuery1.Close;
adoQuery1.sql.Clear;
S := 'insert into joy values(''' + advstringgrid1.Cells[1,i] + ''',''' + advstringgrid1.Cells[2,i] + ''',''' + advstringgrid1.Cells[3,i] + ''')';
adoQuery1.SQL.Add(S);
adoQuery1.ExecSQL;end; end;end.
你們行行好,幫俺看以下這段代碼.其他都沒有問題,就是在將stringgrid的值賦給數據庫表單joy的時候,說'violation of primary KEY constraint'PK_JOY',can't insert duplicate key in object 'JOY'',能告訴是深麼原因嗎
procedure TForm1.Button1Click(Sender: TObject);
var i:integer;
s:string;
begin
opendialog1.InitialDir:=ExtractFileDir(paramstr(0));
opendialog1.Execute;
Try
ExcelApplication1.Connect;
Except
MessageDlg('Excel may not be installed',mtError, [mbOk], 0);
Abort;
End;
ExcelApplication1.Visible[0]:=True;
ExcelApplication1.Caption:='Excel Application';
try
excelapplication1.Workbooks.Open(opendialog1.FileName,
null,null,null,null,null,null,null,null,null,null,null,null,0);except
begin
ExcelApplication1.Disconnect;
ExcelApplication1.Quit;showmessage('???EXCEL?!');
exit;
end;
end;
ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks[1]);ExcelWorksheet1.ConnectTo(ExcelWorkbook1.Worksheets[1] as _Worksheet);
for i:=1 to advstringgrid1.rowCount-1 do
begin
adoQuery1.Close;
adoQuery1.sql.Clear;
S := 'insert into joy values(''' + advstringgrid1.Cells[1,i] + ''',''' + advstringgrid1.Cells[2,i] + ''',''' + advstringgrid1.Cells[3,i] + ''')';
adoQuery1.SQL.Add(S);
adoQuery1.ExecSQL;end; end;end.
解决方案 »
- 求:ACCSEE数据库的压缩备份与解压恢复代码,在线。。。。。。
- 基本问题:DELPHI程序发布要设置什么吗?
- 如何删除DBGRID中的当前记录(用ADO连接的),请给代码示例,谢谢
- 读取ini文件小问题----送分
- 用Delphi编写CGI程序行吗?
- D7 里怎么没有CORBA Object创建向导?
- 要让Qreport不分页,应该如何做
- 怎样用ADO与数据仓库(Decision Cube)进行连接,或DBChart、Chart进行连接?
- 如何实现多条带格式的数据库记录按其格式显示在一个richedit中?
- 用Delphi 6写的程序用什么发布,我没有installshield for delphi6,哪有下载?
- dblistbox中的条目无法被选中?
- ado的小问题,高手们进来帮帮忙,谢谢,【在线】
沒分理都沒人理,失望中..................