<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://forums.asp.net/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Search results matching tag 'Error'</title><link>http://forums.asp.net/search/SearchResults.aspx?q=&amp;tag=Error&amp;orTags=0&amp;o=DateDescending</link><description>Search results matching tag 'Error'</description><dc:language>en-US</dc:language><generator>CommunityServer 2007 SP1 (Build: 20510.895)</generator><item><title>URLRewriter.net error.</title><link>http://forums.asp.net/thread/3562289.aspx</link><pubDate>Sun, 13 Dec 2009 05:00:00 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:3562289</guid><dc:creator>SureshMali</dc:creator><description>&lt;p&gt;Hi Friends, &lt;/p&gt;
&lt;p&gt;I am getting this error:&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Class &amp;#39;TourNameToIDTransform&amp;#39; must implement &amp;#39;Function ApplyTransform(input As String) As String&amp;#39; for interface &amp;#39;Intelligencia.UrlRewriter.IRewriteTransform&amp;#39;.&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;My code is as below:&lt;br /&gt;&lt;/p&gt;&lt;pre class="vb.net" name="code"&gt;Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols
Imports System.ComponentModel
Imports Intelligencia.UrlRewriter

Namespace CustomTransforms
    &amp;#39;&amp;#39;&amp;#39; &amp;lt;summary&amp;gt; 
    &amp;#39;&amp;#39;&amp;#39; Convert a car name into its ID value 
    &amp;#39;&amp;#39;&amp;#39; &amp;lt;/summary&amp;gt; 
    Public Class TourNameToIDTransform &amp;#39;CarNameToIdTransform
        Implements IRewriteTransform
        &amp;#39;&amp;#39;&amp;#39; &amp;lt;summary&amp;gt; 
        &amp;#39;&amp;#39;&amp;#39; The name you reference this custom transform by 
        &amp;#39;&amp;#39;&amp;#39; &amp;lt;/summary&amp;gt; 
        Public ReadOnly Property Name() As String
            Get
                Return &amp;quot;TourNameToIDTransform&amp;quot; &amp;#39;CarNameToIdTransform
            End Get
        End Property

        &amp;#39;&amp;#39;&amp;#39; &amp;lt;summary&amp;gt; 
        &amp;#39;&amp;#39;&amp;#39; Apply the transform 
        &amp;#39;&amp;#39;&amp;#39; &amp;lt;/summary&amp;gt; 
        &amp;#39;&amp;#39;&amp;#39; &amp;lt;param name=&amp;quot;input&amp;quot;&amp;gt;&amp;lt;/param&amp;gt; 
        &amp;#39;&amp;#39;&amp;#39; &amp;lt;returns&amp;gt;&amp;lt;/returns&amp;gt; 
        Public Function ApplyTransform(ByVal input As String) As String
            &amp;#39; Clean up the input 
            input = input.Replace(&amp;quot;_&amp;quot;, &amp;quot; &amp;quot;)
            input = HttpUtility.UrlDecode(input)

            &amp;#39; Look up the car id from a data store 
            Dim TourID As Integer = TourNameToIDTransform(input)

            &amp;#39; return the value back to the URL 
            Return TourID.ToString()
        End Function

        Public Function TourNameToIDTransform(ByVal TourName As String) As Integer
            Dim TourID As Integer = 0

            &amp;#39; you would do a real lookup here if this was a production app 
            If TourName.Equals(&amp;quot;Ford Fiesta&amp;quot;) Then
                TourID = 1234
            End If

            Return TourID
        End Function
    End Class
