Connect to MS SQL Server

Question

0.00/5 (No votes)

See more:

Hi,

I would like to connect to a SQL Server in Visual Basic within an aspx application. I do have the connection string. How do I connect to the database and execute SQL statements?

Thanks

Posted 6-Oct-11 0:48am

chris085

Add a Solution

Comments

Herman<T>.Instance 6-Oct-11 6:54am

what is your exact problem?

3 solutions

Solution 2

I would start by reading through this

ADO.NET Code Examples[^]

Posted 6-Oct-11 1:15am

Simon_Whale

Solution 3

http://www.cs.swan.ac.uk/~csneal/ReliableWeb/Example.html[^]

Follow this link......for GUI exaplaination.....:)

Posted 6-Oct-11 1:37am

NikulDarji

Updated 6-Oct-11 1:39am

v2

Add a Solution

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

Herman<T>.Instance · Accepted Answer · 2011-10-06T00:55:00

Solution 1

use SqlCommand class to communicate with the database if the sql server is MS Sql Server

Posted 6-Oct-11 0:55am

Herman<T>.Instance

Comments

Reiss 6-Oct-11 7:09am

I think you meant SqlConnection class to communicate, as you run the commands against the connection.

Herman<T>.Instance 6-Oct-11 16:37pm

yep that is what I mean!

chris085 6-Oct-11 7:14am

Could you give an excample (code)?
SQL Statement looks like this: "Select name from person where id = '" + field1.Text +"'"
I'm interested in establishing the connection and then executing this query.

Connect to MS SQL Server

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Connect to MS SQL Server

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us