Link to home
Start Free TrialLog in
Avatar of patrickkenney
patrickkenney

asked on

Need help with notes field for database application - VB.NET and SQL 2000

I need to be able to insert notes in a database application using VB.NET front end and SQL 2000 as the database backend. Here is how I would like to be able to insert notes.

I have a richtextbox, textbox and button on a form. I would like to be able to enter text into the textbox and have it add a new line to the richtextbox when I click on the button. I know this can be done, but I'm pulling a blank on getting the notes to show up in the richtextbox line by line and then be update in the varbinary notes field in sql. Please help! Thanks in advance!!!
Avatar of Jigit
Jigit
Flag of Israel image

Perform the following actions in OnClick event handler of your button
1. Open connection to the database
2. Create INSERT query with appropriate parameters: from the richtextbox and the textbox
3. Execute the above query
4. Close connection

HTH,
Jigit
Avatar of patrickkenney
patrickkenney

ASKER

could you be more specific? Thanks.
That has nothing to do with what I'm asking. Please reread my original question. Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Scoobyed
Scoobyed

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Worked like a charm!! Thanks!!!