/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 vote116 views1 answer
Read embedded resource c# xml
C#
0 vote104 views1 answer
666
C#
0 vote141 views1 answer
Unity check if current scene is being unloaded
C#Unity
0 vote100 views1 answer
How to input parameters in c#
C#
0 vote142 views2 answers
Sars
C#
1 vote102 views1 answer
Action being performed on this control is being called from the wrong thread c#
C#
0 vote97 views1 answer
Unity how to destroy child
C#
0 vote133 views1 answer
Instantiate unity 2d in parent
C#Unity
0 vote111 views1 answer
Process start web document
C#
0 vote116 views1 answer
C# cycle through directory
C#