reading a string from a txt file & insert it in a database table?

[starist]

plz how can i read a string from a txt file then insert it in a database table using C# in visualstudio2005 ?

[Lutoslaw]

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")

}

I cannot test it now, so if any error appears please try to experiment a bit.

Greetings - Gajatko Portable.NET is part of DotGNU, a project to build a complete Free Software replacement for .NET - a system that truly belongs to the developers.