/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

6 votes301 views2 answers
Unity copy to clipboard
C#
0 vote266 views1 answer
Quotes in quotes in c#
C#
1 vote270 views1 answer
Unity key up
C#
1 vote274 views1 answer
Shallow copy vs deep copy c#
C#
4 votes278 views1 answer
C# remove from list in foreach
C#
0 vote315 views1 answer
How to get the ip asp.net mvc
C#
3 votes311 views1 answer
How to make an object invisible unity
C#Unity
0 vote269 views1 answer
Filter enum using linq query
C#
14 votes278 views1 answer
Unity set position
C#
0 vote263 views1 answer
How-to-add-new-column-with-value-to-the-existing-datatable
C#