- Joined
- Mar 3, 2005
- Location
- Jacksonville, FL
First of all I'm using C#.
I wanted to check if there is anyone in here familiar with doing this. I'm basically trying to import text file into a specific table in the DB. I've never done this before so trying to gather as much resources as possible before I proceed with doing this.
Right now I'm focusing on opening the connection the the SQL itself. I found this code example:
That seems to open connection to a specific DB. But if I wanted to connect to a specific table in the DB where I will be importing the text file, do I need to expand the parameter to specify that table?
Any help is appreciated. Thanks
I wanted to check if there is anyone in here familiar with doing this. I'm basically trying to import text file into a specific table in the DB. I've never done this before so trying to gather as much resources as possible before I proceed with doing this.
Right now I'm focusing on opening the connection the the SQL itself. I found this code example:
Code:
SqlConnection thisConnection = new SqlConnection("Server=localhost;Port=5432;User Id=postgres;Password=a;Database=Test;
That seems to open connection to a specific DB. But if I wanted to connect to a specific table in the DB where I will be importing the text file, do I need to expand the parameter to specify that table?
Any help is appreciated. Thanks