Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.33 KB | None | 0 0
  1. SqlDataReader getSqlDataReader(String ^_sql)
  2. {
  3. SqlDataReader ^_sqlDataReader = nullptr;
  4.  
  5. SqlConnection ^_connection = gcnew SqlConnection();
  6.  
  7. ConnectionStringSettings ^connectionSettings = ConfigurationManager::ConnectionStrings["AppDefaultConnection"];
  8. this->_connection->ConnectionString = connectionSettings->ConnectionString;
  9.  
  10. try {
  11. this->_connection->Open();
  12. }
  13.  
  14. catch (Exception ^_exception)
  15. {
  16. Console::WriteLine("Error : " + _exception->Message);
  17. return nullptr;
  18. }
  19.  
  20. try
  21. {
  22. SqlCommand ^_sqlCommand = gcnew SqlCommand(_sql,_connection);
  23. _sqlDataReader = _sqlCommand->ExecuteReader();
  24. }
  25.  
  26. catch(Exception ^_exception)
  27. {
  28. Console::WriteLine("Error : " + _exception->Message);
  29. return nullptr;
  30. }
  31.  
  32. return _sqlDataReader;
  33. }
  34.  
  35. SqlDataReader ^reader = getSqlDataReader(yourParameterizedQueryString);
  36.  
  37. List<TypeToFetch>^ data = gcnew List<TypeToFetch^>();
  38. if(reader != nullptr && reader->HasRows)
  39. {
  40. TypeToFetch^ typeToFetch = gcnew TypeToFetch();
  41. while(reader->Read())
  42. {
  43. // example
  44. TypeToFetch->id = (int) reader["Id"];
  45. TypeToFetch->name = reader["Name"]->ToString();
  46. data->Add(typeToFetch);
  47. }
  48. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement