Milan Lamichhane
Guest
|
 Posted: Tue Aug 03, 2004 8:38 am Post subject: Re: How to access Store Procedures from Delphi 8 Architect |
 |
|
Try this. Pls remember, this code is not tested yet. It will give you
rough idea how to use sproc. in Delphi 8.
procedure TSomeObject.AddUser(UserName,Email: String);
var
objConn : SqlConnection;
objComm : SqlCommand;
paramUserName, paramEmail : SqlParameter;
begin
//replace getConnectionString with your connection string
objConn := SqlConnection.Create(getConnectionString);
objConn.Open;
objComm := SqlCommand.Create('Stored_Proc_Name',objConn);
objComm.CommandType := CommandType.StoredProcedure;
paramUserName:=
SqlParameter.Create('@pUsername',SqlDBType.VarChar,100);
paramUserName.Value := TObject(UserName);
objComm.Parameters.Add(paramUserName);
paramEmail := SqlParameter.Create('@pEmail',SqlDBType.VarChar,100);
paramEmail.Value := TObject(Email);
objComm.Parameters.Add(paramEmail);
Result := objComm.ExecuteNonQuery;
end;
mILAN
Oliver Reitemeier wrote:
| Quote: | Hi,
i am a Newbie and need help.
I have a Stored Proc on my MS Sql 2000 Server.
The Store Proc should insert a User into a User Database. The Parameters are
pUsername and pEmail.
What i have to to use this Store Proc from my Delphi 8 Architect Version
where i have an ASP .Net Site.
Thanks a lot!!!!!!
Oliver
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
