/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 vote276 views2 answers
Named Entity Extraction C#
C#
0 vote303 views1 answer
C# linq mselect
C#
4 votes266 views1 answer
Unity how to copy something to the clipboard
C#
0 vote325 views1 answer
Unity gun clipping through walls
C#Unity
0 vote263 views1 answer
Convert video to byte array c#
C#
0 vote265 views1 answer
C# get property using string
C#
-2 votes273 views1 answer
@razor identify last foreach
C#
0 vote301 views1 answer
Is keyboard clicked in Unity
C#Unity
6 votes320 views1 answer
How to make mouse invisible unity
C#Unity
9 votes262 views3 answers
Round double c#
C#