/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 vote150 views1 answer
C# sprintf equivalent
C#
0 vote146 views1 answer
How to populate list in c#
C#
1 vote143 views1 answer
Blank background for button wpf
C#
1 vote142 views1 answer
How get piece of text in laravel in persian text
C#
0 vote252 views1 answer
Unity android keycodes
C#Unity
0 vote158 views1 answer
Asp.net framework mvc cors error axios
C#
0 vote154 views1 answer
C# list audio devices
C#
0 vote151 views1 answer
Using == is inefficient unity
C#
14 votes186 views3 answers
C# add list to list
C#
0 vote232 views1 answer
Discord bot c# how to refresh message
C#