Some SQL and ASP.NET C# assistance

[WiseNewbie]

Hi,

I come from an ASP background and only started playing with ASP.NET recently but i cant workout how to use the relavent DataSet and SqlAdapter classes properly.

Heres what i need to do:

- Connect to a SQL Database *OK*
- Look through a table to see if a certain number is already there *NOT_COMPLETE*
- If its not then insert a new row with a fresh set of information
- if it is there then do some other work

Now i can connect to the SQL Database but I'm not sure what to do thereafter. I havnt got a long time to read tutorials and learn it as this needs to be sent tomorrow hence why i'm asking for your assistance.

Most tutorials i see are based around the DataGrid which is not what i need, I simply need to validate and insert if not found and return a plain HTML page, no fancy stuff. But if you anyone knows any good non-datagrid based tutorials on getting started in SQL programming with ASP.NET then please post a link

 

[crazyboybert]

Hi Wise

Here's a link to the Micosoft ASP.NET websites basic data access tutorial. If your looking for a good tutorial for most everyday tasks with asp.net this is usually a good place to start.

http://www.asp.net/tutorials/quickstart.aspx

Hopefully this should enable you to get going, if you get stuck post again and i'm sure somebody here will be able to help

Rob

Go placidly amidst the noise and haste, and remember what peace there may be in silence - Erhmann 1927