Click here to Skip to main content
15,881,852 members
Home / Discussions / C#
   

C#

 
GeneralDate Controlled Content -- Basic C# Pin
yakfreek3-Oct-02 13:58
yakfreek3-Oct-02 13:58 
GeneralRe: Date Controlled Content -- Basic C# Pin
Paul Riley3-Oct-02 15:26
Paul Riley3-Oct-02 15:26 
GeneralRe: Date Controlled Content -- Basic C# Pin
4-Oct-02 5:40
suss4-Oct-02 5:40 
GeneralRe: Date Controlled Content -- Basic C# Pin
Paul Riley4-Oct-02 7:30
Paul Riley4-Oct-02 7:30 
Questionwhat can cause DB_E_ABOTLIMITREACHED? Pin
Anonymous3-Oct-02 5:04
Anonymous3-Oct-02 5:04 
AnswerRe: what can cause DB_E_ABOTLIMITREACHED? Pin
leppie3-Oct-02 9:25
leppie3-Oct-02 9:25 
GeneralRe: what can cause DB_E_ABOTLIMITREACHED? Pin
David Stone3-Oct-02 9:58
sitebuilderDavid Stone3-Oct-02 9:58 
GeneralRe: what can cause DB_E_ABOTLIMITREACHED? Pin
Anonymous4-Oct-02 2:45
Anonymous4-Oct-02 2:45 
Hi,

the code that calls the procedure is:

<br />
DataSet DS = new DataSet();<br />
SqlDataAdapter DAP = new SqlDataAdapter();<br />
SqlCommand cmd = new SqlCommand("P_SPB_CONSULTA_ENTRADA",m_Conexao1.SqlConnection);<br />
			<br />
cmd.CommandType = CommandType.StoredProcedure;<br />
<br />
SqlParameter paramCdPasta = new SqlParameter("@cdPasta", SqlDbType.Int, 4);<br />
paramCdPasta.Value = cdPasta;<br />
cmd.Parameters.Add(paramCdPasta);<br />
<br />
SqlParameter paramNrCgc = new SqlParameter("@nrCgc", SqlDbType.VarChar, 8);<br />
paramNrCgc.Value = nrCgc;<br />
cmd.Parameters.Add(paramNrCgc);<br />
<br />
SqlParameter paramCdStatus = new SqlParameter("@cdStatus", SqlDbType.Int) ;<br />
paramCdStatus.Value = cdStatus;<br />
cmd.Parameters.Add(paramCdStatus);<br />
<br />
SqlParameter paramFlPeriodo = new SqlParameter("@flPeriodo", SqlDbType.Bit);<br />
paramFlPeriodo.Value = flPeriodo;<br />
cmd.Parameters.Add(paramFlPeriodo);<br />
<br />
SqlParameter paramDtDe = new SqlParameter("@dtDe", SqlDbType.VarChar, 20);<br />
paramDtDe.Value = dtDe;<br />
cmd.Parameters.Add(paramDtDe);<br />
<br />
SqlParameter paramDtAte = new SqlParameter("@dtAte", SqlDbType.VarChar, 20);<br />
paramDtAte.Value = dtAte;<br />
cmd.Parameters.Add(paramDtAte);<br />
<br />
SqlParameter paramFlViu = new SqlParameter("@flVisao", SqlDbType.Bit);<br />
paramFlViu.Value = flViu;<br />
cmd.Parameters.Add(paramFlViu);<br />
<br />
SqlParameter paramCdBanco = new SqlParameter("@cdBanco", SqlDbType.Int, 4);<br />
paramCdBanco.Value = cdBanco;<br />
cmd.Parameters.Add(paramCdBanco);<br />
			<br />
SqlParameter paramCdUsuario = new SqlParameter("@cdUsuario", SqlDbType.Int, 4);<br />
paramCdUsuario.Value = cdUsuario;<br />
cmd.Parameters.Add(paramCdUsuario);<br />
<br />
SqlParameter paramCdDominio = new SqlParameter("@cdDominio", SqlDbType.Int, 4);<br />
paramCdDominio.Value = cdDominio;<br />
cmd.Parameters.Add(paramCdDominio);<br />
			<br />
