StrToInt(Edit1.Text); if (Trim(Edit1.Text) = '') then begin Application.MessageBox('内容不能为空', '提示', MB_ICONINFORMATION); Exit; end; TADOConnection.Execute('Insert into table1(field1, field2, field3) '#13#10 + 'values(' + edit1.text + ',' + Edit2.Text + ',' + Edit3.Text + ')');你是这个意思吗?
1、StrToInt(Edit1.Text)//整型,StrToFloat(Edit1.text)//浮点型 2、procedure TForm1.Edit1Exit(Sender: TObject); begin if Trim(TEdit(Sender).Text)='' then begin TEdit(Sender).SetFocus; Application.MessageBox('请输入数字!','提示',MB_OK); end; end; 3、 procedure TForm1.Button1Click(Sender: TObject); var InsertSQL:string; begin InsertSQL:='Insert into TableName (Field1,Field2,Field3) values( ' +#39+Edit1.Text+#39+', ' +#39+Edit2.Text+#39+', ' +#39+Edit3.Text+#39+')'; ADOQuery1.Close; ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add(InsertSQL); ADOQuery1.ExecSQL;
edit onkeypress begin if not (key in ['0'..'9',#8,#13]) then key:=#0; end; edit onexit begin if length(edit.text)=0 then edit.setfocus; end;adoconnection+adoquery
1、StrToInt(Edit1.Text)//整型,StrToFloat(Edit1.text)//浮点型 2、procedure TForm1.Edit1Exit(Sender: TObject); begin if Trim(TEdit(Sender).Text)='' then begin TEdit(Sender).SetFocus; Application.MessageBox('请输入数字!','提示',MB_OK); end; end; 3、 procedure TForm1.Button1Click(Sender: TObject); var InsertSQL:string; begin InsertSQL:='Insert into TableName (Field1,Field2,Field3) values( ' +#39+Edit1.Text+#39+', ' +#39+Edit2.Text+#39+', ' +#39+Edit3.Text+#39+')'; ADOQuery1.Close; ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add(InsertSQL); ADOQuery1.ExecSQL;
var InsertSQL:string; begin InsertSQL:='Insert into TableName (Field1,Field2,Field3) values( ' +Edit1.Text+', ' +Edit2.Text+', ' +Edit3.Text+')'; ADOQuery1.Close; ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add(InsertSQL); ADOQuery1.ExecSQL; 试试! 把Edit1.Text保存到数据库中就是整形
1、将字符转化成字符
2、设置其内容不能为空
3、将3个TEdit里面的内容存入Access数据库中(可以调用sql语句实现)
先谢谢大家了,我要源码。
if (Trim(Edit1.Text) = '') then
begin
Application.MessageBox('内容不能为空', '提示', MB_ICONINFORMATION);
Exit;
end;
TADOConnection.Execute('Insert into table1(field1, field2, field3) '#13#10 +
'values(' + edit1.text + ',' + Edit2.Text + ',' + Edit3.Text + ')');
if (Trim(Edit1.Text) = '') then
begin
Application.MessageBox('内容不能为空', '提示', MB_ICONINFORMATION);
Exit;
end;
TADOConnection.Execute('Insert into table1(field1, field2, field3) '#13#10 +
'values(' + edit1.text + ',' + Edit2.Text + ',' + Edit3.Text + ')');你是这个意思吗?
2、procedure TForm1.Edit1Exit(Sender: TObject);
begin
if Trim(TEdit(Sender).Text)='' then
begin
TEdit(Sender).SetFocus;
Application.MessageBox('请输入数字!','提示',MB_OK);
end;
end;
3、
procedure TForm1.Button1Click(Sender: TObject);
var
InsertSQL:string;
begin
InsertSQL:='Insert into TableName (Field1,Field2,Field3) values( '
+#39+Edit1.Text+#39+', '
+#39+Edit2.Text+#39+', '
+#39+Edit3.Text+#39+')';
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add(InsertSQL);
ADOQuery1.ExecSQL;
当我要讲这些已经转化好的整型数据弄好后,怎么具体将数据存入数据库中(当然数据库重要的是整型数据)
procedure TForm1.Button1Click(Sender: TObject);
var
InsertSQL:string;
begin
InsertSQL:='Insert into TableName (Field1,Field2,Field3) values( '
+Edit1.Text+', '
+Edit2.Text+', '
+Edit3.Text+')';
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add(InsertSQL);
ADOQuery1.ExecSQL;
当我要将这些已经转化好的整型数据弄好后,怎么将它们存入数据库中(当然数据库重要的是整型数据),上面的程序存到数据库中之后是字符型数据吧?
begin
if not (key in ['0'..'9',#8,#13]) then
key:=#0;
end;
edit onexit
begin
if length(edit.text)=0 then
edit.setfocus;
end;adoconnection+adoquery
如:好像不能:a:=integer;
a=Strtoint(b.text);
我该怎么实现将b.text转化的整形数据存入数据库中?
2、procedure TForm1.Edit1Exit(Sender: TObject);
begin
if Trim(TEdit(Sender).Text)='' then
begin
TEdit(Sender).SetFocus;
Application.MessageBox('请输入数字!','提示',MB_OK);
end;
end;
3、
procedure TForm1.Button1Click(Sender: TObject);
var
InsertSQL:string;
begin
InsertSQL:='Insert into TableName (Field1,Field2,Field3) values( '
+#39+Edit1.Text+#39+', '
+#39+Edit2.Text+#39+', '
+#39+Edit3.Text+#39+')';
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add(InsertSQL);
ADOQuery1.ExecSQL;
InsertSQL:string;
begin
InsertSQL:='Insert into TableName (Field1,Field2,Field3) values( '
+Edit1.Text+', '
+Edit2.Text+', '
+Edit3.Text+')';
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add(InsertSQL);
ADOQuery1.ExecSQL;
试试!
把Edit1.Text保存到数据库中就是整形
with query1 do
append;
...
..
..
post;
adoquery.active:=true;