BlackPepper's Q&A profile

• Windows Forms nested tables on a drill down datagrid !!

  Hi, All, here's the goal that I am trying to achieve, I get it working with Syncfusion DataGrid, just want to get it working with the native .net DataGrid on a winform app. Goal: have aloaded dataset ready, with 2 tables in it and a relation built, table A is the summary table and table B is details table, bind table A to the datagrid on a winform app, it's showing up "+" sign  ...Show All

• .NET Development Finalizer guarantees for access to other objects

  When a finalizer runs are there any gurantees that any other object has not already been finalized This would include another object to which a reference in the finalizer's class still exists or a public static object in the finalizer's class, or any other class. Chris Lyon - MS wrote: Hi eldiener A class cannot explicitly call its finalizer, so your situation shouldn't arise. Besides, according to the Dispose Guidelines, the resource cleanup should be done in a protected dispose, and called by the finalizer in the case where public Dispose was not called. See http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpgenref/html/cpconfinalizedispose.asp for more info. -Chris In C ...Show All

• SQL Server How to do this in OLAP report?

  I am using SQL 2005 Reporting Services. I need to create an OLAP report. The suitation is similiar to a sub-query in Store Procedure. I am not sure how to do this in an OLAP dataset. The OLAP cube has been prepared using SQL 2005 AS. I believe that this report requires two datasets and it is based on the same OLAP cube. The report itself is based on the second dataset. The first dataset require the user to input two parameters. The second dataset uses two of the fields from the first dataset to filter out the second dataset. I can create the two datasets but I dont know how to assign the two parameters on the second dataset which is depends on the result of the first dataset. Any samples or steps or procedures using SQL 2005 RS would be gr ...Show All

• Visual Studio VS .Net Crystal Reports and Excel Export

  Hi, I'm a CR novice and I was wondering if it's possible to create a Crystal Report in VS .Net 2003 that allows me to embed code in the .rpt file that would create a file export and ask the user to save to an Excel file. I'd like to know if this can be done and what if any are some sample codes. Thanks. Novice Hi..Yes it is possible to export your report to excel file...Here's a sample code of exporting your .rpt file to .xls... // Declare variables and get the export options. ExportOptions exportOpts = new ExportOptions(); ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions (); DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions(); exportOpts = Report.ExportOptions ...Show All

• SQL Server two independent drill downs in matrix report

  I have defined the following to generate a matrix report 1. Row data: Country,region,state , Race,gender ( Red colored columns - Group1; Blue colored columns - Group 2) 2. Column Data: Statistics as of (Date) 3. Value: household income I'd like to be able to have a seperate drilldowns on group1 and group2. i.e drilling down on country, region, state shouldn't automatically expand/minimize race and gender. I played with the attributes of individual columns and edit groups of the same. But couldn't achive an independent drill down. Income as of '05 Income as of '06 Country Region State Race Gender 100k 105k Having independe ...Show All

• Visual Basic Problem with activex control.. Please help..

  Hi, Not sure if its the right place to ask my question.. We are using an Active X component to get the MAC ID of the system through the browser. The components used are <object classid="CLSID:76A64158-CB41-11D1-8B02-00600806D9B6" id="locator" VIEWASTEXT> </object> <object classid="CLSID:75718C9A-F029-11d1-A1AC-00C04FB6C223" id="theId"> </object> It works well for all system except two. The specifications of the systems are as follows: IE version - 6 OS - Windows Xp Professional version 6.0.2900.2180.xpsp_sp2_rtm.040803-2158 and Windows Xp Professional version 6.0.2900.2180.xpsp_sp2_gdr.050301-1519 The systems are configured exa ...Show All

• Visual Basic Pass data from a selected row in a DG to a new form

  Hello all. I have a datagrid in my form which displays basic information about open purchase orders. When I select a row in that grid, I want to pass the data in that row (actually only the SQL record ID) to a new form, which on load will fire a stored procedure that will populate the the new form fields. I can't figure out how to pass the cell value of the selected row to the new form. Any help would be appreciated. Mike First we will get the current row then we get Id from its column then pass it to the second form -- sorry the code C# but it may help you private void btnPurchase_Click( object sender, EventArgs e) { DataRowView rowView = this .purchaseBindingSource.Current; i ...Show All

• Visual Studio Team System Enforcing code standards

  Is it possible to configure Team to enforce public available coding standards such as MIRSA or JSF safety standards You could build your own checkin policy to verify standards use. Below are resources: Overview http://blogs.msdn.com/team_foundation/archive/2005/04/15/408700.aspx Marcel de Vries wrote an article on his blog about check-in policies. http://blogs.infosupport.com/marcelv/articles/CustomPolicyArticle.aspx James manning has a post on creating policies http://blogs.msdn.com/jmanning/archive/2006/01/21/515858.aspx You can find an example of using the version control API on Buck's blog. http://blogs.msdn.com/buckh/archive/2005/09/09/463287.aspx FxCop can be used to check for certa ...Show All

