/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

1 vote101 views1 answer
C# copy file to system folder
C#
2 votes99 views2 answers
C# main
C#
0 vote96 views1 answer
Regex for accepting a file name c#
C#
0 vote91 views1 answer
Unity unfreeze position in script
C#
0 vote100 views1 answer
C# reflection get property value array
C#
0 vote113 views1 answer
VLC .net
C#
0 vote92 views1 answer
Type already defines a member called 'Get'
C#
4 votes62 views1 answer
Base keyword in c# constructor
C#
0 vote98 views1 answer
How to count letters in c#
C#
10 votes93 views2 answers
C# unity get name of object
C#