/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 vote230 views1 answer
Unity get prefabs from folder
C#Unity
1 vote219 views1 answer
Unity how to get the side ways velocity of a object
C#Unity
1 vote190 views1 answer
Convert char[] to string
C#
0 vote185 views1 answer
Convert C# Class to xml wth xsd.exe
C#
1 vote228 views3 answers
C# get string in parentheses
C#
1 vote202 views1 answer
Add new column in data table c#
C#
0 vote186 views2 answers
Change column name in datatable C#
C#
1 vote222 views1 answer
C# get next item in list
C#
0 vote249 views1 answer
What is string args in c#
C#
1 vote227 views1 answer
Find word in string array c#
C#