End Namespace&lt;/pre&gt;
&lt;p&gt;&lt;br /&gt;&amp;nbsp;Somebody please help.. I am badly in need of this. Thanks&lt;/p&gt;</description></item><item><title>Re: Control not seen in code behind.</title><link>http://forums.asp.net/thread/3561794.aspx</link><pubDate>Sat, 12 Dec 2009 05:00:00 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:3561794</guid><dc:creator>gershwin</dc:creator><description>&lt;p&gt;Thanks foryour replies.&lt;/p&gt;&lt;p&gt;Are you suggesting reinstalling Visual Studio? I don&amp;#39;t mind doing that but here are some more interesting happenings:&lt;/p&gt;&lt;p&gt;1. All of the controls in my primary project that existed prior to the problem &lt;b&gt;&lt;i&gt;are&lt;/i&gt;&lt;/b&gt; seen in code behind (and intellisense) and work as designed when I run the project. However, when I click on an &lt;u&gt;existing&lt;/u&gt; control in the designer, I am &lt;i&gt;&lt;b&gt;not&lt;/b&gt;&lt;/i&gt; sent to the code behind page (no pop up error, just no response).&lt;br /&gt;&lt;/p&gt;&lt;p&gt;2. If I add a &lt;u&gt;new&lt;/u&gt; control to the page and double click it, it pops up &amp;quot;cannot complete the action&amp;quot;, I am &lt;i&gt;&lt;b&gt;not&lt;/b&gt;&lt;/i&gt; sent to the code behind for the event, and it is &lt;b&gt;&lt;i&gt;not&lt;/i&gt;&lt;/b&gt; seen in intellisense.&lt;/p&gt;&lt;p&gt;3. Prior to the problem I opened a few starter kits to get some ideas for the project. If I open a starter kit now, I can add a control and it works fine.&lt;/p&gt;&lt;p&gt;4. However, if I start a &lt;u&gt;new project&lt;/u&gt; and add one control to a blank form, it gives me the &amp;quot;cannot complete action&amp;quot; popup and is not seen in code behind, just like in my primary project.&lt;br /&gt;&lt;/p&gt;&lt;p&gt;I am wondering if it is a corrupt vs dll or if it is just a setting or a reference in vs that is causing the problem.&lt;/p&gt;&lt;p&gt;Thanks for all of your help.&lt;br /&gt;&lt;/p&gt;</description></item><item><title>Arithmetic overflow error converting varchar to data type numeric</title><link>http://forums.asp.net/thread/3548404.aspx</link><pubDate>Fri, 04 Dec 2009 05:00:00 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:3548404</guid><dc:creator>jfierst</dc:creator><description>&lt;p&gt;&lt;strong&gt;I am getting this error, and I am not sure why.&amp;nbsp; Can anyone enlighten me as to how to fix my issue I only see every once in a while?&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~&lt;/p&gt;
&lt;p&gt;System.Data.SqlClient.SqlException: Arithmetic overflow error converting varchar to data type numeric.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.SqlClient.SqlDataReader.HasMoreRows()&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.SqlClient.SqlDataReader.Read()&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at Members.Button8_Click(Object sender, EventArgs e) in c:\websites\BTAA\members.aspx.vb:line 598&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Web.UI.WebControls.Button.OnClick(EventArgs e)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;nbsp; at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)&lt;/p&gt;
&lt;p&gt;&lt;font size="2"&gt;
&lt;p&gt;mySelectCommand.Connection = myConn&lt;/p&gt;
&lt;p&gt;mySelectCommand.CommandText = &lt;/p&gt;&lt;/font&gt;&lt;font color="#a31515" size="2"&gt;&lt;font color="#a31515" size="2"&gt;&amp;quot;SELECT TOP 1 [RunningTotal] FROM [RunningTotal] WHERE ([R_TR_CODE] = &amp;quot;&lt;/font&gt;&lt;/font&gt;&lt;font size="2"&gt; &amp;amp; TransNumLabel.Text.ToString &amp;amp; &lt;/font&gt;&lt;font color="#a31515" size="2"&gt;&lt;font color="#a31515" size="2"&gt;&amp;quot;)&amp;quot;&lt;/font&gt;&lt;/font&gt;&lt;font size="2"&gt; 
&lt;p&gt;myAdapter.SelectCommand = mySelectCommand&lt;/p&gt;
&lt;p&gt;myAdapter.Fill(myDataset)&lt;/p&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3" face="Consolas"&gt;System.Data.SqlClient.SqlException: Arithmetic overflow error converting varchar to data type numeric.&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.SqlClient.SqlDataReader.HasMoreRows()&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.SqlClient.SqlDataReader.Read()&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at Members.Button8_Click(Object sender, EventArgs e) in c:\websites\BTAA\members.aspx.vb:line 598&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Web.UI.WebControls.Button.OnClick(EventArgs e)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p style="MARGIN:0in 0in 0pt;" class="MsoPlainText"&gt;&lt;font size="3"&gt;&lt;font face="Consolas"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="FONT-FAMILY:&amp;#39;Calibri&amp;#39;, &amp;#39;sans-serif&amp;#39;;FONT-SIZE:11pt;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"&gt;&lt;span style="mso-spacerun:yes;"&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) &lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="FONT-FAMILY:&amp;#39;Calibri&amp;#39;, &amp;#39;sans-serif&amp;#39;;FONT-SIZE:11pt;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"&gt;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="FONT-FAMILY:&amp;#39;Calibri&amp;#39;, &amp;#39;sans-serif&amp;#39;;FONT-SIZE:11pt;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"&gt;&lt;strong&gt;Here is the code around 598:&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;mySelectCommand.Connection = myConn&lt;/p&gt;
&lt;p&gt;mySelectCommand.CommandText = &lt;/p&gt;
&lt;p&gt;&amp;quot;SELECT TOP 1 [RunningTotal] FROM [RunningTotal] WHERE ([R_TR_CODE] = &amp;quot; &amp;amp; TransNumLabel.Text.ToString &amp;amp; &amp;quot;)&amp;quot; &lt;/p&gt;
&lt;p&gt;myAdapter.SelectCommand = mySelectCommand&lt;/p&gt;
&lt;p&gt;myAdapter.Fill(myDataset)&lt;/p&gt;
&lt;p&gt;&lt;span style="FONT-FAMILY:&amp;#39;Calibri&amp;#39;, &amp;#39;sans-serif&amp;#39;;FONT-SIZE:11pt;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"&gt;~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="FONT-FAMILY:&amp;#39;Calibri&amp;#39;, &amp;#39;sans-serif&amp;#39;;FONT-SIZE:11pt;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"&gt;&lt;strong&gt;The running total&amp;nbsp; is a&amp;nbsp;view which is a sum:&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="FONT-FAMILY:&amp;#39;Calibri&amp;#39;, &amp;#39;sans-serif&amp;#39;;FONT-SIZE:11pt;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"&gt;&lt;font size="2"&gt;SELECT&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; R_TR_CODE, SUM(R_FEE) AS RunningTotal&lt;br /&gt;FROM&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; dbo.REGISTRATION&lt;br /&gt;GROUP BY R_TR_CODE&lt;/font&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;span style="FONT-FAMILY:&amp;#39;Calibri&amp;#39;, &amp;#39;sans-serif&amp;#39;;FONT-SIZE:11pt;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:&amp;#39;Times New Roman&amp;#39;;mso-bidi-theme-font:minor-bidi;mso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA;"&gt;&amp;nbsp;of my R_FEE field which is noted as &lt;font size="2"&gt;decimal(18, 2)&lt;/font&gt;&lt;/span&gt;&lt;/p&gt;
&lt;p&gt;&lt;font size="2"&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/font&gt;</description></item><item><title>i want to display the error information in my Error Page</title><link>http://forums.asp.net/thread/3545289.aspx</link><pubDate>Thu, 03 Dec 2009 05:00:00 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:3545289</guid><dc:creator>Sathishj1987</dc:creator><description>&lt;p&gt;&amp;nbsp;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;hi,,&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;I just redirecting the error that is being caught to a ErrorPage say &amp;quot;ErrorPage.aspx&amp;quot; by using the web.comfig file&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&amp;lt;customErrors mode=&amp;quot;On&amp;quot; defaultRedirect=&amp;quot;ErrorPage.aspx&amp;quot;&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/customErrors&amp;gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;The problem is that when the ErrorPage.aspx is loaded i just&amp;nbsp; want to display what type of error in that page&lt;/p&gt;&lt;p&gt;If its&lt;b&gt; 404 &lt;/b&gt;means i should get that Error code, other Infromation and&lt;/p&gt;&lt;p&gt; display the information,code in that label or some other control&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;how can i do this&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;</description></item><item><title>DataBinder Failed Solution</title><link>http://forums.asp.net/thread/3546258.aspx</link><pubDate>Thu, 03 Dec 2009 05:00:00 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:3546258</guid><dc:creator>herman_tho</dc:creator><description>&lt;p&gt;&amp;nbsp;Hi guys,&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;I have a simple question, I&amp;#39;m Trying to parse the Variable to the Grid View the system work fine.&lt;/p&gt;&lt;p&gt;But sometimes the code able to retrieve n bind all the data and sometimes the code is bind half record which other half is empty.&lt;/p&gt;&lt;p&gt;I feel that this could be&amp;nbsp;connection disconnect from the server or the VB.Net Code behind not Runing.&lt;/p&gt;&lt;p&gt;I&amp;#39;m using the Item Template.&lt;/p&gt;&lt;p&gt;&amp;lt;itemTemplate&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;a href=&amp;quot;test.aspx?ID=&amp;lt;%#DataBinder.Eval(Container.DataItem,&amp;quot;x&amp;quot;)%&amp;gt;&amp;lt;/a&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/ItemTemplate&amp;gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;</description></item><item><title>Sys.InvalidOperationException: Could not find UpdatePanel</title><link>http://forums.asp.net/thread/3544038.aspx</link><pubDate>Wed, 02 Dec 2009 05:00:00 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:3544038</guid><dc:creator>vitokogvy</dc:creator><description>&lt;p&gt;Well im posting what i got, when i try to select a date from a control, well this page has no problems when i open it writing the url , but when i open this page from another page, (well this a page when there are workers of an enterprise), so when i want to see&amp;nbsp; and modify a worker&amp;#39;s birthday, i got that error.&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;img src="http://vitokobain.googlepages.com/1.jpg" alt="" /&gt;&lt;img src="http://vitokobain.googlepages.com/2.jpg" alt="" /&gt;&lt;br /&gt;&lt;/p&gt;</description></item><item><title>section drop down list with go button</title><link>http://forums.asp.net/thread/3530531.aspx</link><pubDate>Tue, 24 Nov 2009 05:00:00 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:3530531</guid><dc:creator>joepitt91</dc:creator><description>&lt;p&gt;could anyone tell me what i have got wrong here?&lt;/p&gt;
&lt;p&gt;ok i cant insert code :(&lt;/p&gt;
&lt;p&gt;this is the buttons onclientclick code.&lt;/p&gt;
&lt;p&gt;&amp;nbsp;onclientclick=&amp;quot;document.location.href = lstSection.SelectedValue; return false&amp;quot;&lt;/p&gt;
&lt;p&gt;the browser goes to: localhost:51985/undefined&lt;/p&gt;
&lt;p&gt;&lt;span&gt;&amp;nbsp; 
&lt;h1&gt;Server Error in &amp;#39;/&amp;#39; Application. 
&lt;hr /&gt;
&lt;/h1&gt;
&lt;h2&gt;&lt;i&gt;The resource cannot be found.&lt;/i&gt; &lt;/h2&gt;&lt;/span&gt;&lt;font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "&gt;&lt;b&gt;Description: &lt;/b&gt;HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. &amp;nbsp;Please review the following URL and make sure that it is spelled correctly. &lt;br /&gt;&lt;br /&gt;&lt;b&gt;Requested URL: &lt;/b&gt;/undefined&lt;/font&gt;&lt;/p&gt;</description></item><item><title>Re: Google Maps via ASP.NET / SQL Server Tutorial</title><link>http://forums.asp.net/thread/3485838.aspx</link><pubDate>Fri, 30 Oct 2009 04:00:00 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:3485838</guid><dc:creator>ice_boy-20</dc:creator><description>&lt;p&gt;hi! in this code i have a error: &lt;/p&gt;&lt;h2 style="font-family:Verdana;font-weight:normal;font-size:14pt;color:maroon;"&gt;&lt;i&gt;Using themed css files requires a header control on the page. (e.g. &amp;lt;head runat=&amp;quot;server&amp;quot; /&amp;gt;).&lt;/i&gt;&lt;/h2&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;i&gt;and i just have put in the code the &amp;quot;Runat=&amp;quot;server&amp;quot;, and the error are the same.&lt;/i&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;i&gt;Sorry for my english but i&amp;#39;am portuguese.&lt;/i&gt;&lt;/p&gt;&lt;p&gt;&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;/p&gt;</description></item><item><title>DetailsView Loading question</title><link>http://forums.asp.net/thread/3485991.aspx</link><pubDate>Fri, 30 Oct 2009 04:00:00 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:3485991</guid><dc:creator>jh2009</dc:creator><description>&lt;pre class="c-sharp" name="code"&gt;On my web page, I have 2 DetailsView that are loaded by separate SqlDataSource controls.&amp;nbsp; In the page_load, one detailview is hidden and one shown depending on if you are an admin or not.&amp;nbsp; My clients have been getting intermitent 500 Server errors from IIS on loading this page.&amp;nbsp; Once the error fires, that particular page cannot be accessed anymore by anyone.&amp;nbsp; I&amp;#39;m wondering if the server is really busy and loading the 2 detailsview, maybe making them visible or insvisible while they are loading might cause a server error.&amp;nbsp;&amp;nbsp; My network folks have isolated this page in particular and it looks like the database call isn&amp;#39;t even making it to the database.&amp;nbsp; It appears to be getting into a black hole at the IIS server redirect to this page. Any help would be appreciated!  Julie&lt;/pre&gt;&lt;pre class="c-sharp" name="code"&gt;&amp;nbsp;&lt;/pre&gt;&lt;pre class="c-sharp" name="code"&gt;&amp;nbsp;&lt;/pre&gt;&lt;pre class="c-sharp" name="code"&gt;&amp;nbsp;&lt;/pre&gt;&lt;pre class="c-sharp" name="code"&gt;Code:&lt;/pre&gt;&lt;pre class="c-sharp" name="code"&gt;    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (!(Session[&amp;quot;Msg&amp;quot;] == null))
            {
                lblMsg.Text = Session[&amp;quot;Msg&amp;quot;].ToString();
            }
        }
        String strURL = &amp;quot;&amp;quot;;
        if (!(Request.UrlReferrer  == null))
        {
            strURL = (String)Request.UrlReferrer.ToString();
            if (!(strURL.Contains(&amp;quot;SearchResultsDetail&amp;quot;)))
            {
                if ((strURL.Contains(&amp;quot;SearchResults&amp;quot;)) || (strURL.Contains(&amp;quot;SearchResultsLOB&amp;quot;)) || (strURL.Contains(&amp;quot;ResultsByRecordClass&amp;quot;)) || (strURL.Contains(&amp;quot;AdvancedSearchResults&amp;quot;)) || (strURL.Contains(&amp;quot;ResultsByKeyword&amp;quot;)) || (strURL.Contains(&amp;quot;ResultsByRecordName&amp;quot;)))
                {
                    Session[&amp;quot;PostBackURL&amp;quot;] = strURL;
                }
            }
           
        }
        if ((Boolean)Session[&amp;quot;IsAdmin&amp;quot;] == false)
        {
            DetailsView1.Visible = false;
            DetailsView2.Visible = true;
            btnEdit.Visible = false;
        }
        else
        {
            DetailsView1.Visible = true;
            DetailsView2.Visible = false;
            btnEdit.Visible = true;
        }
        //btnBack.PostBackUrl = Session[&amp;quot;PostBackURL&amp;quot;].ToString();
    }

    protected void DetailsView1_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
    {

    }

    protected void btnEdit_Click(object sender, EventArgs e)
    {
        Response.Redirect(&amp;quot;EditRecordClass.aspx?recordID=&amp;quot; + Session[&amp;quot;RecordID&amp;quot;]);
    }
    protected void btnBack_Click(object sender, EventArgs e)
    {
        Response.Redirect(Session[&amp;quot;PostBackURL&amp;quot;].ToString());
    }
