Wednesday, 10 April 2019

Load datareader to datatable

  1. public DataTable GetDataTable()
  2. {
  3.    DataTable dataTable = new DataTable();
  4.    using (SqlConnection conn =
  5.       new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString))
  6.    {
  7.       SqlCommand cmd = conn.CreateCommand();
  8.       cmd.CommandText = "procedure_name";
  9.       cmd.CommandType = CommandType.StoredProcedure;

  10.       // SqlDataReader need an open conncetion, so check and open it.
  11.       if (conn.State != ConnectionState.Open)
  12.            conn.Open();

  13.       // Read data by using Execute Reader
  14.       SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

  15.       //Use data table load method to load data from data reader
  16.       dataTable.Load(dr);                
  17.    }
  18.    return dataTable;
  19. }

No comments:

Post a Comment