WXS123's Q&A profile

• SQL Server Error: Subreport could not be shown.

  I work for a Microsoft Gold Partner and I am having a problem with subreports in SSRS 2005 SP1. Essentially, I have a report that contains subreports. The main report has a table that passes a parameter to a subreport in each row. The report renders properly when I preview it in Visual Studio, but once deployed to the server it only renders the first subreport for the first row, and every subreport thereafter displays the error, "Error: Subreport could not be shown." I tested each subreport individually on the SSRS sever and each executes and displays fine. I turned on traces in the web.config file and found some additional information: Hi, write a bug to the mentioned portal with pasting the error log file and descri ...Show All

• Smart Device Development Using PocketPC serial port

  Can anyone give me some advice about using serial ports in VS2005 beta 2 on a pocket_pc. At first glance it seems easy, just declare an object as System.IO.Ports.SerialPort with events and process the datareceived event. Simple enough. However, putting this code in a class and tring to generate an event based on the DataReveived event results in   "An unhandled exception of type ' System.NotSupportedException occured in System.Drawing.dll" the Additional Information states "Control.Invoke must be used to interact with controls created on a seperate thread". This really has me confused since when you look at the code included, I am not even intentionally using threads. The application files included - opens as serial port when the use ...Show All

• SQL Server INNER JOIN between a CLR-TVF and a table returns no rows

  I have the following query: select sq.*, p.numero, p.nombre from paf p right outer join dbo.GetListOfSquaresForShippingLot(@lot) sq on sq.number = p.numero and sq.version = p.numero The @lot parameter is declared at the top ( declare @lot int; set @lot = 1; ). GetListOfSquaresForShippingLot is a CLR TVF coded in C#. The TVF queries a XML field in the database and returns nodes as rows, and this is completed with information from a table. If I run a query with the TVF only, it returns data; but if I try to join the TVF with a table, it returns empty, even when I'm expecting matches. I thought the problem was the data from the TVF was been streamed and that's why it could not be joined with the data from the table. I tried to solve that pr ...Show All

• Windows Forms Newbie problem: updating data in Win Forms using a BindingSource

  Hi, I have a parent form that contains a data grid of materials. When the user the "update" button, a child form is called where the user can modify the selected record: Private Sub ModificarToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ModificarToolStripMenuItem.Click Dim oid As Long oid = MaterialDataGridView.Item(0, MaterialDataGridView.CurrentRow.Index).Value ' The first column in the grid is a hidden column with the record's ID FormaMantenimiento = New FormMaterialesMantenimiento(FormMaterialesMantenimiento.Modificacion, oid) FormaMantenimiento.ShowDialog() FormaMantenimiento.Dispose() MaterialDataGridView.Refresh() End Sub On the child form I fill the the ...Show All

• SQL Server Disappear the generic bar.

  Hallo all : How to disappear the generic bar in the report, or to disappear some options (example export). I speak about the bar which in the top of the report or there are the numbers of pages. Thank's. Right-click on the report once it has finished retrieving data and select properties. You can use the URL in the properties to point to a report that does not have the toolbar. (using /reportserver/ url instead of /reports) There are also rc: commands to turn off the toolbars. http://msdn2.microsoft.com/en-us/library/ms152835.aspx cheers, Andrew ...Show All

• .NET Development No row at position 0.

  I am trying to show/hide a control based on the value of a boolean DB field with the code below: Dim dsAdmin As New DataSet Try DBCon.ConnectionString = csWBoard DBCon.Open() userAdpt.SelectCommand = New OleDbCommand _ ( "SELECT admin FROM [User] WHERE (userID = '" & userName & "')" , DBCon) userAdpt.Fill(dsAdmin, "User" ) If dsAdmin.Tables( "User" ).Rows(0).Item( "admin" ) = True Then mnuAdmin.Visible = False Else mnuAdmin.Visible = True End If DBCon.Close() DBCon.Dispose() Catch ex As Exception MsgBox(ex.Message) End Try The field is of type Yes/No in my MS Access DB and the format property ...Show All

• Visual Studio Sandcastle Help File Builder

  I've created an NDoc-like GUI front-end plus a command-line builder tool for automating help file builds with Sandcastle. It's available at: http://www.codeproject.com/useritems/SandcastleBuilder.asp Using the help file builder provides the following advantages: The GUI interface is almost identical to the NDoc interface so anyone familiar with NDoc should be quite comfortable using it. You can import several settings from an existing NDoc project to start a new Sandcastle Help File Builder project. The builder will automatically locate both Sandcastle and the HTML help compiler by looking in the system path and in the Program Files special folder on all fixed hard drives. Properties are also supplied for you to specify the ...Show All

