/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 vote180 views1 answer
C# program that print charater from A to Z and it's corresponding number
C#
27 votes193 views2 answers
Find gameobject with tag
C#
0 vote187 views1 answer
C# asp.net gridview selected row unselect
C#
0 vote183 views1 answer
HOW TO CALL AN EXTENSION METHOD FOR VIEW C#
C#
0 vote185 views1 answer
Degree between two points latitude longitude c#
C#
8 votes190 views2 answers
C# round to 2 decimal places
C#
1 vote182 views1 answer
Set request timeout c#
C#
0 vote189 views1 answer
Scroll two divs simultaneously site:stackoverflow.com
C#
0 vote179 views1 answer
Grab reference from method parameter c#
C#
0 vote192 views1 answer
C# console app how to run another program
C#