/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 votes144 views1 answer
Get selected rows gridcontrol devexpress
C#
-1 vote129 views1 answer
InverseTransformDirection
C#
6 votes137 views2 answers
String interpolation in C#
C#
1 vote163 views1 answer
Unity 3d camera rotate up and down
C#
0 vote127 views1 answer
Delay seconds in unity
C#
0 vote127 views1 answer
Static property in C#
C#
0 vote126 views1 answer
Button commandfield commandargument pass textbox
C#
3 votes128 views5 answers
Converting bitmap to byte array c#
C#
1 vote136 views1 answer
How to get the startup path in console app
C#
1 vote125 views1 answer
C# wpf keyinput DeadCharProcessed
C#