frankie lo
|
Posted: 11/23/2006, 7:40 AM |
|
Hi all,
do you know, please.....
|
|
|
peterr
Posts: 5971
|
Posted: 11/23/2006, 9:02 AM |
|
Yes, you can use Stored Procedures,
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
frankie lo
|
Posted: 11/23/2006, 7:40 PM |
|
I know how to call sp by .net.
But
1. ) Do you know how to call in codechage in easy way? any example?
2.) What is the default connection object, CN ?
Please any help.....
"peterr" <peterr@forum.codecharge> wrote in message
news:84565d415f1c45@news.codecharge.com...
> Yes, you can use Stored Procedures,
> _________________
> Peter R.
> YesSoftware Forums Moderator
> For product support please visit http://support.yessoftware.com
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
frankie lo
|
Posted: 11/23/2006, 7:44 PM |
|
I just want call a stored procedure to run a append query
Many Thanks.......
"frankie lo" <frankiecblo@hotmail.com> wrote in message
news:ek5pk9$r51$1@news.codecharge.com...
>I know how to call sp by .net.
> But
> 1. ) Do you know how to call in codechage in easy way? any example?
> 2.) What is the default connection object, CN ?
>
> Please any help.....
>
> "peterr" <peterr@forum.codecharge> wrote in message
>news:84565d415f1c45@news.codecharge.com...
>> Yes, you can use Stored Procedures,
>> _________________
>> Peter R.
>> YesSoftware Forums Moderator
>> For product support please visit http://support.yessoftware.com
>> ---------------------------------------
>> Sent from YesSoftware forum
>> http://forums.codecharge.com/
>>
>
>
|
|
|
Stan
|
Posted: 11/24/2006, 7:18 AM |
|
You can use the following code
Dim command=new SpCommand("name",Settings.<ConnectionName>DataAccessObject)
command.ExecuteNonQuery
Note that you should substitute a correct name of your CCS connection instead of <ConnectionName>
Stan
|
|
|
frankie lo
|
Posted: 11/24/2006, 11:09 PM |
|
Hi Stan,
it works fine. Thanks for your advice ...
"Stan" <Stan@forum.codecharge> wrote in message
news:845670d2938b6b@news.codecharge.com...
> You can use the following code
>
>
> Dim command=new
> SpCommand("name",Settings.<ConnectionName>DataAccessObject)
> command.ExecuteNonQuery
>
>
> Note that you should substitute a correct name of your CCS connection
> instead
> of <ConnectionName>
>
> Stan
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|