jaymoss's Q&A profile

• Windows Forms Displaying a usercontrol in a DataGridView cell

  I need to display usercontrols in the cell of the DataGridView. The edit control feature, that displays a single control while the cell is in edit mode, is not sufficient. I need to display multiple controls, of different types (plotters, gauges, etc) in multiple cells. I read the warnings about this feature not being supported by DataGridView. Unfortunately, I can't seem to find ANY .Net grid on the market that supports this feature. With trepidation, I tried it anyway. I made a custom cell that creates a user control and used the Paint override to move the control into the cell display rectangle. It sort of works, but there are a few boogers: 1. The grid steals the return key message from my usercontrols. Some of my controls use the retu ...Show All

• SQL Server Cannot show the editor for this task. Specified cast is not valid

  This error is pretty persistent. I re-installed VS 2005 and SQL Server 2005 but did not help. Every time I try to open a Script Task editor it gives me the same error regardless of the project or package. DO I NEED TO REBUILD MY SYSTEM =================================== Cannot show the editor for this task. (Microsoft Visual Studio) =================================== Specified cast is not valid. (Microsoft.VisualBasic.Vsa.DT) ------------------------------ Program Location:    at Microsoft.VisualBasic.Vsa.Dt.VsaIDE.get_ExtensibilityObject()    at Microsoft.SqlServer.VSAHosting.DesignTime.get_ExtensibilityObject()    at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTaskUI.Dispose()  & ...Show All

• Windows Forms datagridview fill performance

  I have a datagridview bound to a single access database table which contians 8500 records (20 columns). This is a worst case scenario for the dialog which typically has no more than a few hundred records. The datagridview contains rows can be filtered but must support display of all rows initially. The form takes about 10 seconds to load on a fast machine, which is too long. I can iterate through the same dataset very quickly, so the performance hit seems to be in loading the datagridview. I have disabled all autosizing, so that isn't impacting the performance. I have tried running the data adapter fill process in a background worker thread which alows the dialog to immediately load, but the datagridview still has to wait the full 1 ...Show All

• Visual Studio Team System Removing 'invalid rows' from query-result list

  I'm using the following code to get the number "developer hours by week" (slightly modified version of http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=326021&SiteID=1 ) . WITH SET [ValidRows] AS ' { FILTER ( NONEMPTY ( ( [Assigned To].[Person].[Person], [Work Item].[System_Id].[System_Id], [Work Item].[System_WorkItemType].[System_WorkItemType], [ Work Item].[System_Title].[System_Title] ), {[Measures].[Current Work Item Count]} ), [Measures].[Completed_Work] <> 0 ) }' MEMBER [Measures].[Completed Work On Period Start] AS ( (STRTOMember(@prmStartDate)), [Measures].[Company_Common_ActualTime] ) MEMBER [Measur ...Show All

• SQL Server BLOB in T-SQL

  Hi, can anyone help ,me out here with some design consideration reguarding importing of BLOB data to a SQL server 2000 using T-SQL statements I want to make an import of some documents which are stored in a Access database, to an Ms SQL server 2000. The documents are stored in the access database as a OLE Object, by now I thought of using the base64String function to convert the data from the access field and write it to the T-SQL statements which will written in a text batch file. And then I apply the SQL Convert function something like: INSERT INTO testBin VALUES(convert(image,'base64sting_encoded')) go Does this work Is it correct what I am doing Thanks. Access OLE Object column d ...Show All

• SQL Server Enable Service Broker for DB Mail on SQL 2005 Cluster

  I'm having problems enabling service broker for DB Mail on a SQL 2005 cluster, when I try to execute this sql it just hangs. Any ideas USE master ; GO ALTER DATABASE AdventureWorks SET ENABLE_BROKER ; GO See here: http://blogs.msdn.com/remusrusanu/archive/2006/01/30/519685.aspx This statement completes imeadetly, but the problem is that is requires exclusive access to the database! Any connection that is using this database has a shared lock on it, even when idle, thus blocking the ALTER DATABASE from completing. There is an easy trick for fix the problem: use the termination options of ALTER DATABASE: ROLLBACK AFTER integer [ SECONDS ] | ROLLBACK IMMEDIATE | NO_WAIT - ROLLBACK will close all existing sessions ...Show All

