Posts

Showing posts from October, 2017

C#: how to get data from DB using console application

C#: how to get data from DB using console application  //--------------------------------------------- Source code   ------------------------------------------- private void showAll() {             SqlConnection con = new SqlConnection(constring);             //Open database connection to connect to SQL Server             con.Open();             //Data table is used to bind the resultant data             DataTable dtusers = new DataTable();             // Create a new data adapter based on the specified query.             SqlDataAdapter da = new SqlDataAdapter("SELECT  * FROM Feetable ", con);             //SQl command builder is used to get data from database based on query             SqlC...