I'm new to C# development. I am familiar with setting up connection strings and working with databases in ADO in VB6, but this is a bit more involved.
I have a very basic application in which I created a connection to a production database table with three fields. I drug the table onto the form and was pleasantly surprised to see how it not only created the table on the form, but also gave me navigation controls. Unfortunately, now...
3 results in 0.0031 seconds.
-
Change Connection string for designer table at runtime
-
Open SQL connection using T-SQL
I would like to connect to a remote sql server using a stored procedure. I had planned on using OPENQUERY( linked_server ,'query' ) to pull data from the remote server but this command does not accept variables for its arguments. Is there another way to open a connection using Transact-SQL?
Thanks for your help! -
navyjax2 started a topic Database creation in SQL 2005 from C# - works from one computer, not the otherin C SharpDatabase creation in SQL 2005 from C# - works from one computer, not the other
Was hoping someone could give me some things to check here - I'm trying to figure this one out.
I've got a SQL connection string in an INI file, it is read into my C# .NET console app and connects to the database fine from my workstation. It processes the SqlCommand statements I use to drop the table (if it exists) and re-create it, and does an Insert statement to fill one row, and quits. This all works fine from my workstation (running...
