S
simon
One simple examle:
I have SP returnArticle with parameter @artId:
CREATE PROCEDURE returnArticle
@artId as int
AS
select artText from Articles where artId=@artId
I was using connection object in asp like this:
sql="exec returnArticle 1"
articleText=conn.execute(sql).fields.item(0).Value
Very simple, I get text with one row of code
Is there something similar in asp.net
I don't like command object, there is to many rows of code, with parameters
add and similar
What is the best way here in aspNet?
I tried something with sqlDataAdapter but doesnt work if I have parameter in
procedure
Thank you for your answers,
Simon
I have SP returnArticle with parameter @artId:
CREATE PROCEDURE returnArticle
@artId as int
AS
select artText from Articles where artId=@artId
I was using connection object in asp like this:
sql="exec returnArticle 1"
articleText=conn.execute(sql).fields.item(0).Value
Very simple, I get text with one row of code
Is there something similar in asp.net
I don't like command object, there is to many rows of code, with parameters
add and similar
What is the best way here in aspNet?
I tried something with sqlDataAdapter but doesnt work if I have parameter in
procedure
Thank you for your answers,
Simon