ASP.NET 2.0 - Web Server Controls 1

[AGus01]

Hi,

I am web designer who is now been forced to create a simple ASP.NET 2.0 event booking application (I have some ASP/PHP/SQL Server/SQL knowledge but tend to make a mess of server side code).

This app will have an administrator (back end) interface (web or windows based internal to my office) and an applicant (front end) web interface.

1) An Administrator internal to my department will be able to create a course/event through the admin interface. Details will be very simple "event name", "course name", "start date/time" "end date/time" "description" etc...

2) once saved will then allow people on the website to apply for this event/course. Filling in various details depending on the person type they specify e.g business man will fill different details compared to student etc...

3) once person applied for a course there details will be viewable from the admin end under the particular event. it will then be possible to email and mark attended/not attended etc.... applicants.

4) It will also be necessary from the admin end to be able to search/filter through all applicant data. View details in Excel possibly pivot charts.

As I am not a programmer and for me C# might as well be in Chinese.
Is it possible to create all this functionality using the .NET 2.0 Web Server Data Controls?

Does anyone have experience doing this?

thanks for your time.

Angus

 

[NoCoolHandle]

How does yes, maybe and no sound...

actually most of what you want to do is very easy to pull off without getting into server code.. Customizing functionality may require db functioanalty.. VB from asp works in aspx so chinese isn't necessary..

step 1.
Create your database tables
step 2.
Create a web site in Visual studio (hopefully 2008 as it is better)
Step 3
Add a new "webform"
step 4.
Add a datagrid (data section of your toolbar)
Step 5
Go TO "Design View" - (Bottom of the page)
Step 6
Click your grid and you will see a little arrow at the top right corner.
Step 7
CLick the little arrow
Step 8 In the "Select Datasource" combo box select "New Datasource"

Follow the wizard till you get to the sql query..
when you get to the screen that asks for a "Specify columns from table or view"

select "Custom SQL statement or Stored Proceedure" - or something like that.

step 9. Add your select statement (use the gui to build the query if you want.)
step 10. IN the UPDATE/INSERT/DELETE tabs add the appropriate UPdate/INsert and Delte statements

If your sql statement was "Select FirstName,EmployeeID from employees"
to update Employees your update statement takes the column name and adds a "@" to the front of it to make a parameter that uses grid data for the update.

e.g. Update Employees set FirstName=@FirstName where EmployeeId=@EmployeeID

do the same with your instet and delete statements.

Click Finish..

Step 11.
CLick the arrow on the grid again and enable "insert/UPdate and Delete"

YOu should be done.

NOte.. I have had issues with insert, often this causes me to go to server code.. but the basics are there.


Rob