/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 vote154 views1 answer
Ef core add OnModelCreating foreign key
C#
4 votes174 views4 answers
C# remove substring
C#
0 vote123 views2 answers
ToLocalIsoString() vs toIsoString()
C#
0 vote128 views1 answer
Unity agent look at
C#
15 votes134 views3 answers
How to get the today date in c#
C#
0 vote124 views1 answer
C# 2 timespan return yesterday
C#
0 vote125 views1 answer
How to play multiple sound at once on c# windows form
C#
0 vote133 views1 answer
Smooth Sentences c#
C#
0 vote124 views1 answer
Custom click event wpf button
C#
0 vote182 views1 answer
How to set picturebox width with form width in c#
C#