Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SqlDataReader getSqlDataReader(String ^_sql)
- {
- SqlDataReader ^_sqlDataReader = nullptr;
- SqlConnection ^_connection = gcnew SqlConnection();
- ConnectionStringSettings ^connectionSettings = ConfigurationManager::ConnectionStrings["AppDefaultConnection"];
- this->_connection->ConnectionString = connectionSettings->ConnectionString;
- try {
- this->_connection->Open();
- }
- catch (Exception ^_exception)
- {
- Console::WriteLine("Error : " + _exception->Message);
- return nullptr;
- }
- try
- {
- SqlCommand ^_sqlCommand = gcnew SqlCommand(_sql,_connection);
- _sqlDataReader = _sqlCommand->ExecuteReader();
- }
- catch(Exception ^_exception)
- {
- Console::WriteLine("Error : " + _exception->Message);
- return nullptr;
- }
- return _sqlDataReader;
- }
- SqlDataReader ^reader = getSqlDataReader(yourParameterizedQueryString);
- List<TypeToFetch>^ data = gcnew List<TypeToFetch^>();
- if(reader != nullptr && reader->HasRows)
- {
- TypeToFetch^ typeToFetch = gcnew TypeToFetch();
- while(reader->Read())
- {
- // example
- TypeToFetch->id = (int) reader["Id"];
- TypeToFetch->name = reader["Name"]->ToString();
- data->Add(typeToFetch);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement