/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

2 votes254 views1 answer
Random.range unity not working
C#
0 vote148 views1 answer
C# passing function as input delegate
C#
0 vote127 views1 answer
Get user startup folder path C#
C#
0 vote143 views1 answer
C# sqlite query
C#
0 vote127 views1 answer
Antlr c# errors
C#
0 vote135 views1 answer
Unity keep screen always on
C#
1 vote137 views1 answer
Visual studio windows form exit button
C#
1 vote139 views1 answer
Where did mark twain go to school
C#
0 vote149 views1 answer
1080 / 7
C#
0 vote130 views1 answer
Delete all connections rabbitmq terminal
C#