help me to create a simple program vb.net

Question

1.00/5 (2 votes)

See more:

SQL-Server-2005

i need a simple program to insert and delete data (text and a number) from text box to sql server 2005 and in Data Grid View plz help me 'm just a beginner in this..... plz help me....

Posted 7-Jun-11 7:44am

sr_sivaprasad

Add a Solution

Comments

Jpuckett 7-Jun-11 13:46pm

We're not here to perform your project for you.

This is a question and answer forum, not a "do my work for me" forum.

Have a great day, and best of luck.

sr_sivaprasad 10-Jun-11 9:23am

Jpuckett : 'm trying to learn vb.net its not my project.....

Kschuler 7-Jun-11 14:18pm

Start working on it and let us know when you get stuck on something. If you don't even know where to start, try searching CP articles for help on the topics. Here:
http://www.codeproject.com/search.aspx?q=SQL+Server+2005+beginner

Tarun.K.S 7-Jun-11 14:36pm

Is it a web project or windows forms project?

sr_sivaprasad 10-Jun-11 9:24am

windows....

costavo 7-Jun-11 17:04pm

I'd like to help dude, but as Kschuler comment says, ask when u get stuck

sr_sivaprasad 10-Jun-11 9:25am

kk.... thankz anyway........

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2011-06-07T08:26:00

Since this is your homework, it's only fair you do the work: so no code!

It isn't a difficult task: your notes will cover most if not all of it.
Just like any other problem, break it down into manageable chunks, and do them one at a time, making sure each chunk works properly before you move on:

1) Create a form or page with one or two boxes on it for the text and the number.
2) Make sure you can get the text and the number into your program once the user has entered them.
3) Create your database. You will need at least one table, with (probably) at least three columns. One for your text, one for you number, and possibly one more for an identity column, if your numbers aren't going to be unique.
4) Get your numbers from the user, and output it to the database:
4a) Create a connection to the DB, and open it.
4b) Create a command object, and give it both the connection you just opened, and a valid SQL command to insert the data.
4c) Execute the command.
4d) Dispose of the command
4e) Dispose of the connection.

Done.