• Windows Forms Newbie!! loop through listbox qeustion..

  Hi all, I have a small app I am trying to create and I am stuck on this little problem (New to C# as of this morning!) I have a list box that contains url's to web pages.. I am trying to loop through each url, submit my post and move to the next.. My problem is the application is moving straight to the last url in the array and populating as it should.. How do I get the app to wait until my page is loaded, submit the info and then move on I know my loop is working properly because I substitued the webBrowser1.Navigate with a message box and it loops through all of them Below is a snippet of what i have right now... thanks in advance, Paul private void button1_Click( object sender, EventArgs e){ for ( ...Show All

• SQL Server AS 2005 and OWC10 pivot table fieldlist problems

  Hello, I have an AS 2005 cube set up which I can connect to via OWC10. I would like to try to reorganize the fieldlist and group the dimensions. The problem is I don't seem to have much control of the field list. For example; in the code below, the first alert box displays 23, yet the second alert box within the loop is never executed. Why am I unable to loop through the fields in the fieldset Also, I think the best thing for me would be the ability to replace the fieldlist with my own fieldlist, but how do I do this so the user can still drag things from my fieldlist to the pivot control Thanks. (jscript) pTable = Form1.pivot alert(pTable.ActiveView.FieldSets.Count) for (var fSet in pTable.ActiveView.FieldSets) { alert(f ...Show All

• Windows Forms MDI Children with a bad case of the jitters and other problems.

  I am using a flowed, stretched menustrip and a toolbar in in a toolstrippanel. Typically the child windows are maximized. When I close the window, a good of the time one of two things happens. 1. The child window gets that jitters. It rapidly increases and decrease in size by a few pixels until I kill the program. OR 2. I get an error about you can't Dispose an icon that is already disposed. UGH! Also If I open a second window with one already maximized, I get the jitters. My desired sequence of events is to set the child windowstate maximized and then show the window. This only happens when the menu strip is layout = flow. (Something I need.) If i use the other layouts there is no problem. Well just one commands disappea ...Show All

• Visual Studio Express Editions Creating a media player.

  hello, i am completely new to Visual C#, and i am wondering how to play music. i am mainly trying to make a media player with a web browser, but i am extremely confused on how to do this. i have googled this subject many times over with no luck. i dont know, maybe i am missing somthing. any help would be nice. i just got into C# about 4 days ago. go easy. :) well you would be better off using a WMP COM component. This will allow you to embed WMP into your application then you simply give it the path to the file via the URL property and you can play/pause and increase/decrease volume http://msdn.microsoft.com/windowsmedia/downloads/default.aspx you can drag this control onto your form. In design vie ...Show All

• SQL Server OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.

  Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire disk. This is a rare problem, it has happened less than 10 times in the past two years, for a job that runs once a minute. But it has happened on 3 different SQL Servers, (two production servers, and one test server). Our suspicion is that the root cause is an OPENQUERY() to pull data from a linked server (Oracle database on Unix). We have seen that these OPENQUERY() statements occasionally hang and cannot be killed. The OPENQUERY() is used to populate a local table, and when we originally populated permanent tables with OPENQUERY(), then there would be a ...Show All

• SQL Server MDX Question

  I have this Problem with an MDX in Reporting Services, but in the Reporting Services forum, noone can answer it. So I hope, this is the right forum: Consider the following example: SELECT non empty { [Measures].[Amount], [Measures].[Budget Amount] } on columns, non empty { [Products].[Product Hierarchy].[Level4].ALLMEMBERS } on rows FROM [Datawarehouse] WHERE ( [Material].[Material].[All Materials], [Date].[October 2006], [Company].[Company Scenarios].[Scenario].&[Vienna2market] ) I want to select not only [Vienna2Market], also [Salzburg2Market] should be selected, and both as one sum, not 2 separate columns. As I know, the WHERE part needs a Tupel, and each dimension can only be one time in a tupel. The Scenario Dimens ...Show All

• Visual Studio 2008 (Pre-release) Bind event to a controller.eventHandler

  Hello, I was wondering is there anyway to bind eventHandlers to the events of a control The same way I can bind to a command property... For example, a listbox has a click event: <ListBox Click="ListboxClicked"/> How can I instead bind an event handler to click <ListBox Click="{Binding Source=someController, Path=ClickEventHandler}/> If listbox had a command property then I could just bind a command to it, but it doesn't. Thanks Houman Figured out a workaround for events that correspond to mouse guestures: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=885042&SiteID=1 I still don't know how to deal with other types of events such as sele ...Show All

• Smart Device Development ReadXml under CompactFramework 2.0

  Hi, I'm trying to find the ReadXml class in the CompactFamework, or an equivalent, but I stil can't find. In the CF 1.0, it was part of the namespace System.Data, but it seems to not be anymore. Can you help me to find a way to read XML documents under CF 2.0 Regards, Ch'Portos. NETCF V2 includes everything NETCF V1 has. So, yes, it's likely you're doing something wrong. Most likely you’re just missing “Imports System.Data” statement or don’t have reference System.Data.dll. ...Show All