Hoofy395's Q&A profile

• Windows Forms Row Colouring in DataGridView

  Hi, I have a requirement in which I have to set the background color of a row based on a particular cell value. The code is something like this Private Sub DataGridView1_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles DataGridView1.CellFormatting         If DataGridView1.Columns(e.ColumnIndex).Name = "RISK_TYPE" Then             If e.Value.ToString() = "High_Risk" Then                 DataGridView1.Rows(e.RowInde ...Show All

• Visual Studio Tools for Office Error add validation

  I read a table from DB with ~ 3000 rows. I concatenate column Name from table in variable: nameValues = Rows[0]["Name"] + "," + Rows[1]["Name"] .... + Rows[Count-1]["Name"], and I want to set validation at cell J2: ((Excel.Range)Cells[2,10]).Validation.Add(Microsoft.Office.Interop.Excel.XlDVType.xlValidateList, Excel.XlDVAlertStyle.xlValidAlertStop, Excel.XlFormatConditionOperator.xlBetween, nameValues, ""); But at run-time come error: Exception from HRESULT: 0x800A03EC. If truncate nameValues = nameValues.SubString(0,911) work, but when set nameValues = nameValues.SubString(0,912) cr ...Show All

• SQL Server SQL Server 2005 SP1 installs successfully but Microsoft update still showing it as needed?

  I have successfully installed SQL Server 2005 SP1 but when I go to the "Microsoft Update" site it is still shown as required. I have tried going back to an old image of the PC and installing SQL Server 2005 and SP1 again but still the "Microsoft Update" page is not picking up the fact that SP1 has installed successfully. Anyone had the same problem or know of a fix Steve Hi, don’t know if that applies to your problem, but I would make sure that you also install the post SP1 hotfix which fixed many problems that occured in the SP1. http://support.microsoft.com/kb/918222/en-us ...Show All

• Windows Live Developer Forums How to change a CultureInfo and what effect on search it has!?

  I have few questions about the CutureInfo that needs to be given in SearchRequest. I have tried to put cultere "DE" and "HR" but I am always getting the same US results from the Web Service. What I need is to get search results like when I search with MSN Search website and put settings to search only sites on language "Croatian". Best Regards, Armin Support for all markets (CultureInfo) currently available through the MSN Search website is now available through the API, as well. Please see http://msdn.microsoft.com/library/default.asp url=/library/en-us/MSN_Search_Web_Service_SDK/HTML/F_Namespace_Sea ...Show All

• SQL Server T-Sql Preformance

  I have a Stored Procedure that I need to make run more efficiently. I am calling the SP from a page that displays the data as a report. I have tried to change the SQL to several queries into temp tables and selecting the data from the temp tables, but the page does not display any data. I then put all the queries together and the page works if it doesn't timeout. I realize the query below is not efficient but I am uncertain how to speed it up further. I have copied the SQL below. Can someone point me in a direction Hello, Well, I don't think there's a silver bullet for you, but immediately I would consider the following to improve perf ...Show All

• Visual Studio A data source instance has not been supplied for the data source "Test_ChartData"

  I created a ReportViewer from the toolbox. I then proceeded to create a form that contains a single bar chart. At this point, I created a very simple class: class ChartData {    public int Param1    {        get        {           return 1;       }    } } I then added this as a data source by selecting "Object." From the Data Sources Window, I dragged Param1 into the chart's "drop data fields here" region. Now I try to run my project and I get: A da ...Show All

• Software Development for Windows Vista workflow s/w seggregation

  I am doing research on workflow managements systems. Recently, I browsed thorough a website http://www.workflow-research.de/Publications/PDF/MIZU.ROAL-EIP(2000).PDF which differentiates all the workflow systems in two parts.One are autonomous type(funtional withour any other additional application software) and other are embedded one (which use other applications softwares to work with). Please let me now that workflow mangements softwares like K2, Captaris, biztalk, WWF, skelta,transparentlogic etc. falls into which catergory(please seperate in two categories) and which category will be more useful when developing applications i ...Show All

• Visual Studio 2008 (Pre-release) When will the C# version of LinQ be ready for VS.NET 2005 RC0

  I am very excited about LinQ and would like to use it asap. Since I have to use the VS.NET 2005 RC0 version to create demos, I would like to inquire when will the C# version of LinQ be ready for VS.NET 2005 RC0.   Yes, I know that LinQ is already compatible with the VB version of the RC0 VS.NET release, but I would like to show Java programmers a flavor of what they are missing ! Well, considering the fact that .Net 2.0 goes RTM in less than a month, I'd expect a Linq release for the RTM version of 2.0 around the same time.  That would be my guess. Don Demsak ...Show All

• Windows Forms Using XSD schema for field validation when databinding to XML

  I'd like to create an application, part of which involves the customer creating XML documents compliant with a government standard schema. Much of the data will be filled in automatically, but parts will be manually entered by the customer. For the customer data, I want to create a few simple forms for data input. I thought I could use data binding for this. I would like each input field on the form to be validated against the schema definition of that element in the xml file, rather than just validating the finished file all in one go. I know that InfoPath can do this sort of thing, but there does not appear to be a framework in Windows for ...Show All

• Visual C++ System.IndexOutOfRangeException

  I'm trying to view the data in a very basic Access Database, but after executing the project, navigating to the form reading from the DB (with a DataGrid via Visual C++ .NET), the application throws this error: An unhandled exception of type 'System.IndexOutOfRangeException' occurred in system.data.dll Additional information: Cannot find table 0. I have double and triple checked my config file and I know the path to the DB is correct so I'm pretty confused on what this error means, considering the the MDB file is populated with entries. This is the code the compiler jumps on debuging: PatientData::Patient* pat = new PatientData::Pat ...Show All

• Architecture Visio® 2003 UML To XMI Export

  Has anyone been able to import the xmi export file this tool generates into any other tool I have tried pulling Visio Use case diagrams into XDE, Sparx 4.1, and now Sparx 6.0 with zero luck. Are there any plans to upgrade this add-in to export xmi 1.1, 1.2, etc The 1.0 version it exports is not support with the rest of the tools (XDE and Sparx) on the market I am currently using. Tad To address your questions: The main purpose of the tool was to provide a mechanism to export model data (from class diagrams) into an xml file which you can programmatically access. There is no other exte ...Show All

• SQL Server Cube Calculations and Report Model Problems

  Hello all, I understand this is an Analysis Services board, but due to the topic, I thought it would be as good of a place as any.  I have also cross-posted to the reporting services group. I've been working with SSRS for a year and a half now, but I am brand new to SSAS.  I've gone through tutorials and did as much reading as I could. The underlying data I am using is similar to the following: Shift_Start     Shift_End          Machine_ID    Breakdown_Min   ...   Quality_Pct 1/1/2005 7am 1/1/2005 5pm 535   ...Show All

• Visual Studio Express Editions Poor quality printouts when printing controls (labels, textbox etc.)

  My app. prints my form which has labels, textboxes and panels on it. What I have noticed though is that the quality of the text on the printout is quite poor and I can't seem to do anything to clean it up.The panels don't seem too bad. I use an LCD monitor and I'm using ClearType in the Windows Dispay Properties, and I did notice that changing this option does have an effect on the printouts, although the prints remain poor whatever I do. Does anyone know how to print clear and crisp labels, textboxes etc How are you printing it Presumably as the resultant form image. It will never look good printe ...Show All

• SQL Server In 2005, finding users who have context in a database?

  I know sysprocesses has the information, but I can't seem to find how this is done using the dmv's. sessions doesn have a db context, and requests is only active while activity is occurring. Thanks! This is a known limitation. None of the new DMVs expose this information. There is a bug already filed for this problem and we have some ideas on how to expose the information but not sure if it will be done in a service pack for SQL Server 2005. ...Show All

• Windows Forms Problem with value DataGridViewComboBoxCell

  In VB 2005 Express I have a problem, which completely do not understand. I use a DataGridViewComboBox in a DataGridView. When I change data and save it, I have no problem. But when I close the form I a repeting error, being: System.ArgumentException: DataGridViewComboBoxCell value is not valid. Can anybody help Thanks in advance, Simon Use the following link: http://lab.msdn.microsoft.com/productfeedback/Default.aspx   -mark DataGridView Program Manager Microsoft This post is provided "as-is"   ...Show All