Select, Insert, Update and Delete Example

[Miked811]

Hi,

I'm new to ASP.NET and I would like to ask if someone can provide me a very simple code to manipulate data using the SQL Commands in the above subject. To keep it simple, say, just 1 textbox and 5 buttons (Next, Prev, Insert, Update and Delete). I'd like to see code of an unbound text box and not bound data.

I came from ASP Classic background and I think it is entirely different in ASP.NET to do the steps for the 5 actions.

Can I code everything in the code-behind rather than in the ASP.NET side? I have no clue where is the best place to code them. I guess I'd also like to know what is the best way or are the best practices in programming the above subject.

Once I have the code, I can study and do it myself and hopefully move on to more complex application.

Please kindly help.

Thanks in advance

Mike

 

[jbenson001]

There are many examples on line. Do no mix your code with the HTML like classic ASP. Put any code in your code behind file, classes, etc.

 

[jmeckley]

one thing to know about asp.net. it's just a pipeline to service http requests. on top of asp.net there are frameworks to render html. webforms is the "default". when asp.net was first introduced it was the only choice and now asp.net and webforms are interchanged, but they really are 2 different things.

besides webforms you have the option of an MVC framework like MS MVC and Monorail. I prefer the MVC methodology to control page flow over webforms. each has it's pros and cons but it's worth checking out both.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190
faq732-7259