Using SQL Database results to populate slide

[dbrewerton]

Greetings, in numerous examples the data will come from a text file. What I'd like to do is pull this data from a SQL Server database. I've configured the c# code behind connection string object and I did find one that shows pulling from OleDB, how do I pull from Sql for data? I'm including additional information below for clarification.

This is the connection string I've set up for this purpose pulling the data from App.config.

SqlConnection sqlconn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connStr"].ConnectionString);

How do I load the results from my query into a DataTable using a DataAdapter? Many thanks!

[Amber.Gu]

Hi,

Thanks for your inquiry.
Please try the code below to connect the Database and export the data into a data table.

Code: Select all

             SqlConnection sqlconn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connStr"].ConnectionString);
            SqlCommand command = new SqlCommand();
            command.CommandText
                    = " SELECT * "
                    + " FROM tableName";
            DataSet dataSet = new System.Data.DataSet();
            SqlDataAdapter dataAdapter = new SqlDataAdapter(command.CommandText, sqlconn);
            dataAdapter.Fill(dataSet, " tableName ");
            System.Data.DataTable dt = dataSet.Tables["tableName "];

Best wishes,
Amber
E-iceblue support team