/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 views1 answer
Get all files in all subdirectories c#
C#
0 vote228 views1 answer
Open aspx page c#
C#
1 vote242 views1 answer
Set text in center wpf
C#
1 vote247 views1 answer
Unity load current scene
C#
5 votes261 views2 answers
How to check if key is held in unity
C#Unity
0 vote248 views1 answer
Unity color mix
C#Unity
1 vote222 views1 answer
How to write web service for API in c#
C#
0 vote219 views1 answer
Sucess messages in c#
C#
0 vote244 views1 answer
How to make build events always run visual studio
C#
0 vote263 views1 answer
Unity get prefabs from folder
C#Unity