Beyond Blue's Q&A profile

• SQL Server reverse merge repliction

  hi I have notice that i missed few columns in my merge repliction and i wonder is it possiblie to reverse a replicated database or copy to normal SQL database after that i would do a new Publication. I need to have the data that is in the Database. If this is SQL Server 2005, you can always use alter table and add the new columns to the table. They should automatically propagate to the subscriber. If you wish you can drop the publication, add the columns and reset the publication too. The data in the tables will be intact. ...Show All

• SQL Server Dynamic Row Group in a matrix

  Hi All ! I want to show row groups as hierarchy levels and need the sub total values belongs to each group and sub group levels. But the most important point is that my top next top group (from child to parent ) is not static its dynamic.i.e for a diffrent senario my under displayed example can have Universe--->Earth as parent for Australia and USA. eg: 1.Australia |-------sydney |-------Melbourne 2.USA |------North US |------North US(1) |------North US(2) |------South US |------South US(1) |------South US(2) Can I get some help from anybody for making a dynamic row groups in the matrix. Waiting for a kind help. Re ...Show All

• Visual C# Find FileName With Wildcard

  I have a directory full of image files which need to be copied to another directory when the original is updated. So basically I need to do this: System.IO. File .Copy(originalDirectoryAndName, newDirectoryAndName, true ); The only problem is that the original file has some random characters in it's name, and I need to be able to search by wildcard. How can this be best accomplished Thanks, Russ ok, ill give it a bash! :-) do you know how to work with dataset/datatables etc.... Is this the problem you are having, getting to iterate through the rows/columns to get "the value from that field" if so, let us know and also can you post the current code you have when retrieving items ...Show All

• Visual Studio 2008 (Pre-release) RC1 broke my stuff

  I installed RC1 earlier this week and now my WCF services don't work. For example, if I open a browser and type in //localhost/demoservice/service.svc, I get the contents of the svc file instead of the "You have created an Windows Communicaiton Foundation service" page. I have been messing with this for days. Any one else run into this Any and all insight is greatly appreciated... Scott, You should create this mapping by going to the "Home Directory" tab in the Default Web Site Properties dialog box, click the "Configuration" button, and add the mapping on the ensuing "Mappings" tab. Hope that helps, Vitaly ...Show All

