DrBob's Q&A profile

• Software Development for Windows Vista Workflow management in Enterprise Environment?

  Hi I want to develop a Workflow management system in enterprise environment using WWF. I design the system as follow: 1. A Workflow management server manages workflow definitions and workflow instances (host in IIS or Windows Service). Workflow definitions can be deployed to the server. Server will supply interface (maybe Web service methods) to client to remote interact with workflows. 2. Workflow designer which ...Show All

• Windows Forms Exporting DataGridView to Excel

  Hi, can someone tell me how I can export a DataGridView to an excel spreadsheet and do row coloring, etc. Also, I want to be able to export to Excel 2000, XP and 2003 Thanks, Tom try using DataGridView Extension - it is a free "upgrade" of the basic DataGridView control (no another control, just an upgrade) and it allows you to export data and visualization to Excel, HTML, Also to search for a tex ...Show All

• Windows Forms strange tabindex behaivour

  Hi guys, On my form is a button which clears all selected radioButtons private void clearFields() {    radioButtonFlexcab.Checked = false ;    radioButtonEtc.Checked = false ; } After calling the function, these controls are completely ignored when using the tab key. The first time it is fine but as soon as I call my clear function the tab key does not stop at the radiocontrols. Is this a Visual Studio bug or what can I do ...Show All

• Visual Basic What's wrong with this code?

  I had this code that i am supposed to use for my current project...Using Crystal Report, I want to sort the record by entering the two dates (dtpFrom, dtpTo), the name of the company(FINAL2.COMPANY), the description(FINAL2.Description) Private Sub ConfigureCrystalReports() Dim mySelectFormula As String = "{FINAL2.Order_Date} >= #"" & dtpFrom & "#" & " and {FINAL2.Order_Date} <= # ...Show All

• SQL Server Page Breaks based on a new value of a field in SQL Report

  I have a SQL report which I have created in VS2003.NET which contains fields e.g. surname, firstname, date of birth and ref no. Please see the table below for reference. I was wandering if it is possible in reporting services to programmatically say if the ref no. is 19 or 20 and so forth on the report, to only show records of the same ref no. on the same page(s) and begin a new page if  ...Show All

• Windows Live Developer Forums Add-Ins and Stored Procedures ?

  I am trying to use an Add-In to query a SQLServer database via stored procedure. My code works fine in my Windows Forms test application but throws a system exception when run in the Add-In. Is there a restriction on add-ins being able to use System.Data.SqlClient Was thinking of wrapping a web service around the data query otherwise - any known issues / restrictions with that approach alternatively Great ...Show All

• .NET Development Web Control DropDown not keeping its value in User control

  I have a user control that includes a dropdown box.  When I try to retrieve the value of the controls on the user control from the parent web page, the dropdown it is always reset on the user control, even though it is showing that value selected is clearly not the first item.  How to I get the correct value from the dropdown.  I do not want to set the AutoPostBack to True, since it would refresh the page each time you change ...Show All

• .NET Development Error 27 Option Strict On disallows operands of type Object for operator '='. Use the 'Is' operator to test for object identity.

  Hi Guys How would I best resolve this, VS 2K5 is complaing about the values in the case statements and not able to test for object Identity, I don't want to test for object identity I'm looking for values, I know I could add the ToString option after optCurrency.Value.ToString and then put both the "2" and "3" in quotes but that does't seem right either, any thoughts Select Case Me .optCurrency.Value Case 2 Me .optCurrency.Value = ...Show All

• SQL Server Disconnecting from engine does not closes database

  I connect Managment Studio to MSDE 2000SP4. Open database, open some object, then disconnect from engine (not simple collapse DB objects). In other programm try to drop database. Until you don't close MSSQL MStudio, database is in use. In older version collapsing DB objects in tree closes DB. Hi! I don't have access to MS from 2000SP4, but I can tell you that MS in SQL2005 have Disconnect command in co ...Show All

• SQL Server 100% Width and Height within a master page

  Hi, We have a ReportViewer control sitting inside a master page's content placeholder. All works fine except when I set the width and height to 100% rather than a fixed size in pixels. This is what we require, as we'd like the control to resize automatically along with the page. I'm aware of a fix whereby you remove the doctype statement from the page's script, but this seems to have no effect on a page which is based on a master page. ...Show All

• Visual C# how to convert excel formula to C#

  i have a problem when convert an excel formula to C# .It is here : =IF(AND(MIN(D3:L3)>=6,5;OR(NOT(D3<8);NOT(J3<8));COUNTIF(D3:L3;">=8")>5);"goodA";IF(OR(AND(MIN(D3:L3)>=3,5;COUNTIF(D3:L3;">=8")>5;COUNTIF(D3:L3;">=6,5")=8;COUNTIF(D3:L3;"<5")=1);AND(MIN(D3:L3)>=5;D3<6,5;J3<6,5;COUNTIF(D3:L3;">=8")=6;COUNTIF(D3:L3;">=6,5")>6);AND ...Show All

• Windows Forms Any Ideas - CodeDomSerializer, InitalizeComponet and ResourceManager

  I need to supress the inclusion of the standard ResourceManager in the InitalizeComponet method.  I have overridden the Serialize method in an inherited CodeDomSerializer but the CodeStatementsCollection does not contain the ResourceManager code.  I can serialize  ...Show All

• .NET Development Persistent View State

  I set the property enableviewstate=false on my document and all of the web controls, and even set the page.enableviewstate property=false in my code-behind, and yet the rendered html page still showed the hidden view state as follows: <input type="hidden" name="__VIEWSTATE" value="dDw0OTg1MjU3MTk7Oz4J+KimZEy5kJo5l/sI1ovaMLi8Cw==" /> Is this normal or Am I doing something wrong How do I disable View State I want to disable the viewsta ...Show All

• SQL Server Id getting generated differently

  Hi, I created a PDA application with a database, which has a table with a uniqueidentifier field and primarykey. While doing the bulk insert from dataset into sql mobile database, It is inserting the record but it is not inserting the id which was entered into the sql server 2005 database, instead the id by creating a new id and the code is as below. conAdap = new SqlCeDataAdapter (strQuery, conSqlceConnection); SqlCeCommandBuild ...Show All

• .NET Development How to know if client loses connection, etc

  Last question :) Is there a way to know from the web service end to tell if a user that has posted to the webservice has disconnected   Here's my scenario: User posts to web service, some sql server inserts are completed, results from inserts are returned as a dataset, dataset is returned to the user. What happens is if a user posts to the web service and disconnects, reboots, etc, the web service keeps running and completes successfully.&n ...Show All