I'm looking for more information on using the Web Service component of SSRS 2008 to generate a PDF from a deployed report. I would like to programmatically email the resulting PDF as an attachment. I can find plenty of information on the Class structure of the various Reporting Services classes but no concrete examples. I am looking for VB.Net code but C# will do as well. Many thanks!

Okay, here's a follow-up. The reason Dynamic IP address might have been enabled on this server is that there is also an instance of SQL-2000 running and that must have been using port 1433. I used the dynamically assigned port # that I found in the registry as the new Static port number for IPALL and restarted the SQL service. I then opened this port in my local firewall. I can connect to the SQL server through the application. I'm not sure if I have completely solved my problem but I have opened up my understanding of the issue. Thanks for the reply Mike. You pushed me in the right direction!

TCP/IP is enabled as well as named pipes. According to the registry, Dynamic ports is enabled which may explain the problem. After messing with this and restarting SQL server (still using Dynamic Ports) I was able to connect. The last Dynamic Port used is 4316. The weird part is that I'm not opening port 4316 on my Firewall and yet the applications can now connect. It seems as though I should configure the server to listen on a static port (or ports).

I may be missing something but Response.Redirect("default.aspx", True) should work. If your default.aspx file is in a different subfolder, for example "Main" you would use... Response.Redirect("../Main/default.aspx", True). Hope this helps.

Any chance that your asp:FileUpload control is placed within an asp:UpdatePanel control? If so, you will need to add some code to accomodate the Ajax postback. Do a search on ASP FileUpload and UpdatePanel and you will find numerous solutions that will work.

I am trying to connect to a SQL-2005 Remote server through several VS-2008 applications. Two are web applications and the other is a VB.Net application. In all cases, the connection fails and the error message in the local Windows Event log is #26, suggesting that possibly the SQL server does not allow remote connections. I know that the remote SQL server is configured correctly because I have gone through all of the steps (Surface Area Configuration, SQL Config, etc). More importantly, the connection through these applications is fine when I disable my local Windows Firewall. On my Firewall I have created Exceptions for both SQL Server and SQL Browser. I have opened TCP port 1433 and UDP port 1434. In all of my research, this is the extent of the solutions provided and so I am at a loss. Turning off the Firewall while debugging is a temporary solution and somewhat safe since my network is protected by a separate Firewall device, however, I would like to resolve this issue. I think there are enough developers out there having this same problem so hopefully someone has resolved it beyond the solutions I have tried. Thanks if you can help!

The closing tag is probably just an error when copying and editing the code in my post. The vendor name is coming from a different database so I can't include the name in the select statement. Excellent question though!

I'm trying to assign a data value in a gridview template during the databind operation. I've replaced the Bind("column_name") with a custom function. In that function, I want to take one of the values from the datatable's rowset (a vendor number) and lookup the name for that vendor returning that as a string. The following code is what I am trying to accomplish.

I guess I haven't been specific enough. The CSS is correct and the CssClass works in another validator control (required text) on the same form within the same

tag. There is no local CSS. All other standard validation controls recognize the CssClass properly. The CustomValidator is the only one that I've found that doesn't recognize the CssClass. Since this is a fairly glaring error I thought others might have come across this.

If you re-read my original question I mentioned that "I have at least one RequiredFieldValidator that has its CssClass set to the same value and it does recognize the styling.". I do have a stylesheet reference with a valid class, and as I said, other validation controls do recognize the CssClass, however, the CustomValidator does not. It seems that someone else must have experiences this.

I have a CustomValidator control in an app and for some reason it seems to ignore the CssClass property. I've tried setting this in design-mode as well as programmaticaly at runtime and it still appears without the styling. I have at least one RequiredFieldValidator that has its CssClass set to the same value and it does recognize the styling. Has anyone else had a problem with this and/or found a workaround?

Thanks for the reply. Actually, I investigated cells (0) through (4) in the debugger. All show empty strings, yet the GridView is populated with the propery data. This seems like it should be a no-brainer so it's really puzzling.

I have the following code in my application... Protected Sub gridTerms_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gridTerms.RowDataBound Dim strMsg As String If (e.Row.RowType = DataControlRowType.DataRow) Then If (e.Row.FindControl("lnkDelete") IsNot Nothing) Then strMsg = "return confirm('Please confirm. Delete payment term " & Trim(e.Row.Cells(2).Text) & "?');" CType(e.Row.FindControl("lnkDelete"), LinkButton).OnClientClick = strMsg End If End If End Sub For some reason the contents of this cell (which is a code) appears blank in the debugger and the JavaScript confirm shows an empty string in the message. The GridView appears fine but even investigating the value of e.Row.Cells(2).Text in the debugger reveals an empty string. Any ideas??