• .NET Development arrays to sql server table

  Using vb8, I would like to be able to programmatically save data in arrays to an existing sql server 2005 table. I've found tons of info on how to load db data into arrays but not the reverse. Can anybody offer some clues I'm not sure where it is that you're looking for the changes to be reflected (you say you can't see the new rows). You've constructed a standalone table.  It's not part of the ResultSet dataset. Additionally, you only need to call FactorTable.AcceptChanges() once after you've completed adding all the rows.     DJ ...Show All

• SQL Server Stored procedure issues with reporting services

  Hi all, I have stored procedures that will run fine from query analyzer windows, from other programs, etc. When I try to run the sp from vs 2005 form with in a SSRS project, the sp just hangs. It will not return any records and the app says "Not Responding. This does not happen for all SP's only some of them. Any ideas Ham, Thanks for your response. The parameters are datetime and they are specified as such. I have several SP's that use the same parameters and have no issue with them. ...Show All

• Smart Device Development How can I deploy latest service pack along with my application cab file

  I am getting following error this apliaction (Mytestapp.exe ) requires newer version of the microsoft .net compact framework than the version installed on this device How Can I deploy latest service pack along with my application cab file. I am using smart device cab application projectI am getting following error this apliaction (Mytestapp.exe ) requires newer version of the microsoft .net compact framework than the version installed on this device How Can I deploy latest service pack along with my application cab file. But My application is a service application[C#] which starts after installation and always runing.There are two other project along which one is a today screen plugin and one is the builtin soft menu extension for c ...Show All

• Visual Studio Express Editions Richtextbox: changing string(s) into pictures

  Hi Is it possible to change a word (string) into a picture (I know it's possible to change a certain string into another string with the replace command.) (for exemple: the use of emoticons. when entering a certain string that changes into the corresponding emoticon.) If this is possible, how do I need to do this. Thanks in advance. Shoot, didn't think that the forum bug was going to mess up my post. Giggle. The lamp icon in the post replaces "[ i ]" (without the spaces). ...Show All

• Visual Studio Express Editions commands

  where do i go to learn about all the vb commands, as i read these posts i am learning about commands that m books dont tell me about. how can do somethhing if i dont know the commands. things like accept and so on the video clpis yousent were great, but they never told me what the code would look like if i want to delete a row of data from the db. can you help with this please. the code below lets me alter, but a get a no delet command error. Public Class seeall2 Private Sub seeall2_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load 'TODO: This line of code loads data into the 'MusicDataSet2.records' table. You can move, or remove it, as ne ...Show All

• Visual FoxPro Arrange the "character string" numbers in order

  I use the character string for number input. What Syntax should I use to sort out the “character-string” numbers as below For example: To sort out according to the number 1 1 12A 3 3 4 4 5 443546 12A 5 443546 555AB 555AB Thank you. Lakshminarayana, I didn't make a comment on your code. If you reread my post I had already suspicions about sorting logic. If you want me to comment on your code then here we go: It doesn't make a sort as you think. Try expandin ...Show All

• Visual Studio Express Editions visual basic 2005 Printing

  I need some examples on Visual Basic 2005 programs that will display output on the screen and print output on the printer. Thank you. Luis Thanks Ahmedilyas. Also, what about using line feed character so that one line does not print on  top of the other   Luis ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. GameServices

  Hi, could someone please explain simply how to turn a GameComponent that I've written into a GameService that can be accessed by any GameComponent. i.e. What class needs to implement IMyGameService What should it expose How do I go about registering my service with the Game. A link to a thread/article or a new explanation that explains this would be great. I've seen a few half-explanations around, but nothing full. Still, a concise but thorough summary would be the best. Thanks a lot... I'll give you an example from my engine for creating a camera service since the linked example leaves a couple of important things out. One method for adding a camera to components that use one  would be to m ...Show All

• Visual C# How to Create a URL syntax checker in C#

  I would like to create a URL syntax checker so that can verify a cerrtain URL not a phish site. But I am also aware that some URL have valid syntax but is still a phish site. To answer this, I am looking for some measures on how to verify a URL and its correct DNS equivalent. I am doing a project of mine as one of our requirements and I have decided to create a web browser (already done) and I have included there 3 anti-phish tools. One of the tools is to check for URL syntax error. i have searched for such but has given me no good results that can be of any help to my project. I was hoping that some of the bright minds here could help me or enlighten me in my search. Thanks. Well wat ur telling is going to server side for v ...Show All