• .NET Development Treeview adding node problem in Framework 2

  I have a user component called 'SiteJobs' which housed in my main application windows form. It basically consists of Treeview as main display object, and accept a string object which corresponding to job campaign. It has public method called 'AddJob' , as code below public void AddJob ( string campaign ) { if ( campaign == "" ) return ; TreeNode newNode = new TreeNode ( campaign ); newNode . Name = campaign ; tvJobs.Nodes.Add(newNode); lblCurrentJob . Text = "Job: " + campaign ; int index = tvJobs . Nodes . IndexOfKey ( campaign ); if ( index !=- 1 ) tvJobs . SelectedNode = tvJobs . Nodes [ index ]; if ( OnNewJobIsEntered != null ) On ...Show All

• Windows Forms Accessing objects on a form via a class

  I have a form with a text box and I need to access the textbox and some other events within the form class from a seperate class. How can I get access to that textbox The form is making a call to a method within the class class.getCommand(command); and then the getCommand method needs to be able to modify the textbox within the form. Any suggestions would be great! Thanks! Scionwest Depending of the command you need to cast first parameter of type Form to specific form type for that command. Then you can access form controls. By default controls on the form are private. So one way is to make them public, but other and better is to create a property for every control that you want to ...Show All

• Visual Studio Express Editions Video Screen Capture

  Is it possible to capture the screen as a video, like the way you take screenshots and then save it as *.wmv, or *.avi or something You see, I play a lot of games, and i want to take videos of them, and take videos of other stuff on screen, ive tried Windows Media Encoder 9 and its videos come out like screenshots piled together into a slideshow, only worse. I've also tried a few others, which didnt work great either, so I thought, it'd be great to make my own one, at least then if i didnt like it i could easily try to fix it. Is there a way in Visual Basic to do this, or is there a .NET component, or even a .DLL out there to do this in VB Video is basically so many screenshots a second. So with the sample above a resourcef ...Show All

• Visual Studio Express Editions print on screen

  hello this is the dumest questin u will ever here... how can you print things on the form. i tried print "" and it dosnt work. how can i print on my forms. thanks You cannot print directly to the form, as you did in VB6. You need to direct the text to a label or multiline textbox. Note: You must include a line feed between the text to continue to the next line. For example: mytext = "Four score and seven years ago" & vbCrLf & "our fathers brought forth on this continent" _ & vbCrLf & "a new nation" etc. ...Show All

• SQL Server Force at least one parameter (2K5)

  I am trying to build a report that has about 6 different parameters. All of the parameters have been set to allow null, however, I would like the user to put in at least one "search" criteria in order to run the report. How would I be able to do that In addition, when I am viewing the report, it automatically runs and does not wait until I click "View Report". How can I set it not to execute when the report is viewed, but when the user clicks the button Thanks Solution: Create embedded code function that takes as parameters your report parameters values (like this MyFunction(p1value, p2value, p3value,...) ) Inside do something like this: iff(IsNothing(p1value)=true,0,1)+iff(IsNoth ...Show All

• Visual C# Visual Studio 05: How to create a new popup box, and then design the popup box

  Hi sorry its me again, How do i create a popup box for eg: i click on SETTINGS, it pop out a box which then i can edit the box so that i can set dropdown menu on the box for the relevant settings. coz the program im doing is a webcam player, i want the user to click on settings where it can choose the type of video and which camera to use... now i only know how to use the MessageBox.Show("Your Text here") command. Just dont want to create a new thread is it possible to change this code into individual code try { MenuItem m = sender as MenuItem; capture.RecFileMode = (DirectX.Capture.Capture.RecFileModeType)m.Index; this.txtFilename.Text = this.capture.Filename; switch(capture.RecFileMode) ...Show All

• SQL Server Move registries that doesn't exists in a table from a table to another

  Hi, I need to run this query, everytime that the system is started, but it always bring some regitries twice. like I run the query once and it brings 104000 registries, if I run it again it will bring 1040 registries, that was already moved. How can I correct this INSERT INTO [PABX_IGNORADOS]([COD_CLIENTE], [DATA_HORA], [NRTELEFONE], [RAMAL], [WCOS], [TEMPO_SEGUNDOS], [TIPO], [TIPO_ORIGINAL], [TEMPO_ATENDIMENTO], [JAPROCESSADO], [VALOR], [VALOR_CONC], [VALOR_TARIFA], [VALOR_TARIFA_CONC], [CLASSIFICA], [LOCALIDADE], [VALOR_TEMPO], [NUMERO_E1], [BLOQUEADO], [TABELA_TELEFONICA], [DATA_BLOQUEIO]) SELECT [COD_CLIENTE], [DATA_HORA], [NRTELEFONE], [RAMAL], [WCOS], [TEMPO_SEGUNDOS], [TIPO], [TIPO_ORIGINAL], [TEMPO_ATENDIMENTO], [JAPR ...Show All