public new OleDbDataReader ExecuteReader(CommandBehavior behavior) { ArrayList results = new ArrayList(); IntPtr rs_list; GdaList glist_node; if (connection.State != ConnectionState.Open) { throw new InvalidOperationException("State != Open"); } this.behavior = behavior; IntPtr gdaConnection = connection.GdaConnection; IntPtr gdaParameterList = parameters.GdaParameterList; /* execute the command */ SetupGdaCommand(); rs_list = libgda.gda_connection_execute_command( gdaConnection, gdaCommand, gdaParameterList); if (rs_list != IntPtr.Zero) { glist_node = (GdaList)Marshal.PtrToStructure(rs_list, typeof(GdaList)); while (glist_node != null) { results.Add(glist_node.data); if (glist_node.next == IntPtr.Zero) { break; } glist_node = (GdaList)Marshal.PtrToStructure(glist_node.next, typeof(GdaList)); } dataReader = new OleDbDataReader(this, results); dataReader.NextResult(); } return(dataReader); }
private OleDbDataReader ExecuteReaderInternal(CommandBehavior behavior, string method) { OleDbDataReader dataReader = null; OleDbException nextResultsFailure = null; int state = ODB.InternalStateClosed; try { ValidateConnectionAndTransaction(method); if (0 != (CommandBehavior.SingleRow & behavior)) { // CommandBehavior.SingleRow implies CommandBehavior.SingleResult behavior |= CommandBehavior.SingleResult; } object executeResult; int resultType; switch(CommandType) { case 0: // uninitialized CommandType.Text case CommandType.Text: case CommandType.StoredProcedure: resultType = ExecuteCommand(behavior, out executeResult); break; case CommandType.TableDirect: resultType = ExecuteTableDirect(behavior, out executeResult); break; default: throw ADP.InvalidCommandType(CommandType); } if (_executeQuery) { try { dataReader = new OleDbDataReader(_connection, this, 0, this.commandBehavior); switch(resultType) { case ODB.ExecutedIMultipleResults: dataReader.InitializeIMultipleResults(executeResult); dataReader.NextResult(); break; case ODB.ExecutedIRowset: dataReader.InitializeIRowset(executeResult, ChapterHandle.DB_NULL_HCHAPTER, _recordsAffected); dataReader.BuildMetaInfo(); dataReader.HasRowsRead(); break; case ODB.ExecutedIRow: dataReader.InitializeIRow(executeResult, _recordsAffected); dataReader.BuildMetaInfo(); break; case ODB.PrepareICommandText: if (!_isPrepared) { PrepareCommandText(2); } OleDbDataReader.GenerateSchemaTable(dataReader, _icommandText, behavior); break; default: Debug.Assert(false, "ExecuteReaderInternal: unknown result type"); break; } executeResult = null; _hasDataReader = true; _connection.AddWeakReference(dataReader, OleDbReferenceCollection.DataReaderTag); // command stays in the executing state until the connection // has a datareader to track for it being closed state = ODB.InternalStateOpen; // MDAC 72655 } finally { if (ODB.InternalStateOpen != state) { this.canceling = true; if (null != dataReader) { ((IDisposable) dataReader).Dispose(); dataReader = null; } } } Debug.Assert(null != dataReader, "ExecuteReader should never return a null DataReader"); } else { // optimized code path for ExecuteNonQuery to not create a OleDbDataReader object try { if (ODB.ExecutedIMultipleResults == resultType) { UnsafeNativeMethods.IMultipleResults multipleResults = (UnsafeNativeMethods.IMultipleResults) executeResult; // may cause a Connection.ResetState which closes connection nextResultsFailure = OleDbDataReader.NextResults(multipleResults, _connection, this, out _recordsAffected); } } finally { try { if (null != executeResult) { Marshal.ReleaseComObject(executeResult); executeResult = null; } CloseFromDataReader(ParameterBindings); } catch(Exception e) { // if (!ADP.IsCatchableExceptionType(e)) { throw; } if (null != nextResultsFailure) { nextResultsFailure = new OleDbException(nextResultsFailure, e); } else { throw; } } } } } finally { // finally clear executing state try { if ((null == dataReader) && (ODB.InternalStateOpen != state)) { // MDAC 67218 ParameterCleanup(); } } catch(Exception e) { // if (!ADP.IsCatchableExceptionType(e)) { throw; } if (null != nextResultsFailure) { nextResultsFailure = new OleDbException(nextResultsFailure, e); } else { throw; } } if (null != nextResultsFailure) { throw nextResultsFailure; } } return dataReader; }
protected void Page_Load(object sender, EventArgs e) { try { Session["usuUsuario"].ToString(); } catch (Exception) { Response.Write("<script>alert('Desculpe... Você não pode vizualizar perfis enquanto estiver deslogado. Por favor efetue login e tente novamente.'); window.history.back();</script>"); Response.End(); } rsPerfil = objBD.ExecutaSQL("EXEC PerfilUsuarioPorUsername '" + Request["usuario"]+ "'"); if (rsPerfil == null) { Response.Redirect("./default.aspx"); } if (rsPerfil.HasRows) { rsPerfil.Read(); if (Session["usuID"].ToString() == rsPerfil["USU_ID"].ToString()) { Response.Redirect("../meu-perfil/" + Request["usuario"]); Response.End(); } if (Session["redeID"].ToString() != rsPerfil["RED_ID"].ToString()) { Response.Redirect("../default.aspx"); Response.End(); } nomeusuario.InnerText = rsPerfil["USU_NOME"].ToString(); nomeusuario1.InnerText = rsPerfil["USU_NOME"].ToString(); regiao.InnerText = rsPerfil["USU_REGIAO"].ToString(); biografia.InnerText = rsPerfil["USU_BIOGRAFIA"].ToString(); foto.Attributes.Add("src", "upload/imagens/usuarios/" + rsPerfil["USU_FOTO"].ToString()); foto_outro.Attributes.Add("src", "upload/imagens/usuario/galeria/thumb-" + rsPerfil["USU_ULTIMAFOTO"].ToString()); video_outro.Attributes.Add("src", rsPerfil["USU_ULTIMOVIDEO"].ToString()); if (rsPerfil["USU_ULTIMAFOTO"].ToString().Length < 1){foto_outro.Attributes.Add("style", "display: none;");} if (rsPerfil["USU_ULTIMOVIDEO"].ToString().Length < 1) { video_outro.Attributes.Add("style", "display: none;"); } if (rsPerfil["USU_ULTIMAFOTO"].ToString().Length < 1 && rsPerfil["USU_ULTIMOVIDEO"].ToString().Length < 1) { img_lateral_perfil.InnerHtml = "Sem vídeos e fotos para exibir no momento!"; } linkfotos.Attributes.Add("href","perfil/fotos/" + rsPerfil["USU_USUARIO"]); linkvideos.Attributes.Add("href", "perfil/videos/" + rsPerfil["USU_USUARIO"]); linkblog.Attributes.Add("href", "perfil/blog/" + rsPerfil["USU_USUARIO"]); } rsPerfil.NextResult(); posts.InnerHtml = ""; if (rsPerfil.HasRows) { while (rsPerfil.Read()) { posts.InnerHtml += "<li>" + "<p class=\"titu_post_home\"><a href=\"post/post-aberto-3\">" + rsPerfil["POS_TITULO"] + "</a></p>" + "<p class=\"desc_post_home\"><a href=\"post/post-aberto-3\">" + objUtils.CortarString(true, 90, rsPerfil["POS_TEXTO"].ToString()) + "</a></p>" + "<a href=\"post/" + objUtils.GerarURLAmigavel(rsPerfil["POS_TITULO"].ToString()) + "\" class=\"btn\">LEIA MAIS</a> </li>"; } } rsPerfil.NextResult(); if (rsPerfil.HasRows) { rsPerfil.Read(); if (Convert.ToInt16(rsPerfil["TOTAL_LOGIN"]) > 2) { liDedicado.Attributes.Add("class", "ativo"); imgDedicado.Attributes.Add("src", "/images/medalha_ok.png"); } if (Convert.ToInt16(rsPerfil["TOTAL_POST_BLOG"]) > 2) { liBlogueiro.Attributes.Add("class", "ativo"); imgBlogueiro.Attributes.Add("src", "/images/medalha_ok.png"); } if (Convert.ToInt16(rsPerfil["TOTAL_FOTOS"]) > 2) { liFotografo.Attributes.Add("class", "ativo"); imgFotografo.Attributes.Add("src", "/images/medalha_ok.png"); } if (Convert.ToInt16(rsPerfil["TOTAL_VIDEOS"]) > 2) { liProdutor.Attributes.Add("class", "ativo"); imgProdutor.Attributes.Add("src", "/images/medalha_ok.png"); } } rsPerfil.Close(); rsPerfil.Dispose(); }
private OleDbDataReader ExecuteReaderInternal(CommandBehavior behavior, string method) { OleDbDataReader dataReader = null; OleDbException nextResultsFailure = null; int state = ODB.InternalStateClosed; try { ValidateConnectionAndTransaction(method); if (0 != (CommandBehavior.SingleRow & behavior)) { // CommandBehavior.SingleRow implies CommandBehavior.SingleResult behavior |= CommandBehavior.SingleResult; } object executeResult; int resultType; switch (CommandType) { case 0: // uninitialized CommandType.Text case CommandType.Text: case CommandType.StoredProcedure: resultType = ExecuteCommand(behavior, out executeResult); break; case CommandType.TableDirect: resultType = ExecuteTableDirect(behavior, out executeResult); break; default: throw ADP.InvalidCommandType(CommandType); } if (_executeQuery) { try { dataReader = new OleDbDataReader(_connection, this, 0, this.commandBehavior); switch (resultType) { case ODB.ExecutedIMultipleResults: dataReader.InitializeIMultipleResults(executeResult); dataReader.NextResult(); break; case ODB.ExecutedIRowset: dataReader.InitializeIRowset(executeResult, ChapterHandle.DB_NULL_HCHAPTER, _recordsAffected); dataReader.BuildMetaInfo(); dataReader.HasRowsRead(); break; case ODB.ExecutedIRow: dataReader.InitializeIRow(executeResult, _recordsAffected); dataReader.BuildMetaInfo(); break; case ODB.PrepareICommandText: if (!_isPrepared) { PrepareCommandText(2); } OleDbDataReader.GenerateSchemaTable(dataReader, _icommandText, behavior); break; default: Debug.Assert(false, "ExecuteReaderInternal: unknown result type"); break; } executeResult = null; _hasDataReader = true; _connection.AddWeakReference(dataReader, OleDbReferenceCollection.DataReaderTag); // command stays in the executing state until the connection // has a datareader to track for it being closed state = ODB.InternalStateOpen; } finally { if (ODB.InternalStateOpen != state) { this.canceling = true; if (null != dataReader) { ((IDisposable)dataReader).Dispose(); dataReader = null; } } } Debug.Assert(null != dataReader, "ExecuteReader should never return a null DataReader"); } else { // optimized code path for ExecuteNonQuery to not create a OleDbDataReader object try { if (ODB.ExecutedIMultipleResults == resultType) { UnsafeNativeMethods.IMultipleResults multipleResults = (UnsafeNativeMethods.IMultipleResults)executeResult; // may cause a Connection.ResetState which closes connection nextResultsFailure = OleDbDataReader.NextResults(multipleResults, _connection, this, out _recordsAffected); } } finally { try { if (null != executeResult) { Marshal.ReleaseComObject(executeResult); executeResult = null; } CloseFromDataReader(ParameterBindings); } catch (Exception e) { // UNDONE - should not be catching all exceptions!!! if (!ADP.IsCatchableExceptionType(e)) { throw; } if (null != nextResultsFailure) { nextResultsFailure = new OleDbException(nextResultsFailure, e); } else { throw; } } } } } finally { // finally clear executing state try { if ((null == dataReader) && (ODB.InternalStateOpen != state)) { ParameterCleanup(); } } catch (Exception e) { // UNDONE - should not be catching all exceptions!!! if (!ADP.IsCatchableExceptionType(e)) { throw; } if (null != nextResultsFailure) { nextResultsFailure = new OleDbException(nextResultsFailure, e); } else { throw; } } if (null != nextResultsFailure) { throw nextResultsFailure; } } return(dataReader); }
public void PopularTabelas() { rsListar = objBD.ExecutaSQL("EXEC site_psCriacoesDocumentadas '" + Session["redeID"] + "' "); if (rsListar == null) { throw new Exception(); } tbAtiva.InnerHtml += "<table class=\"tabela\">"; tbAtiva.InnerHtml += " <tr>"; tbAtiva.InnerHtml += " <th style='min-width: 242px;'>Proposta</th>"; tbAtiva.InnerHtml += " <th style='min-width: 65px;'>Prazo</th>"; tbAtiva.InnerHtml += " <th>Relatos</th>"; tbAtiva.InnerHtml += " <th>Visualizar</th>"; tbAtiva.InnerHtml += " </tr>"; if (rsListar.HasRows) { while (rsListar.Read()) { tbAtiva.InnerHtml += " <tr>"; tbAtiva.InnerHtml += " <td>" + rsListar["CDO_TAREFA"] + "</td>"; tbAtiva.InnerHtml += " <td>" + rsListar["CDO_DATA"] + "</td>"; tbAtiva.InnerHtml += " <td>" + rsListar["TOTAL_RELATOS"] + "</td>"; tbAtiva.InnerHtml += " <td><a href=\"/tarefa-ativa/" + rsListar["CDO_ID"] + "\">Visualizar Proposta</a></td>"; tbAtiva.InnerHtml += " </tr>"; } tbAtiva.InnerHtml += "</table>"; //Próxima tabela rsListar.NextResult(); tbArquivada.InnerHtml += "<table class=\"tabela2\">"; tbArquivada.InnerHtml += " <tr>"; tbArquivada.InnerHtml += " <th style='min-width: 242px;'>Proposta</th>"; tbArquivada.InnerHtml += " <th style='min-width: 65px;'>Prazo</th>"; tbArquivada.InnerHtml += " <th>Relatos</th>"; tbArquivada.InnerHtml += " <th>Visualizar</th>"; tbArquivada.InnerHtml += " </tr>"; while (rsListar.Read()) { tbArquivada.InnerHtml += " <tr>"; tbArquivada.InnerHtml += " <td>" + rsListar["CDO_TAREFA"] + "</td>"; tbArquivada.InnerHtml += " <td>" + rsListar["CDO_DATA"] + "</td>"; tbArquivada.InnerHtml += " <td>" + rsListar["TOTAL_RELATOS"] + "</td>"; tbArquivada.InnerHtml += " <td><a href=\"/tarefa-arquivada/" + rsListar["CDO_ID"] + "\">Visualizar Proposta</a></td>"; //tbArquivada.InnerHtml += " <td>Visualizar Tarefa</td>"; tbArquivada.InnerHtml += " </tr>"; } tbArquivada.InnerHtml += "</table>"; } else { tbAtiva.InnerHtml += "</table>"; rsListar.NextResult(); if (rsListar.HasRows) { tbArquivada.InnerHtml += "<table class=\"tabela2\">"; tbArquivada.InnerHtml += " <tr>"; tbArquivada.InnerHtml += " <th style='min-width: 242px;'>Proposta</th>"; tbArquivada.InnerHtml += " <th style='min-width: 65px;'>Prazo</th>"; tbArquivada.InnerHtml += " <th>Relatos</th>"; tbArquivada.InnerHtml += " <th>Visualizar</th>"; tbArquivada.InnerHtml += " </tr>"; while (rsListar.Read()) { tbArquivada.InnerHtml += " <tr>"; tbArquivada.InnerHtml += " <td>" + rsListar["CDO_TAREFA"] + "</td>"; tbArquivada.InnerHtml += " <td>" + rsListar["CDO_DATA"] + "</td>"; tbArquivada.InnerHtml += " <td>" + rsListar["TOTAL_RELATOS"] + "</td>"; tbArquivada.InnerHtml += " <td><a href=\"/tarefa-arquivada/" + rsListar["CDO_ID"] + "\">Visualizar Proposta</a></td>"; //tbArquivada.InnerHtml += " <td>Visualizar Tarefa</td>"; tbArquivada.InnerHtml += " </tr>"; } tbArquivada.InnerHtml += "</table>"; } } }
protected void Page_Load(object sender, EventArgs e) { if (Request["acao"] == "gravavideo") { gravavideo(); Response.Redirect("galeria-geral.aspx?sucesso=2&alert=Seu video foi enviado com sucesso e passará pelo processo de moderação dos administradores do Projeto Brincadeiras Musicais da Palavra Cantada. Agradecemos a sua participação!"); } switch (Convert.ToInt32(Request["sucesso"])) { case 1: fotodiv.InnerHtml = "<p class='pAvisoGaleria'>Sua foto foi enviada com sucesso e passará pelo processo de moderação dos administradores do Projeto Brincadeiras Musicais da Palavra Cantada. Agradecemos a sua participação!</p>"; fotodiv.InnerHtml += "<button class=\"btn_back up_forum\" style=\"margin-top: 20px; margin-bottom: 20px; cursor: pointer;\" onclick=\"location.href='/galeria-colaborativa'; return false;\">Voltar</button>"; break; case 2: videodiv.InnerHtml = "<p class='pAvisoGaleria'>Seu vídeo foi enviado com sucesso e passará pelo processo de moderação dos administradores do Projeto Brincadeiras Musicais da Palavra Cantada. Agradecemos a sua participação!</p>"; videodiv.InnerHtml += "<button class=\"btn_back up_forum\" style=\"margin-top: 20px; margin-bottom: 20px; cursor: pointer;\" onclick=\"location.href='/galeria-colaborativa'; return false;\">Voltar</button>"; break; default: break; } rsGaleria = objBD.ExecutaSQL("EXEC psGaleriaColaborativa " + Session["redeID"]); if (rsGaleria == null) { throw new Exception(); } if (rsGaleria.HasRows) { while (rsGaleria.Read()) { ulFotos.InnerHtml += "<li><a href=\"/upload/imagens/galeriacolaborativa/" + rsGaleria["COF_IMAGEM"] + "\">" + "<img src=\"/upload/imagens/galeriacolaborativa/thumb-" + rsGaleria["COF_IMAGEM"] + "\" alt=\" " + rsGaleria["COF_LEGENDA"] + "\"></a>" + "<p>:: " + rsGaleria["COF_LEGENDA"] + " ::</p>" + "</li>"; } } rsGaleria.NextResult(); if (rsGaleria.HasRows) { while (rsGaleria.Read()) { ulVideos.InnerHtml += "<li class=\"\" style=\"width: 196px;\"><a href=\"" + rsGaleria["COV_VIDEO_ID"] + "\">" + "<img src=\"http://i.ytimg.com/vi/" + rsGaleria["COV_VIDEO_ID"] + "/mqdefault.jpg\" alt=\"" + rsGaleria["COV_TITULO"] + "\">" + "</a>" + "<p>:: " + rsGaleria["COV_TITULO"] + " ::</p>" + "<span>" + rsGaleria["COV_DESCRICAO"].ToString() + "</span>" + "</li>"; } } rsGaleria.NextResult(); if (rsGaleria.HasRows) { rsGaleria.Read(); nomerede1.InnerText = rsGaleria["RED_TITULO"].ToString(); nomerede2.InnerText = rsGaleria["RED_TITULO"].ToString(); } }
private OleDbDataReader ExecuteReaderInternal(CommandBehavior behavior, string method) { OleDbDataReader dataReader = null; OleDbException previous = null; int num2 = 0; try { object obj2; int num; this.ValidateConnectionAndTransaction(method); if ((CommandBehavior.SingleRow & behavior) != CommandBehavior.Default) { behavior |= CommandBehavior.SingleResult; } switch (this.CommandType) { case ((System.Data.CommandType) 0): case System.Data.CommandType.Text: case System.Data.CommandType.StoredProcedure: num = this.ExecuteCommand(behavior, out obj2); break; case System.Data.CommandType.TableDirect: num = this.ExecuteTableDirect(behavior, out obj2); break; default: throw ADP.InvalidCommandType(this.CommandType); } if (this._executeQuery) { try { dataReader = new OleDbDataReader(this._connection, this, 0, this.commandBehavior); switch (num) { case 0: dataReader.InitializeIMultipleResults(obj2); dataReader.NextResult(); break; case 1: dataReader.InitializeIRowset(obj2, ChapterHandle.DB_NULL_HCHAPTER, this._recordsAffected); dataReader.BuildMetaInfo(); dataReader.HasRowsRead(); break; case 2: dataReader.InitializeIRow(obj2, this._recordsAffected); dataReader.BuildMetaInfo(); break; case 3: if (!this._isPrepared) { this.PrepareCommandText(2); } OleDbDataReader.GenerateSchemaTable(dataReader, this._icommandText, behavior); break; } obj2 = null; this._hasDataReader = true; this._connection.AddWeakReference(dataReader, 2); num2 = 1; return dataReader; } finally { if (1 != num2) { this.canceling = true; if (dataReader != null) { dataReader.Dispose(); dataReader = null; } } } } try { if (num == 0) { UnsafeNativeMethods.IMultipleResults imultipleResults = (UnsafeNativeMethods.IMultipleResults) obj2; previous = OleDbDataReader.NextResults(imultipleResults, this._connection, this, out this._recordsAffected); } } finally { try { if (obj2 != null) { Marshal.ReleaseComObject(obj2); obj2 = null; } this.CloseFromDataReader(this.ParameterBindings); } catch (Exception exception3) { if (!ADP.IsCatchableExceptionType(exception3)) { throw; } if (previous == null) { throw; } previous = new OleDbException(previous, exception3); } } } finally { try { if ((dataReader == null) && (1 != num2)) { this.ParameterCleanup(); } } catch (Exception exception2) { if (!ADP.IsCatchableExceptionType(exception2)) { throw; } if (previous == null) { throw; } previous = new OleDbException(previous, exception2); } if (previous != null) { throw previous; } } return dataReader; }
private OleDbDataReader ExecuteReaderInternal(CommandBehavior behavior, string method) { OleDbDataReader dataReader = null; OleDbException previous = null; int num2 = 0; try { object obj2; int num; this.ValidateConnectionAndTransaction(method); if ((CommandBehavior.SingleRow & behavior) != CommandBehavior.Default) { behavior |= CommandBehavior.SingleResult; } switch (this.CommandType) { case ((System.Data.CommandType) 0): case System.Data.CommandType.Text: case System.Data.CommandType.StoredProcedure: num = this.ExecuteCommand(behavior, out obj2); break; case System.Data.CommandType.TableDirect: num = this.ExecuteTableDirect(behavior, out obj2); break; default: throw ADP.InvalidCommandType(this.CommandType); } if (this._executeQuery) { try { dataReader = new OleDbDataReader(this._connection, this, 0, this.commandBehavior); switch (num) { case 0: dataReader.InitializeIMultipleResults(obj2); dataReader.NextResult(); break; case 1: dataReader.InitializeIRowset(obj2, ChapterHandle.DB_NULL_HCHAPTER, this._recordsAffected); dataReader.BuildMetaInfo(); dataReader.HasRowsRead(); break; case 2: dataReader.InitializeIRow(obj2, this._recordsAffected); dataReader.BuildMetaInfo(); break; case 3: if (!this._isPrepared) { this.PrepareCommandText(2); } OleDbDataReader.GenerateSchemaTable(dataReader, this._icommandText, behavior); break; } obj2 = null; this._hasDataReader = true; this._connection.AddWeakReference(dataReader, 2); num2 = 1; return(dataReader); } finally { if (1 != num2) { this.canceling = true; if (dataReader != null) { dataReader.Dispose(); dataReader = null; } } } } try { if (num == 0) { UnsafeNativeMethods.IMultipleResults imultipleResults = (UnsafeNativeMethods.IMultipleResults)obj2; previous = OleDbDataReader.NextResults(imultipleResults, this._connection, this, out this._recordsAffected); } } finally { try { if (obj2 != null) { Marshal.ReleaseComObject(obj2); obj2 = null; } this.CloseFromDataReader(this.ParameterBindings); } catch (Exception exception3) { if (!ADP.IsCatchableExceptionType(exception3)) { throw; } if (previous == null) { throw; } previous = new OleDbException(previous, exception3); } } } finally { try { if ((dataReader == null) && (1 != num2)) { this.ParameterCleanup(); } } catch (Exception exception2) { if (!ADP.IsCatchableExceptionType(exception2)) { throw; } if (previous == null) { throw; } previous = new OleDbException(previous, exception2); } if (previous != null) { throw previous; } } return(dataReader); }
public DataSet DataReader2DataSet ( OleDbDataReader reader ) { DataSet dataSet = new DataSet (); do { // Create new data table DataTable schemaTable = reader.GetSchemaTable (); DataTable dataTable = new DataTable (); if ( schemaTable != null ) { // A query returning records was executed for ( int i = 0 ; i < schemaTable.Rows.Count ; i++ ) { DataRow dataRow = schemaTable.Rows [ i ]; // Create a column name that is unique in the data table string columnName = ( string ) dataRow [ "ColumnName" ]; // Add the column definition to the data table DataColumn column = new DataColumn ( columnName , ( Type ) dataRow [ "DataType" ] ); dataTable.Columns.Add ( column ); } dataSet.Tables.Add ( dataTable ); // Fill the data table we just created while ( reader.Read () ) { DataRow dataRow = dataTable.NewRow (); for ( int i = 0 ; i < reader.FieldCount ; i++ ) dataRow [ i ] = reader.GetValue ( i ); dataTable.Rows.Add ( dataRow ); } } else { // No records were returned DataColumn column = new DataColumn ( "RowsAffected" ); dataTable.Columns.Add ( column ); dataSet.Tables.Add ( dataTable ); DataRow dataRow = dataTable.NewRow (); dataRow [ 0 ] = reader.RecordsAffected; dataTable.Rows.Add ( dataRow ); } } while ( reader.NextResult () ); return dataSet; }
public void AddFromReader(OleDbDataReader reader, bool addSpace) { do { if (reader.HasRows) { HtmlGenericControl resultSetDiv = CreateDiv("ResultSet"); _container.Controls.Add(resultSetDiv); int headerColumn = reader.GetColumnIndex("Header"); string lastHeader = null; int subheaderColumn = reader.GetColumnIndex("Subheader"); string lastSubHeader = null; int lastColumn = reader.FieldCount - 1; for (int i = 0; i < 2; ++i) { if (lastColumn == headerColumn || lastColumn == subheaderColumn) { lastColumn -= 1; } } while (reader.Read()) { HtmlGenericControl rowSetDiv = CreateDiv("RowSet"); resultSetDiv.Controls.Add(rowSetDiv); bool headerAdded = false; bool subheaderAdded = false; if (headerColumn >= 0 && !reader.IsDBNull(headerColumn)) { string header = reader.GetValue(headerColumn).ToString(); headerAdded = header != lastHeader; if (headerAdded) { HtmlGenericControl headerDiv = CreateDiv("RowSetHeader", header); rowSetDiv.Controls.Add(headerDiv); lastHeader = header; } } if (subheaderColumn >= 0 && !reader.IsDBNull(subheaderColumn)) { string subheader = reader.GetValue(subheaderColumn).ToString(); subheaderAdded = subheader != lastSubHeader; if (subheaderAdded) { if (headerAdded && addSpace) { AddSpace(rowSetDiv, "Space2"); } HtmlGenericControl subheaderDiv = CreateDiv("RowSetSubheader", subheader); rowSetDiv.Controls.Add(subheaderDiv); lastSubHeader = subheader; } } if (lastColumn < 0) { if (addSpace) { AddSpace(rowSetDiv, "Space2"); } } else { if ((headerAdded || subheaderAdded) && addSpace) { AddSpace(rowSetDiv, "Space2"); } for (int i = 0; i < reader.FieldCount; ++i) { if (i != headerColumn && i != subheaderColumn) { HtmlGenericControl valueSetDiv = CreateDiv("ValueSet"); rowSetDiv.Controls.Add(valueSetDiv); HtmlGenericControl labelDiv = CreateDiv("Label", reader.GetName(i)); valueSetDiv.Controls.Add(labelDiv); if (addSpace) { HtmlGenericControl separatorDiv = CreateDiv("Separator", ""); valueSetDiv.Controls.Add(separatorDiv); } HtmlGenericControl valueDiv = CreateValueDiv(!reader.IsDBNull(i) ? reader.GetValue(i) : null); valueSetDiv.Controls.Add(valueDiv); if (i < lastColumn && addSpace) { AddSpace(rowSetDiv, "Space1"); } } } if (addSpace) { AddSpace(rowSetDiv, "Space4"); } } } } } while (reader.NextResult()); }
public new OleDbDataReader ExecuteReader (CommandBehavior behavior) { ArrayList results = new ArrayList (); IntPtr rs_list; GdaList glist_node; if (connection.State != ConnectionState.Open) throw new InvalidOperationException ("State != Open"); this.behavior = behavior; IntPtr gdaConnection = connection.GdaConnection; IntPtr gdaParameterList = parameters.GdaParameterList; /* execute the command */ SetupGdaCommand (); rs_list = libgda.gda_connection_execute_command ( gdaConnection, gdaCommand, gdaParameterList); if (rs_list != IntPtr.Zero) { glist_node = (GdaList) Marshal.PtrToStructure (rs_list, typeof (GdaList)); while (glist_node != null) { results.Add (glist_node.data); if (glist_node.next == IntPtr.Zero) break; glist_node = (GdaList) Marshal.PtrToStructure (glist_node.next, typeof (GdaList)); } dataReader = new OleDbDataReader (this, results); dataReader.NextResult (); } return dataReader; }