&lt;/pre&gt;
&lt;p&gt;&lt;br /&gt;&lt;span class="" style="FONT-SIZE:x-small;COLOR:#a31515;FONT-FAMILY:;"&gt;&lt;span class="" style="FONT-SIZE:x-small;COLOR:#a31515;FONT-FAMILY:;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;</description></item><item><title>&amp;quot;Invalid length parameter passed to the substring function&amp;quot; in my ASPX page</title><link>http://forums.asp.net/thread/3480064.aspx</link><pubDate>Tue, 27 Oct 2009 04:00:00 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:3480064</guid><dc:creator>gomaz</dc:creator><description>&lt;p&gt;I got the following error in my aspx page. &amp;quot;Invalid length parameter passed to the substring function. in my ASPX page&amp;quot;&lt;br /&gt;&lt;/p&gt;&lt;p&gt;While I am Edit the Gridview I am getting this error.&lt;/p&gt;&lt;p&gt;I dont have any SPs which is using SUBSTRING&amp;nbsp; function with my page. But while clicking the edit link on the gridview I am getting this error.&lt;/p&gt;&lt;p&gt;This is happening in page_load event. Worst thing is I couldnt catch this error message using the try catch block.&lt;/p&gt;&lt;p&gt;After page load this is being generated.&lt;/p&gt;&lt;p&gt;help needed...&lt;br /&gt;&lt;/p&gt;&lt;p&gt;&lt;br /&gt;&lt;/p&gt;</description></item></channel></rss>