/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 vote201 views1 answer
Location in screen css
C#
0 vote254 views1 answer
User control equivalent event for form.shown c#
C#
4 votes288 views1 answer
Use a for loop to sum an array c#
C#
0 vote271 views2 answers
Inline creation dictionnary C#
C#
0 vote294 views1 answer
How to make soft body OBJECT in unity
C#Unity
4 votes268 views1 answer
Combobox selected name c#
C#
0 vote263 views1 answer
How to make an ui to follow gameobject
C#
0 vote270 views1 answer
Dxf read c#
C#
28 votes299 views3 answers
Unity check gameobject active
C#Unity
3 votes270 views4 answers
Convert string to array c#
C#