• Smart Device Development WSE3 causes run to redeploy all references EVERYTIME

  I am currently developing a smartdevice application for my PDA. With normal winforms apps you can do the usual rightclick -> properties. then check the "use WSE3" checkbox. For some reason after doing it on my smartdevice app, it crashed at runtime complaining about System.drawing.Bitmap (but that might be related to this problem, but i'll ignore it for the moment) But now, everytime i press run on my project, instead of taking 2seconds to only redeploy the new .EXE Visual studio redepoloys every dotnet.dll to the deploy folder of the application. so now it takes close to 5mins each time i press Run, so it is rather hard to develop now. It sounds like maybe just a path reference gets messed up when WSE3 is enabled ...Show All

• Visual Basic PrintForm does not Install via ClickOnce Deployment

  PrintForm works on my development workstation in both IDE & the application EXE installed from ClickOnce site. However, on 2 client PCs, both running Windows XP, the EXE fails with "Could not load file or assembly 'Microsoft.VisualBasic.PowerPacks.Printing.PrintForm, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified." During ClickOnce install: No errors. In fact, I can find no install log in C:\WINDOWS\Temp\Temporary Internet Files afterwards. No signing. No elevated permissions. gacutil finds Microsoft.VisualBasic.PowerPacks.Printing.PrintForm on my development workstation, but does not find it on a client PC. the e ...Show All

• SQL Server still not correct - Reporting services syntax

  hi there RS2005 - Layout tab I have a field that says txtTrackerTrue=Sum(Iif ((Fields!Tracker.Value = Fields!RecvdBy.Value), 1,0 )) I want another field that says txtAllTrue =Sum(Iif ((Fields!Tracker.Value, ClosedBy.Value = Fields!RecvdBy, 1,0 )) obviously this is going to error how would I do this please thanks thanks Ian yes I tried that as well - I noticed that and thought I would give it a go - error is: Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope. so am just trying to see if there is anything else I can do. cheers for your help though jewel ...Show All

• Windows Forms how to add a frozen total row?

  How can I add a frozen row in DataGridView contains the sum total of each column You can frozen Datagridview by DataGridViewRow.Frozen Property ...Show All

• SQL Server Exception has been thrown by the target of an invocation

  I have this exception on page loading, is there any solution for this how can I fix this exception... Just out of curiosity, have you searched Google for your error string A whole bunch of results are there waiting for your reading pleasure. Looks like a .net Framework bug. ...Show All

• SQL Server Computed columns

  Hi, Consider the following example create table sample (col1 int, col2 int , col3 AS col1 + col2) PERSISTED NOT NULL) basically col3 is a computed column. Now when ever a row in col1 or col2 is updated the computed column will reflect the new value. how does this happen in the background. does this use row level triggers or what other mechanism is used to maintain col3 - computed column the reason why i posted the question is : If i use a lot of computed columns in my database, will it cause any kind of performance problems. so far what ever i have read about computed columns, no where it is mentioned that using computed columns may cause performance problems. Please let me know if you ha ...Show All

• Visual Basic Is it possible to create a delagate that points to a property of a class? To use more than one object type....answer1.

  Hello, I am trying to create a delagate that points to the property of an object. I am trying to create a class that can be created from a number of different types of objects that contain the "Item" property. Many classes in the .NET Framework support the Item property, but there is no interface that defines this property, so I cannot seem to figure out how to make a generic method that will accept a number of different object types. Here is a sample of my code: Class SomeClass Private Sub New() End Sub Public function FromDataReader(ByVal Reader As SQLDataReader) As SomeClass Dim Value As new SomeClass() Class.[propertyname] = Reader.item([ItemName]) Return Value End Function Public function FromDataRow(ByVal ...Show All

• Software Development for Windows Vista Program that accesses database failing in Vista

  Hi, Thanks for the help here, I found out that it is because the software is not Vista digital signed, so I will have to disable quite a few signature checking before it allows the program to be installed. However I still don't have any idea why it allows those built in InstallSheild 7 to go through without any problem. After the installation, I also released that the program can't work in Vista too. Even if I have set to Win XP SP2 compatible. The program is calling a database which is in Microsoft Access format. Everytime the application trying to open the database, it will be prompted that it is currently being used or have no rights to access it. I am already in Administrator rights, and shouldn't it be working if we have set ...Show All

• Smart Device Development Mobile SQL Issue

  Hi I am developing a Smart Device App that will talk to a SSCE 2005 DB, but i am having some problems with the DB engine and communicating with it. I have the same problme on the device it's self and on the emulator. If i copy a sdf file that i have crated using SQL Server Mangment studio on to the device the SQLCE App will not talk to it and i get the following error The Database file cannot be found Check the path to the database [,,,File name,,] Native error :25046 I get the same error if i connect it with code. If i create the DB on the Device SQLCE reads it fine but i get the same error message when i try to get the app to connect to it. also if i move a SDF file that i have created on the Device SQLCE gives me the error message. ...Show All

• SQL Server Creating a data source on the server to connect to SQL SERVER.

  My question is what is the proper way to do this I have been try the ways that it is instructing me to do. By creating the name, then I go to a list of potential sources, one being: the local, then another being: the actual domain on the network, last one being: the name of the created data source. I have already tried the local & domain, I will try the last one. But, my question is if this selection is not going to connect to SQL SERVER. Then, "What should I do within the server to make this connection possible to a client computer look for the access " Hi, I Did not understand your explanation. But anyway, if you want to let clients access SQL Server, you would have to do nothing more than 1.Enabling remote c ...Show All

• SQL Server How do I move my database?

  I am using VWD 2005 Express, with SQL 2005 Express. My web hosting company supports ASP 2.0 and SQL Server 2005, but have put SQL on a database server, which is separate from the application server. I successfully published a "Hello world" test application, but my database application failed after displaying the logon page, presumably when it first tried to connect to the database. VWD has created my database within the application folder ( app \App_Data\ASPNETDB.MDF) and created the configuration string in web.config: - < add name = " ConnectionString " connectionString = " Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True " pr ...Show All