/C#/How to retrieve data from database in c# using datatable

How to retrieve data from database in c# using datatable

using System.Data;
using System.Data.SqlClient;

public DataTable StudentView()
{
    SqlConnection sqlCon = new SqlConnection(@"Server= localhost\SQLINSTANCENAME; Database= DBNAME; Integrated Security=True;");

    SqlDataAdapter sqlDa = new SqlDataAdapter("QUERY", sqlCon);

    DataTable dtbl = new DataTable();
    sqlDa.Fill(dtbl);

    return dtbl;
}

Source: stackoverflow.com

Similar codes

0 vote136 views1 answer
Unity get camera
C#
2 votes141 views2 answers
Largest element in array in c#
C#
1 vote178 views1 answer
Unity temperature to colour
C#Unity
0 vote135 views2 answers
Get index Brushes properties C#
C#
3 votes138 views1 answer
How to convert angle to vector in c#
C#
20 votes147 views3 answers
C# thread wait
C#
0 vote128 views1 answer
Hello world in unity c#
C#
2 votes124 views1 answer
Winforms messagebox with button
C#
0 vote132 views1 answer
Test for even Number
C#
1 vote133 views1 answer
Csgo throw last grenade bind
C#