Search results for query: *

Ok, here's how it ended up working out ... For the address portion, I created a function in the codebehind to format the address: Function BuildAddress(ByVal swAddress1 As String, ByVal swAddress2 As String, _ ByVal swAddress3 As String, ByVal swCity As String, ByVal swState As...

A table within the FormView control ... or just plain ol' table instead of FormView? The latter is easier to me, but I wasn't sure if it was most efficient of my choices. Farley Software Solutions http://www.bryantfarley.com

I'm working with a client who has a FormView on an ASP.NET (VB) page, displaying a single record pulled from SQL using a SQLDataSource on the page. Some of the data are address or phone fields that may be blank. If they're blank, there should be no white space/blank lines, and any accompanying...

Fixed! The users whose logins were in the connection strings had to be added to the role aspnet_ChangeNotification_ReceiveNotificationsOnlyAccess. For some reason this was not an issue on the local server. But now I know! Farley Software Solutions http://www.bryantfarley.com

More code as additional info ... Datasource: <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"...

I added caching to my local SQL Server 2005 database, and edited the web.config file as well as any .aspx pages accordingly. Everything worked fine. Then, after uploading to the live server, I now get an error: The 'MyDatabase:tblAppearances' SqlDependency attribute for OutputCache directive...

I added a profile section to web.config, to hold a shopping cart item (as in Wrox Beginning ASP.NET 2.0). It's under <system.web>: <anonymousIdentification enabled="true"/> <profile enabled="true"> <properties> <add name="Cart" serializeAs="Binary"...

I've got a deployment package set up in VS 2005 that has Crystal Reports set as a prerequisite. The install package does include the necessary files. However, CR doesn't install automatically when it's not present. Is there something that I'm overlooking? Are there any special conditions...

Figured it out: crReportDocument.Close

No, unfortunately ... LDB persists until the application itself closes. Neither does this (thought I'd try to "undo" the connection): For Each crTable In crReportDocument.Database.Tables crTable.Dispose() Next

I have a CrystalReportViewer in a form, with data coming from an Access DB. The source report of the CrystalReportViewer is selected from a drop-down list Everything displays fine. However, once the form containing the CrystalReportViewer closes, the Access DB connection remains (.LDB file...

Sorry, didn't mean to have a confusing/misleading topic name :) Thanks for your sugggestion. I learned how to add a button column to a datagridview, and combined that with calling a dialog box to browse for a file name & populate a cell. I'll gladly post the code for anyone who might be interested.

I have a datagridview on a form, containing report names and their "friendly" names. Example: myreport.rpt in one column, "My Report" in another. To avoid problems with spelling etc, I'd like the report name column input to be controlled by a "browse for file" dialog. I'm accustomed to...

Is there a way, as part of Visual Studio deployment, to check for a specific version of a DLL & halt installation if it's not a match? An app I'm developing is an add-on of sorts, and needs to check this. I determined how to get the version of the DLL (GetVersionInfo), but I'm not clear on...

Actually ... yes :) That's an awesome idea! Just tested and it works great. Appreciate all responses!

This does produce a result, thank you! However, I need the TranslationDescription field to end with the strShift value. Though it's unlikely given the current data, using the pair of % could return unwanted results. This will do in the meantime & I thank you!

I have an ADODB recordset that may contain multiple records. If it contains multiple records, I want to filter the results further, by selecting records where the TranslationDescription field ends with the string value strShift. Here's my code: Private Function GetTranslation(strCode As...

I'm stuck on an error message that appears in my Visual Studio VB.NET 2005 project. When I build the solution, I get the following error: Unable to find dependency 'DAO' (Signature='31BF3856AD364E35' Version='10.0.4504.0') of assembly '3rdparty.dll' (3rdparty.dll is not the file name of...