How do I connect my form tomy database

Page 1 of 1

[ 2 posts ]

Author

Question

dapsin999

Question subject: How do I connect my form tomy database

Posted: Wed May 27, 2009 9:39 am

Joined: Wed May 27, 2009 9:06 am
Posts: 2
Has thanked: 0 time
Have thanks: 0 time

Hello, Please am new on C# and am using Ms Visuall studio 2008 to build a windows form using C# but I dont know how to connect my submit button to the database ms sql server 2005, so i can view the information entered from the form. Thank you

yosiffz

Question subject: Re: How do I connect my form tomy database

Posted: Sun Oct 24, 2010 4:38 am

Joined: Tue Mar 30, 2010 4:17 pm
Posts: 3
Has thanked: 0 time
Have thanks: 1 time

using System.Data.SqlClient;

String sqlQuery = "INSERT INTO table name Values (@,@,@,@,@,@)";
SqlConnection aConn = new SqlConnection("Data source= Your Computer name \\SQLEXPRESS; database= your database name ; Integrated Security = true");
SqlCommand aCommand = new SqlCommand(sqlQuery, aConn);

Regards
Joe

For this message the author yosiffz has received gratitude : msi_333

Page 1 of 1

[ 2 posts ]

Similar topics
Topic title	Forum	Author	Comments
getting gst, pst total to diplay in my javascript form	Scripting Language	Anonymous	0
database contents display in table format in swing	GUI	subho07	4
How to make PHP form data saved into txt file	PHP	Radu	6
How to connect to serial port using java	Java	msi_333	11
php User Registration Form	PHP Tutorials	msi_333	2

Codemiles.com » Web Development Forums » ASP.NET

All times are UTC [ DST ]

Users browsing similar posts

Users browsing this forum: No registered users and 1 guest

Jump to:

Previous Question | Next Question