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 ?

[Vaibhav Sharma]

Ok as regards your first qt. >> Use the My.Computer.FileSystem.ReadAllText() function to read the text from the text file that you want the data to be imported from. Dump the string returned by this into a local called importedData >> As for the Database code, you should have specified the provider, but here is it for Access. Dim oledbCn As New System.Data.OledbConnection(connectionString) oledbCn.Open() Dim oledbCmd As New System.Data.OledbCommand(commandString,oledbCn) If oledbCmd.ExecuteNonQuery()>0 Then MessageBox.Show("Data imported to database correctly.") Else MessageBox.Show("Data import failed.") End If As you may be knowing, connectionString for Access will be "Microsoft.Jet.OLEDB.4.0; Data Source=MyDatabase.mdb" commandString would be the T-SQL statement like "INSERT INTO TableName(colName1,colName2,...) VALUES('" & importedData & "',...)" I guess that is fairly a very Beginners job in .NET and you should be having no problems whatsoever using the above snippets. In case of problems always refer back and we will be there for u. Happy Coding :)

Regards, Vaibhav Sharma