progames25's Q&A profile
SQL Server Filter data back to publisher
Hi all, We have merge replication set up between 2 instances of SQL 2005 through web synchronization. I was wondering is it possible if the subscriber adds data at their end can we selectively edit what data gets uploaded back to the publisher Will this work if I add a filter to the appropriate article at the publisher or will that only limit what goes down to the subscriber rather than vice-versa Also, could we set up web sychronization if the publisher had no direct access to the IIS server (ie. was not on the same network, available only through port 80, 443) Thanks, Iain Hey lain, You can't selectively edit what data gets uploaded back to the publisher. There's a parameter that ...Show All
Visual Studio Report dissapear on postback
Hi all, I am using Crystal Report for VS 2005 to develop an Asp page.Below is the code is use to display my report in a button click event. OdbcDataAdapter myAdap = new OdbcDataAdapter (); myAdap.SelectCommand = myCmd; DataSet ds = new DataSet (); myAdap.Fill(ds); ds.WriteXml( @"c:\dataset_summary.xml" , XmlWriteMode .WriteSchema); string reportPath = Server.MapPath( "Crystal/projectsummary.rpt" ); myReport.Load(reportPath); myReport.SetDataSource(ds); myCrystalReportViewer.ReportSource = myReport; The report is displayed but when i click on the Export button or the Print button, the report dissapear. Any idea why this occurs and how to solve it ...Show All
Community Chat Is MS trying to throw away menu bar?
In IE7, classic menu bar is disabled by default. In Office 2007, there is not menu bar at all. Also the traditional toolbar is gone. I can't find a way to create my own custom toolbar too. What's happening I know menu bar is very classic and not pretty, but it is one single place that I am 100% sure that I can get all the features from a program. I don't want to lose it. You didn't answer my question. When I do word processing, I'm interested in typing a document that's all. Why do I need a Gallery and Live preview We haven't had them before. I've been very happy with Word, if anyone asked me what word needed, it would never occur to me to say, "A Gallery and a Live preview." So wh ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Newbie Help
Hello, I am VB.NET programmer and always want to author a 3D graphics game. I don't have any experince in using 3D or Directx . I have only worked on Database driven Reporting kind of projects before. Now, as i go through XNA studio, It seems promising tool for programmer like, or is it not Please guide me, if i choose XNA studio to develop game and become its programmer is worth or not. I am not asking finiacail profitibility, but the use ability, like If I learn this tool, how easy or difficult it will be, do i need to change a lot, Hope I make myself clear. Last question : Is XNA going to be Free as other Express edition or what, I doesn't find much info on this (moved to GS forum) Please read the FAQ, you will ...Show All
Software Development for Windows Vista Creating Additional Tracking Record types?
Is there anything in WF that would prevent me from creating my own subclasses of TrackingRecord and sending them to the tracking services What would happen in the SqlTrackingService if it gets a tracking record it doesn't know how to deal with Richard - you can't create a new TrackingRecord - but you can accomplish the same thing by using UserTrackingPoints and specifying the type you want to pass. Then use base.TrackData from your activity code. ...Show All
Visual Studio Why is the formatting getting lost?
Using VS2003 C#.net I've successfully built a reporting module in ASP.net. Each report has an associated Stored Procedure (SP) and View in SQL Server. The View is simply the Stored Procedure without any input parameters. The View is simply used to inform CR what fields will be in the report. At runtime I load the report, run the SP and then set Table 0 of CR to this retrieved DataSet. It works great ... or at least I thought so. Two strange things are happening though: The formatting of items (ex. currency formatting) is not showing up on the report. The sums at the bottom of some columns are mysteriously turning into "counts". Neither of these problems happen if I comment out the changing of the DataSource and in ...Show All
Software Development for Windows Vista Cardspace, Session and Cross Application
Hi, I'm still investigating Windows Cardspace technologies and I had one question regarding how it is designed. Basically, what I'm trying to achieve is getting a Cardspace (Personal or Managed) to be used in a small smart application that connects to a set of services as well as embedding a WebBrowser component that points to the website that hosts the services too. I would like to know if there was any way to avoid the end user to select twice the Card he wants to share with the current application (one for the services themselves and the other one for the website) This could be either built in supported or achieved by using some sort of caching mechanisms where I would gathered the token from Cardspace and send it directly t ...Show All
Visual Studio 2008 (Pre-release) MediaElement performance
Hi All I have a Viewbox and I am displaying a MediaElement with a playlist of movies in it one by one. But while playing that my CPU is getting to 100% utilization.What is the performance issue pertaining to it, and what are the ways to solve it Can you provide a sample. I can't reproduce that on my machine. <Grid xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml " > <Viewbox> <MediaElement Source=" http://download.microsoft.com/download/2/f/f/2ff6194c-0bda-4a63-999f-12d8a6119d2b/RB_OfficeUI.wmv " /> </Viewbox> </Grid> Running in XamlPad. The above uses ...Show All
.NET Development How can I restore deleted rows by DataSet.RejectChanges()?
Here is the simple code: DataSet dt = new DataSet () ; dt. Tables. Add () ; dt. Tables [ 0 ] . Rows. Add ( dt. Tables [ 0 ] . NewRow ()) ; dt. AcceptChanges () ; dt. Tables [ 0 ] . Rows. RemoveAt ( 0 ) ; dt. RejectChanges () ; It doesn't work which means that the deleted row is not restored. This case is pretty simplified, but in my real project I have the same problem - cannot perform full rollback all local data changes in DataSet object. Need your advice. Thanks. Remove != Delete. Remove doesn't change Rowstate. So calling Remove or RemoveAt takes it out of the collection. Delete on the other hand, leaves it in the collection but sets the Rowstate to Deleted. Then when you call AcceptChange ...Show All
Visual Studio 2008 (Pre-release) In need of suggestions for xbap application
Hi people, I need some suggestions for a typical intranet example of a xbap. What is a good example of something that’s better of as an xbap instead of a asp.net web application. /Simon ...Show All
Microsoft ISV Community Center Forums How to send parameter from ms access to excel workbook ?
How to send parameter from ms access to excel workbook I 'm developing MS Access application (GUI & Database used VBA programming ), but i sending report to MS Excel template. when user want to view that report .them will click button as open workbook from MS Accecc user interface. system will open workbook & pop-up from wait for user select input, submit and system will receive data from MS Access Database output to that worksheet. And now I need update that appication by select data item from listView from MS Access user interface and sendind some parameter for queries data same listview item to MS Excel template. On workbooks openning VBA will used parameter from MS Access and queries data same parameter from Database ...Show All
Windows Forms Anyway that i can click ont he Cancel button while upload of a file is taking place.
Actually my aim to enable a cancel button while this upload takes place.I tried raising an event which makes the cancel button enabled while the upload process is going on. But I am not able to click on the cancel button, i dont get the access to click it.Once the process is completed i am able to click the button to generate the event. Can anyone tell me how this can be done. Just don't block the UI thread by polling in a while loop. Have the UI up and running. You could e.g. disable all buttons which should not be clickable and only have the cancel button enabled. Your code will block the UI thread because the message loop is not processed. You might throw in a DoEvents in the loop but that is bad design. Coding all that ma ...Show All
SQL Server String to Date Conversion Orcale
Hi, i have a flat file with string column 20060616 . i am converting the string to date (Oracle) i am using the derived column with the following experssion . FlatFile -----> Destination (Oracle Database) (DT_DATE)(SUBSTRING(JDate,6,2) + "-" + SUBSTRING(JDate,8,2) + "-" + SUBSTRING(JDate,1,5)) while executing the package its failing and throwing the following error [Derived Column [73]] Error: The "component "Derived Column" (73)" failed because error code 0xC0049064 occurred, and the error row disposition on "output column "JOINDDATE" (124)" specifies failure on error. An error occurred on the specified object of the specified component. what could be t ...Show All
SQL Server Multiple updates on multiple conditions?
Hi, I'm looking for a way, if possible, to update a field to different values based on different criteria. For example, Field X should be A if condition 1 is true, it should be B if condition 2 is true, etc. I'm not sure if there's a way to use a CASE in an UPDATE statement Thanks Maybe something like: update urTable set X = case when condition_1 = target1 then A when condition_2 = target2 then B else C end where filterColumn = someCondition ...Show All
Visual Studio Help - Passing expressions in Report Parameters
Hi all, I get an error “Object is not set to an instance of object” when calling LocalReport.SetParameters with the selected value of one of the parameters being an expression (see below). I am passing in the value "0" to LocalReport.SetParameters and my suspicion is that ReportViewer is comparing that to the expression in the ValidValues of the parameter and not liking the comparison. The issue is that I don’t know what ReportViewer wants to receive. It doesn’t like the evaluated expression string, it doesn’t seem to like the unevaluated expression. I've included both the exception stack and the rdl. Thank you very much, in advance, for any light you can shed on this. -- Jeremy Here's th ...Show All
