SqlDataSource

  • Thread starter Thread starter Arne Garvander
  • Start date Start date
A

Arne Garvander

I have a problem configuring a SqlDataSource.
1. I click Specify SQL Statement or stored procedure
2. When I try to select a stored procedure that dropdown is greyed out. The
radio button for stored procedure is greyed out.
I use VS studio 2008 sp1.
What am I doing wrong?
 
Before that, you must specify things about your database, such as the
connection string. Are you certain all that is correct?
 
Yes, the connection strings is there because dynamic sql works. Stored proc
is greyed out.


--
Arne Garvander
(I program VB.Net for fun and C# to get paid.)


Jonathan Wood said:
Before that, you must specify things about your database, such as the
connection string. Are you certain all that is correct?
 
Can you run the procedure yourself to verify it functions and can be called
by your SQL login?

Arne Garvander said:
Yes, the connection strings is there because dynamic sql works. Stored
proc
is greyed out.
 
None of my stored procs had the correct security. That is why I had a problem.
I granted execute privileges to one stored proc and now my SQLDataSource
wizard is helpful again.
 
Back
Top