Upgrade your account to a Community Supporter account and remove most of the site ads.

Reply to thread

Message: <blockquote data-quote="IcyCool" data-source="post: 3324349" data-attributes="member: 20308">You just want to connect to a database, pull the data, and put it in a text file?  Have you done that before in any other languages?Here's a pretty simple way to connect to an Oracle DB and pull data:In the web.config file, you'll want an entry under your <connectionstrings> tag, mine looks similar to the following:[code]<add name="SampleConnection" connectionString="Data Source=[i]datasource[/i];Persist Security Info=True;User ID=[i]userid[/i];Password=[i]password[/i];Unicode=True" providerName="System.Data.OracleClient"/>[/code]Then in your code you'll do something like this:[code]string sampleConnString = ConfigurationManager.ConnectionStrings["SampleConnection"].ConnectionString;string sampleCommand = "Select * from Table1";OracleDataReader simpleReader;OracleCommand queryCommand = new OracleCommand();OracleConnection dbConnection = new OracleConnection(sampleConnString);[/code]In a try-catch block you'll do this:[code]dbConnection.Open();queryCommand.Connection = dbConnection;queryCommand.CommandText = sampleCommand;simpleReader = queryCommand.ExecuteReader();[/code]And now you have a dataReader object containing the results of your SQL statement.  From there you instantiate a file object, and write out the contents of the dataReader to the file.There are other ways of doing this, and this was for an Oracle database, so you may have to play around with it.Edit - I should also note that the above is in C#.  You didn't specify C# or VB.NET, so I pulled an example from what I'm most familiar with. You might also want to read the info at the following links:<a href="http://msdn.microsoft.com/msdnmag/issues/04/06/DataPoints/" target="_blank">MSDN Magazine</a> article about the differences between using datareaders and datasets.<a href="http://msdn2.microsoft.com/en-us/library/ms171919(VS.80).aspx" target="_blank">Querying data overview</a>Or just search for anything on ADO.NET.</blockquote>

Verification