JKay's Q&A profile

• .NET Development Best way to calculate values from an in-memory DataTable (DataSet)?

  Problem: I have to get some statistical values from a DataTable included in a DataSet; not from a table stored in a database. For instance, let's say I have to get the maximum , minimum and average values contained in a certain column. Question: What is the best way, in terms of performance, to obtain those values I am using the Net Framework 1.1. Some other possibilities: I think it is possible to use SQL to obtain this values from tabl ...Show All

• SQL Server To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)

  What could be wrong I get this error when a stored procedure is executing sp_OAMethod from SQL Server 2000 SP4. EXEC @rc = master..sp_OAMethod @Obj, 'Execute' The linked server is SQL Server 2005 x64. Already installed is SQLServer2005_BC_x64.msi version April 15, 2006. Local server is SQL Server 2000 SP4. I can execute the sproc successfully in Query Analyzer from my local dev box which has both 2000 and 2005 installed. Profiler in ...Show All

• .NET Development Double.Parse() - Why accept string?

  I don't get it... the signature for Double.Parse accepts a string and trys to convert it to a double. Why accept a string and not an object If you pass this function an "int" then it has to convert it to a string, and then to a double. What am I missing here Why, instead of boxing an int to pass to a method, wouldn't you just use implicit conversion, as in the following Also, parsing - by definition - takes place -w- ...Show All

• .NET Development Relations in DataSet

  I have a situation where i should update the relations from dataset to the database. Can some one can help me how to do this. Thanking you Ramakrishna Hi! Iterate through all the relations in dataset and create them while iterating by making use of SMO library. cheers. Sohail. ...Show All

• .NET Development Error: SQL Server does not exist or access denied

  I am a newbie so any help appreciated. the ASP.NET web application is on a seperate machine than the machine that runs the SQL Server. There are 3 SQL Servers running on machine that has my database. The 3 SQL Servers are: SQLM1\DevSQL SQLM1\DemoSQL SQLM1\QASQL where SQLM1 is the machine name & QASQL is the name of the SQL Server. The database that this application connects to is in SQLM1\QASQL. In the default.apx.vb, I have a connection str ...Show All

• .NET Development monitor

  Hi, I would like to write a little program which monitors a specified Service, and if it isn't running, starts it how is this possible please Thanks Hi You can use the ServiceController object to query the status of a service and start it if it is stopped. The following example checks the status of the Messenger service and if it is stopped will start it. This requires a reference be made to the System ...Show All

• SQL Server Not able to extract all records from a flat file

  I have a flat file that has over 50,000 records. When I import that file into my table I'm only able to extract 26,612 rows. I'm using a Flat File connection manager The format for this connection is Ragged Right There are about 25 columns, or so My Data Flow Source is a Flat File (Imagine that! ) I appreciate any ideas that you may have. Thanks!! Did you have the error output as i ...Show All

• Visual Basic Error 2004 Out of Memory when compiling VB 4.0 on new computer

  I have a new Dell Laptop with Windows XP Professional 40 gig hard drive and 1 Gig of Ram. After loading VB 4.0 Professional on it, when I tried to compile a project, I got the "Error 2004 Out of Memory" message. Works OK on my "Win 98" and "Win XP Home" computers with 256 Meg Memory. What is the Problem These forums are for VB.NET. You may want to check the VB6 resource center b ...Show All

• Windows Forms add customized combo box in datagridview

  i have my customized combo box found in the other site. i need this to add in dfatagrid view the combox box have multiple columns which i find it suitable for me.for now, the problem is aading it in datagridview heres the my code public class mycombo inherits datagridviewcomboboxcolumn public withevents columncombobox as mtgccombobox ---this mtgccombobox is mycombobox found on the other site ........ end class th ...Show All

• Visual C# How to find registered event handlers?

  Hi, I'm trying to determine if an object has any event handlers registered on it. The reason I need this, is to not let an object to register one single event twice. this .menu.BeforePopup += new CancelEventHandler(menu_BeforePopup); // OK this .menu.BeforePopup += new CancelEventHandler(menu_BeforePopup); // Don't let it happen twice   Any help would be great You can only do that from within the class that provides t ...Show All

• Visual Studio URGENT!!!! Crystal Report Performance when using multiple data sources

  I’m creating a report in a .Net project using Crystal Report. It uses several tables thru ADO connection. It uses a Typed Dataset which gets records through .Net application. The reports uses several selection formulae. Two of the tables (combined) have about 6,000,000 records.   The report takes toooooo long and then goes in hang!! How can the performance be improved in this kind of report   Pls help. It has alre ...Show All

• Windows Forms multicolumn checkedlistbox with vertical scrollbar

  Hi, It seems to me that you cant have  a vertical scroll bar in checkedlistbox with multicolumn=true. Any way to have vertical scrollbar with multicolumn checkedlistbox Thanks, So is there any way at all to have a multicolumn checkedlistbox wit ...Show All

• .NET Development Exception: DataTable internal index is corrupted: '5'. on ...

  Hi, I have a problem with bindingsource component in framework 2.0. I have a combobox bound to a bindingsource which is also bound to a dataset with 2 related tables and a datagridview bound to the same bindingsource. What I want to do is : When the selectedindex property of my combobox changes, the corresponding cell value must be changed in the datagridview. But although the value in bindingsource changes, datagridview does not displa ...Show All

• Windows Forms OpenFileDialog -- file display order?

  In the OpenFileDialog, there is a way to choose the order, in which files are displayed. It's the "View Menu", and my particular need at the moment is the "Details" option, Sort By Date. Is there any way to convince the OpenFileDialog control to come up in this configuration Or, at least, in the "Details" display mode Mine always comes up in the "List" mode. Thanks! ...Show All

• Visual Studio Team System Multiple conditions for transitions

  Hi! How is it possible to specify multiple conditions for transitions I would like to enable a transition IF: 1. The current user is member of a specified group OR 2. The current workitem's (Bug's) AssignedTo field is equal to the currentusername Is this possible in TFS   Thanks! Bye, Csabi Hi Enabling transitions based on memberships in groups : You can control transitions using "Transition Security" ...Show All