using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace DataAccess { public partial class DataProvider { public static DataTable GetCarDashboardInfo() { SqlConnection sqlCon=null; DataSet ds = new DataSet(); try { sqlCon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString()); sqlCon.Open(); SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandText = "ssp_CarDashboard"; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Connection = sqlCon; SqlDataAdapter sqlAdp = new SqlDataAdapter(); sqlAdp.SelectCommand = sqlCmd; sqlAdp.Fill(ds); sqlCon.Close(); sqlCmd.Dispose(); } catch (Exception ex) { throw ex; } return ds.Tables[0]; } } }
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.
This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)