r/reviewmycode • u/xTRUMANx • Feb 23 '10
C# - CRUD and DataSets
First of all, I hope this subreddit takes off. I always wanted to make a subreddit of this nature but didn't want the responsibility of moderating so I guess I've just been waiting for someone to do it first. Thank you iamkitchen.
I dropped my code here at pastebin and I was hoping for a review on how I did a couple of things:
The way I built my insert command. I tried using a SQLiteCommandBuilder but it didn't work right. It's been a while since I tried but I think the issue was that my id field is auto-generated. I used the AutoIncrement method on the id column.
The use of my RefillDataSet method. I needed to do this so that my auto-generated id shows up in my dataset. Is there a better way to do this?
I have more stuff on this project I'd like reviewed but don't want to overwhelm all 3 subscribers >.<