Search results for query: *

Thank you for confirming that it was data error! Wow, after analyzing the data I figured it out! On my forms I was not validating the dates properly, so some how three dates were passed as 02/29/2007, 02/30/2008, which are not valid! I have three textboxes each for MM/DD/YYYY, I guess before I...

I have this statement that I need to execute: DELETE FROM callcenter..tRecipQueue WHERE DATEDIFF(dd, expiration_date, GetDate()) > 368 Of course it doesn't work because expiration_date is a varchar data type, which contains MM/DD/YYYY value. How can I efficiently cast or convert that data, so...

Hello all! I will try to make some sense of this as best as possible. I have a page that contains a form and a few asp controls. I also have an iFrame that points to a simple aspx page with a RadioListButton, which loads images from the server dynamically. what I would like to do is have the...

If (Not Page.IsPostBack) Then Const IMAGE_DIRECTORY As String = "/homepage/Images/Articles/" 'Dim pics As ArrayList = New ArrayList() Dim s As String, html As String Dim value As String For Each s In Directory.GetFiles(Server.MapPath(IMAGE_DIRECTORY), "*.jpg") html = "<img width=50 height=50...

Hello all: I am trying to have an array of images in a RadioButtonList, which is working, but I need to set the values (Image file names) to each item within the RadioButtonList, but I am having some difficulties. I have this so far: ASPX: < asp:RadioButtonList ID="radiolist1" runat="server"...

Any tips on this? I set my control to control1.Focus(), but when the page is posted back, it doesnt set focus? Do I have to use some javascrip?

Hello: I'm not sure where to start, but I have this problem I ran into: I have a CheckBoxList, which I loop through each item in the list and then send the string value to a table. For Each li In view_description.Items If li.Selected = True Then ListBoxItems = ListBoxItems & li.Value & ","...

Ok, someone helped me on this issue. It is better to use a placeholder control instead to avoid the child controls.

Hello: I forgot what to do in a case like this. I have a SqlDataSource control within a label and I want to allow auto sorting, but when I click on the sort link the page comes back with: The SqlDataSource control 'sqlViewIncompleteForms' does not have a naming container. Ensure that the...

Fixed, I removed visible=false off the controls and cleaned up the vb code.

Ok, I figured it out, sloppy coding, I don't need this as is: <asp:SqlDataSource ID="sqlGetMLSByCity" runat="server" ProviderName="System.Data.SqlClient" ConnectionString="<%$ AppSettings:connectionstring %>"> <SelectParameters> <asp:ControlParameter ControlID="outside_assoc_cities"...

Hello: I am having a little issue with an error that is frustrating me. I have a SqlDataSource within an asp:label control and also have a two dropdownlists inside that asp:label control also. When I select from the first dropdownlist, it should enable the second dropdownlist with the populated...

Hello: Normally when you received this message is it coming from the db, or the code itself? Codebehind: Sub Calendar1_DayRender(ByVal sender As Object, ByVal e As DayRenderEventArgs) 'Dim calid As Integer = CInt(Page.Request.QueryString("calid")) Dim calid As String = 0 If...

I am having some difficulties with this. I read somewhere to use this: OnClientClick="window.document.forms[0].target='_blank';" PostBackUrl = "/_MembersOnly/MemberProfile/EditProfileRedirect.asp" which works great, but when I close EditProfileRedirect.asp and then click on another link on...

Hello all! I am in a delima here. I have a membersonly section that our users log into. I am passing a tokenkey to verify the session and to prevent others from hacking, sharing, ect info. I am setting the tokenkey to a session.item("sesTokenKey") in the codebehind. Now we created a page in...

I was doing some reading and it looks like I may need to use SqlDataSourceStatusEventArgs for add the output to a control, variable, ect?

Hello: I have come to a tricky part of my webproject. This maybe a bit confusing. As of now I have two sqldatasources: <asp:SqlDataSource ID="sqlBrokersAgentsRecips" runat="server" ConnectionString="<%$ AppSettings:connectionstring %>" ProviderName="System.Data.SqlClient"...

I cleaned up the code, perhaps it will make sense. Here is the gridview with the columns bound to my sqldatasource: <asp:GridView ID="RecipHistoryGridView" runat="server" DataSourceID="sqlRecipHistory" AutoGenerateColumns="False" DataKeyNames="recip_id,member_id" DataMember="DefaultView"...

I figured this out. I used a CASE statement in the stored procedure to output the string. Also to make it much more easier on the coding side, I switched to a sqldatasource. Also someone mentioned that you can use RowDataBound event to change the text before the data is bounded.

Hello all: I hope I can make sense of this. I have exhausted all resources, MSDN and books, but cannot understand or figure how I can programmatically change and write out a different value of a datafield? One of my datafields returns an on/off switch, (0,1), so depending on the value, I want to...