Creating an editable gridview in ASP.NET from scratch
Posted on 2007-10-10
I have asked this same question in different ways, and I just can't seem to get the answer i'm looking for, so I've decided to ask again, but in the most distilled plain-vanilla way I can possibly think of. I am desperate for help here.
I am using ASP.NET with a VB.NET backend. **Please** give me help in vb.net if possible, or if it has to be in C# give me some guidance as to how to convert it.
What I want to do should be relatively commonplace (which is why I'm so confused as to how no one has been able to help me). I've never done this before, so while I don't like the thought of others doing my work for me, I need BASIC INSTRUCTIONS here.
1) I want to create a gridview. This gridview is populated by a stored procedure, which selects off a table and joins another table to it.
2) This gridview needs to be editable, so that rows can be edited in real time, one row at a time.
3) When the row is updated, it needs to fire an update stored procedure.
That's it, end of line. The only caveats are, NO INLINE SQL. The stored procs are already written and ready to accept parameters. I don't care if I use a sqldatasource, a sqldataadapter, some databind function (and ive had all these suggested to me, and then thats the end of the help I get), I'll do it in whatever way is easiest! Please help!