database function

[manoj bhatt]

i have create a function in pubs data base create function show(@temp varchar(11)) returns table return(select *from author where au_id=@temp) now i wants to access this function from aspx page using c# please give me an applicable answer so that i will satisfied thanks regards (manoj bhatt)

[SilimSayo]

String inputValue;
String sqlText;
SqlConnection connection;
SqlCommand command;
SqlDataReader dataReader;

inputValue="123ABC";
sqlText="SELECT dbo.show(" + inputValue +")";
connection=new SqlConnection(" ...whatever your connection stuff is ");

try
{
connection.Open();
command=new SqlCommand(sqlText,connection);
SqlDataReader dataReader = command.ExecuteReader();

if(dataReader != null)
{
while(dataReader.Read())
{
--get values from dataReader
}
}
}
catch
{

}

[Peter_in_2780]

oooh! shiny! SQL injection, here we come!!!!

Software rusts. Simon Stephenson, ca 1994.

[SilimSayo]

I know.... personally I would have preferred a stored procedure.