SqlParameter paramCdAgencia = new SqlParameter("@cdAgencia", SqlDbType.Int, 4);<br />
paramCdAgencia.Value = cdAgencia;<br />
cmd.Parameters.Add(paramCdAgencia);<br />
<br />
SqlParameter paramCdAgenciaS = new SqlParameter("@agencias", SqlDbType.VarChar,3000);<br />
paramCdAgenciaS.Value = Session["spb.strAgencias"];<br />
cmd.Parameters.Add(paramCdAgenciaS);<br />
<br />
SqlParameter paramDominios = new SqlParameter("@dominios", SqlDbType.VarChar,3000);<br />
paramDominios.Value = Session["spb.strDominios"];<br />
cmd.Parameters.Add(paramDominios);<br />
<br />
SqlParameter paramValor = new SqlParameter("@valor_de", SqlDbType.Money, 30);<br />
paramValor.Value = valor;<br />
cmd.Parameters.Add(paramValor);<br />
<br />
SqlParameter paramValor2 = new SqlParameter("@valor_ate", SqlDbType.Money, 30);<br />
paramValor2.Value = valor;<br />
cmd.Parameters.Add(paramValor2);<br />
<br />
SqlParameter paramPagatu = new SqlParameter("@pagina", SqlDbType.Int);<br />
paramPagatu.Value = (pagina == 0) ? pagina + 1 : pagina;//(int)DataGrid1.CurrentPageIndex + 1;<br />
cmd.Parameters.Add(paramPagatu);<br />
<br />
SqlParameter paramQuant = new SqlParameter("@quant", SqlDbType.Int);<br />
paramQuant.Value = DataGrid1.PageSize;<br />
cmd.Parameters.Add(paramQuant);<br />
<br />
SqlParameter paramFiltro = new SqlParameter("@filtro", SqlDbType.VarChar);<br />
if (Session["Sort"] == null || Session["Sort"].ToString() == "" || Session["Sort"].ToString().ToLower() == "null")<br />
	Session["Sort"] = "HORA";<br />
if (Session["SortType"] == null || Session["SortType"].ToString() == "" || Session["SortType"].ToString().ToLower() == "null")<br />
	Session["SortType"] = "DESC";<br />
paramFiltro.Value = Session["Sort"].ToString() + " " + Session["SortType"].ToString();<br />
cmd.Parameters.Add(paramFiltro);<br />
<br />
m_Conexao1.SqlAbre(Session["spb.OleDbConString"].ToString());<br />
DAP.SelectCommand = cmd;<br />
DAP.SelectCommand.Connection = m_Conexao1.SqlConnection;<br />
DAP.TableMappings.Add("Table","entradas");<br />
DAP.Fill(DS,"entradas");<br />
m_Conexao1.SqlFecha();<br />
<br />
return DS;


We noticed that sometimes the code works fine, sometimes it return a Timeout expired message.

thanks for any help.

marcelo
GeneralRe: what can cause DB_E_ABOTLIMITREACHED? Pin
leppie4-Oct-02 8:04
leppie4-Oct-02 8:04 
AnswerRe: what can cause DB_E_ABOTLIMITREACHED? Pin
James T. Johnson3-Oct-02 9:55
James T. Johnson3-Oct-02 9:55 
GeneralC# client sending SOAP/HTTP request to Apache serve Pin
Anonymous2-Oct-02 20:28
Anonymous2-Oct-02 20:28 
Generalscroll bars Pin
Anonymous2-Oct-02 19:52
Anonymous2-Oct-02 19:52 
GeneralRe: scroll bars Pin
Stephane Rodriguez.2-Oct-02 20:05
Stephane Rodriguez.2-Oct-02 20:05 
Generalbasic C# question Pin
Anonymous2-Oct-02 19:27
Anonymous2-Oct-02 19:27 
GeneralRe: basic C# question Pin
Stephane Rodriguez.2-Oct-02 19:51
Stephane Rodriguez.2-Oct-02 19:51 
GeneralRe: basic C# question Pin
James T. Johnson3-Oct-02 1:49
James T. Johnson3-Oct-02 1:49 
QuestionCan anyone help with a Shell32 problem? Pin
Furty2-Oct-02 17:58
Furty2-Oct-02 17:58 
AnswerRe: Can anyone help with a Shell32 problem? Pin
Stephane Rodriguez.2-Oct-02 21:28
Stephane Rodriguez.2-Oct-02 21:28 
GeneralRe: Can anyone help with a Shell32 problem? Pin
Furty3-Oct-02 0:18
Furty3-Oct-02 0:18 
GeneralRe: Can anyone help with a Shell32 problem? Pin
Stephane Rodriguez.3-Oct-02 0:22
Stephane Rodriguez.3-Oct-02 0:22 
GeneralRe: Can anyone help with a Shell32 problem? Pin
Furty3-Oct-02 0:54
Furty3-Oct-02 0:54 
GeneralRe: Can anyone help with a Shell32 problem? Pin
Stephane Rodriguez.3-Oct-02 0:59
Stephane Rodriguez.3-Oct-02 0:59 
GeneralVS.NET and ASP.NET Pin
Nick Parker2-Oct-02 17:40
protectorNick Parker2-Oct-02 17:40 
GeneralRe: C# and ASP.NET Pin
David Stone2-Oct-02 17:57
sitebuilderDavid Stone2-Oct-02 17:57 
GeneralRe: C# and ASP.NET Pin
Nick Parker2-Oct-02 18:08
protectorNick Parker2-Oct-02 18:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.