Visual Studio

devenv /resetaddin Complete.Name.Of.Your.Connect.Class

Mark Churchill wrote:

maybe I'll write an article when I get around to it

using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection("Here goes your connection string")) {
 
	// First get DataSet
	System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("Here goes your query string");
	connection.Open();
	System.Data.SqlClient.SqlDataReader dbReader = cmd.ExecuteReader();
	DataSet ds = new DataSet();
	ds.Load(dbReader, LoadOption.OverwriteChanges, "Your table name");
	dbReader.Close();
 
	// Now read txt
	System.IO.StreamReader txtReader = System.IO.File.OpenText("Path of TXT file");
	// Here read data from TXT file, e.g.:
	string someDataForColumn1 = txtReader.ReadLine();
 
	// Edit DataSet
	DataRow newRow = ds.Tables[0].DefaultView.AddNew().Row;
	newRow["Column1"] = someDataForColumn1;
 
	// Save DB
	ds.AcceptChanges();
	// Close connection (end of "using" block")
}