/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 vote283 views1 answer
Decimal places c#
C#
0 vote253 views1 answer
Dapper Get List
C#
0 vote250 views1 answer
Pyqt button image
C#
14 votes241 views2 answers
How to move player with transform. position
C#
0 vote235 views1 answer
Visual studio debug copy byte[] from watch
C#
1 vote235 views1 answer
Unity lookrotation lerp
C#
0 vote242 views1 answer
How to do minus with button c#
C#
0 vote278 views1 answer
Asp.net render control to string
C#
0 vote234 views1 answer
Sucess messages in c#
C#
12 votes229 views4 answers
Groupby in linq
C#