Conceptually, I understand what needs to be happen, but technically,
I don?t really know how to do it. Here
is my Select statement:
SELECT tblEvents.Event, tblPubs.Name, tblPubs.Address,
tblPubs.City, tblPubs.State, tblPubs.OnDate FROM tblPubs INNER JOIN tblEvents
ON tblPubs.NeighborhoodID = tblEvents.NeighborhoodID WHERE (tblEvents.Event =
@Event)
That works just fine.
Items in my GridView are updated based on what is selected from a
DropDownList. That part works fine. Now, I am trying to add a few features to
allow a particular user (who logs into his account through a login form) to
Insert, Update, and Delete records. That?s
what these controls are for, right. The
user can do this completely through a web browser, when the ASP.NET
project is on the server, as opposed to localhost, right
My question is, how would I design the SQL to allow the user
to Insert (and ad ...
Go to the complete details ...