Inserting Variables in a table w/ C#

Question

I am working on parsing multiple text files and inserting the variables I store into a table w/ a stored procedure. I tried w/ a data adapter, but was told not to use this since it is not returning anything. I was told to use Command.ExecuteNonQuery. When I use that command, I get an error that the connection is not open. When I use the SqlConnection.Open() command, I get an error that the connection is already open. I am pretty new to database programming w/ c#, so yeas, a newbie question. Please post whatever info you would need to answer the question. Thanx in advance Jude