/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 vote278 views2 answers
Install nuget package for S3
C#
1 vote315 views1 answer
Which gas is at anode
C#
9 votes272 views1 answer
Camera follow
C#
6 votes287 views2 answers
Unity check collider layer
C#
0 vote297 views1 answer
Unity 2d animation on death
C#Unity
0 vote307 views1 answer
How to solve error in ExecuteNonQuery() in asp.net
C#
0 vote289 views1 answer
Validate base64 string c#
C#
6 votes289 views2 answers
C# const vs readonly
C#
0 vote315 views1 answer
Unity 2D mouse look at cursor
C#
1 vote295 views1 answer
How to set the fps in monogame
C#