Console Application To Display Data From SQL Server

In this post we will learn How to Create a Console Application To Display Data From SQL Server. A console application is a computer program designed to be used via a text-only computer interface, such as a text terminal, the command line interface of some operating systems (Unix, DOS, etc.).

Steps To Create Console Application:

1. Open Visual Studio > Click New Project > Choose Console Application.

2. This will open c# code page, Code for our app is as follows:

Code:

01using System;
02using System.Collections.Generic;
03using System.Linq;
04using System.Text;
05using System.Threading.Tasks;
06using System.Data.SqlClient;
07using System.Data;
08 
09namespace ConsoleApplication1
10{
11    class Program
12    {
13        static void Main(string[] args)
14        {
15            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=dev;User ID=sa;Password=sa");
16            con.Open();
17 
18            SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM users", con);
19            DataSet ds = new DataSet();
20            da.Fill(ds);
21            foreach (DataTable dt in ds.Tables)
22            {
23                Console.WriteLine("User Details Are Following:");
24                for (int curCol = 0; curCol < dt.Columns.Count; curCol++)
25                {
26                    Console.Write(dt.Columns[curCol].ColumnName.Trim() + "\t");
27                }
28                for (int curRow = 0; curRow < dt.Rows.Count; curRow++)
29                {
30                    for (int curCol = 0; curCol < dt.Columns.Count; curCol++)
31                    {
32                        Console.Write(dt.Rows[curRow][curCol].ToString().Trim() + "\t");
33                    }
34                    Console.WriteLine();   
35                }
36            }
37        }
38    }
39}