I have the following:

UpdateParameters

asp < Parameter Name="PA_id" Type="String" />

... more like this for each field in the table and then the ending

asp < Parameter Name"Student_id" Type"Int32" />

No other parameters are...

Also,

I only have one primary key Student_id. As required, it is included in the select statement. It does not show (in VWD) as Primary Key but in SQL Server Mgmt...

Trying this again since my examples did not get into my last post. This time I am omitting the symbols that begin and end these parameters.

I have the following:

UpdateParameters

asp:Parameter Name="PA_id"...

Matt,

Thanks.

The DataKeyName is set to the primary key which is "Student_id"

After reviewing the control (GridView1) in source mode I do find something called "UpdateParameters" In that section there are only...

Please explain how to do these two suggestions.

Where is it that I should look to check null-ability of the datasource parameter?

And where for the DataKeyName information?

Thanks,

i have looked and do not have this program. (Profiler) where can I get it?

Thanks,

I changed the database name from test to what I want to be the correct name. Now queries from the web indicate:

"Cannot open database "New_name" requested by the login. The...

THANK YOU.

You were SO correct.

Matt,

I have found the .asp stuff thanks.

Can you tell me what would cause following error that I get when i attempt to add a second record using SQL Insert...

Matt,

Where do I locate these controls you mention. I am using Visual Studio.

Thanks,

HN

Would someone suggest what asp.net or php code would allow me to view this record on a web page? My ultimate desire is to provide access to this and other...

Thanks all for your input and corrections.

I confess that the concepts mentioned (Scope_Identity and batchID) are at this time beyond my comprehension. Would you explain what these functions do and...

Thanks.

Where do I find ASP.NET 2005, and simply go with the built-in user controls. I have Visual Studio 2005. But I have only used it so far to build my...

So this should work?

USE work_test1

INSERT INTO Student_Main

(ID,First_Name, Last_Name, Current_Grade, Current_School)

VALUES (NEWID(),'Herbert','Jones',10,'Penn Hills')

Also, aside from error checking, I was asking a more basic question. Should I now be able...

Thank you so much. Your correction worked perfectly.

I have another question:

I have an ID unique identifier field which is the first field in the table.

ID(PK,uniqueidentifier, not null)

I am not listing...