TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
thiago costa
NA
319
0
C# SQL Connection class
Oct 12 2011 11:58 PM
Hello there guys,
I installed MSSQL server 2008 Enterprize, I got a table there, with a few colums (Fname, Lname, etc etc... they are jst a test, all in Vchar10 atm)
How would I make a Database Connection with c# ? ...
Back in the days, my friend Vinoth, wrote me a nice class...
I lost it since my hdd blew up ... I had 2 text boxes, Login (sa) password, and a login button... It would login into my database...
Then I had some query commands to select what ever, and bring data to a datagrid ....
I am trying to do the same kind of thing, but at the same time, I want to be able to update the database (after logged into it with my c# program) I want
to be able to update the table by writting into the datagrid ...
Also, futurely, I want to add a SELECT checkbox into the datagrid so that I can select the following line down to another datagrid upon a click ...
I want to develop a software for me, because I am going to start selling auto parts, and I want to create my own system...
After I have something, I want to get into printing invoices with the software etc...
I posted an exaple of what I want to have acomplished...
the example below, makes so the selected line (highlighted in blue) goes to the bottom datagrid after clicking on a button, and from there it creates the order, then it goes to the customer section after that but I don't want to go to crazy, I wanna do the database connection work first lol..
Also, will I have to use any odbc settings to stablish connections ? or is it doable by just IP ? ... when I was hosting a game back in the days (4 years ago) I needed ODBC for a bunch of stuff, but I wasn't really fluent I kinda had no idea what I was doing I just struggled toomuch, and got a lot of help from my friend vinoth ...
Thanks for reading guys.
Please help... thanks
Attachment:
examplejpg.rar
Reply
Answers (
11
)
automation of code in c#.net
"The SelectCommand property has not been initialized before calling 'Fill'.