News1 min ago
c# and SQL programming
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
Thanks in advance to anyone who can help. PM
Answers
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.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
http://www.c-sharpcorner.com/Code/2003/Jan/InsOutsinCS.a sp
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.