c# and SQL programming

Potatoman | 22:19 Fri 30th Dec 2005 | Technology

2 Answers

Hi there. Im trying to write an application to display SQL data in c# 2. I have made a connection in my app to my server fine, but need to know a) how to send a SQL statement to my server and b) to display a field in a text box, ie First Name, Surname etc...
Thanks in advance to anyone who can help. PM

A bit worried now... HELP PLEASE!

Making a VCD in Nero

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by Potatoman. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

Aquariel

This might help:

http://www.c-sharpcorner.com/Code/2002/Oct/UsingSQLP1.asp

OBonio

If using a server (MySql, Oracle, SQL Server), I would suggest using stored procedures. This will make your application more scalable. Sending SQL queries from your application is very inefficient and can lead to SQL injection attacks.

http://www.c-sharpcorner.com/Code/2003/Jan/InsOutsinCS.a sp

1 to 2 of 2

Do you know the answer?