/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

-1 vote333 views1 answer
Unity destroy gameobject with delay
C#
2 votes322 views2 answers
C# connect tcp
C#
0 vote351 views1 answer
Populate toolstripitems to combobox
C#
10 votes314 views5 answers
C# string[] to string
C#
3 votes305 views1 answer
Unity how to get y value
C#
0 vote321 views1 answer
How to add rigidbody in unity
C#
0 vote310 views1 answer
Maximize Print Preview
C#
-2 votes419 views1 answer
How to move balance from one card to another target
C#
1 vote336 views1 answer
GGdesign
C#
0 vote406 views1 answer
Unity string lowercase
C#Unity