Hi - can anyone help,

Ive tried this example from microsoft quickstart tutorial and copied the code exactly (changing variables, db where necessary):

http://samples.gotdotnet.com/quickst.../datagrid1.src

When I build it in VisualStudio.net - there are no build errors and when it is run in a browser I can only see the title: 'Simple Select to a DataGrid Control', with no datagrid. Because there are no visible errors, im not sure what is happening - please help! why cant i see the datagrid with the data from my sql database???

Thanks-
rizp

Change this line:

AutoEventWireup="false"

to

AutoEventWireup="true"

in your Page Directive.

J

Hi -

This worked i think, although its uncovered more error that i cant work out for the life of me! the error that i get is:

 'SQL Server does not exist or access denied', on line 13 MyConnection.Open(). The SQL Server is open, i checked several times and the server is working fine too. I also have access rights since im the admin of the system. Any ideas anyone???

By the way, what is AutoEventWireup and why did you set it to true? Does this need to be the case all the time?

thanks - rizp

Did you change this line:

MyConnection = New SqlConnection("server=(local)\NetSDK;database=pubs ;Trusted_Connection=yes")

to this:

MyConnection = New SqlConnection("server=(local);database=pubs;Truste d_Connection=yes")

--------------------------------------

No, you don't always have to use it. I almost never use it. I put all of my code in a codebehind file. Here is an article from Microsoft on AutoEventWireup:

http://support.microsoft.com/default...en-us%3B317690

J

thanks for that -
although it now states: Login failed for user 'rizp\ASPNET'.

Error is still at Connection.Open() and the exception details are: System.Data.SqlClient.SqlException: Login failed (as above)

Why would this happen if im using windows integrated security - i thought that SQL server simply uses those login details instead??

Any more ideas??

rizp

I believe there are at least a couple ways of doing this. You can add the ASPNET account to the database and give it access.

Or you can modify the web.config file and set authentication mode to windows and identity impersonate to true by adding:

<authentication mode="windows" />
<identity impersonate="true" />

You will probably also want to add:

<deny users="?" />

under the "authorization" section.

On a side note, this particular topic has been covered numerous times and I am sure you could find a full white paper on this very subject if you Googled...

J

hi -

this does not make any differnece (for the second solution) to the error message received. however, can you expand a bit more on how i can go about the first solution please??

rizp

Hi

It sok, i finally got it - i found the answer here:

http://aspnet101.com/aspnet101/tutorials.aspx?id=23

i had to congigure IIS properties.

Thanks just the same-
rizp

Glad I could help.

J