/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 vote122 views1 answer
C# get all bytes of a file
C#
3 votes222 views1 answer
Unity desactivate collider
C#Unity
0 vote149 views1 answer
C# run file
C#
0 vote131 views1 answer
Hashing a file in C#
C#
7 votes134 views2 answers
: ? operator in c#
C#
0 vote114 views1 answer
How to change something in the window using a thread wpf
C#
1 vote131 views1 answer
How to detect mouse click in c#
C#
0 vote232 views1 answer
Delayed function unity
C#
1 vote120 views1 answer
Null check syntax c#
C#
0 vote121 views1 answer
How to use the mouse scroll wheel to move the camera in unity
C#