/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 vote188 views1 answer
Avg in c#
C#
0 vote187 views3 answers
Published net core did not have wwwroot
C#
0 vote180 views1 answer
Displayname c#
C#
0 vote196 views1 answer
Increase value in dictionary against a key in c#
C#
1 vote178 views1 answer
How to lerp in c#
C#
4 votes239 views1 answer
Deactivate a gameobject unity
C#Unity
0 vote176 views2 answers
Reflection get enum value C#
C#
0 vote185 views1 answer
True false when key pressed in c sharp unity
C#
0 vote183 views1 answer
Unity OVR Headset Emulator not working
C#
0 vote182 views1 answer
Windows forms webbrowser refresh
C#