Retrieving data through data reader in SQLite

Question

How to retrieve a data through data reader in SQLite.

Aarti · Answer

Hi Stephen, To Retrieve Data through Data Reader In SQLite: The following example creates a SQLiteConnection, a SQLiteCommand, and a SQLiteDataReader. The example reads through the data, writing it out to the console. Finally, the example closes the SQLiteDataReader, then the SQLiteConnection. public void ReadMyData(string myConnString) { string mySelectQuery = "SELECT DeptNo, DName FROM Dept"; SQLiteConnection sqConnection = new SQLiteConnection(myConnString); SQLiteCommand sqCommand = new SQLiteCommand(mySelectQuery,sqConnection); sqConnection.Open(); try { SQLiteDataReader sqReader = sqCommand.ExecuteReader(); // Always call Read before accessing data. while (sqReader.Read()) { Console.WriteLine(sqReader.GetInt32(0) + ", " + sqReader.GetString(sqReader.GetOrdinal("DName"))); } // always call Close when done reading. sqReader.Close(); // Close the connection when done with it. } finally { sqConnection.Close(); } }

Satyapriya Nayak · Answer

Hi Stephen, Please refer the below link http://www.gisandchips.org/svn/sqliteprovider/SQLiteDataReader.cs http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_24786792.html Thanks

gopi krishna · Answer

i want sqlite database for windows phone 7,i download some examples,but some examples i dont get sqlitedatareader component.step by step procedure for sqlite database i want.simple and easy process , i want sqliteconnction,sqlitedatareader,salitedata adapter,sqlitecommand.i want these components how to get these components through what reference namespace i got these total components