Ken Milne's Q&A profile

• Windows Forms How Can I find the scroll bar attached to a datagrid when it is not visible?

  I have a datagrid which is populated by dataset. When the list increases beyond the available space, the scrollbar automatically comes up. I wanted to handle the scrollbar mouse up and mouse down events. How Can I find the scroll bar attached to a datagrid when it is not visible Similarly for richtextbox, how can I find the scrollbar when it is invisible Thanks, Jil. ...Show All

• Microsoft ISV Community Center Forums worksheet_change

  I try to do a macro that reacts when i change the interior color of a cell. Worksheet_change seems to only react then the cell value is changed. Is there any other way 'Private Sub Worksheet_Change(ByVal Target As Range) ' 'If Target.Interior.ColorIndex = 4 Then ' MsgBox "bla,bla, bla " 'End If ' 'End Sub thanks in advance agron Not sure if this will work OK, it seems to on a simple sheet I created. I delcared LastCell as a Public variable in a new module to track the last active cell Public LastCell As Range Private Sub Worksheet_Activate() Set LastCell = ActiveCell End Sub Private Sub Wor ...Show All

• Visual Studio Team System MS ACT

  Hi, I was recommended MS ACT (application center test) to test a deployment of CRM 3.0. I've installed VS 2003 on a development machine and am now trying to connect to the CRM 3.0 application on another server. When I try to record a new test with 'start recording', IE opens up a blank window. Standard behaviour yes, however I fail to connect to the CRM application due the proxy settings being encorporated into the IIS browser being opened. (Tools > Internet options > Connections > Lan Settings) The proxy settings are address = localhost with port 8181. When I disable this proxy setting, it can connect to my CRM application, h ...Show All

• Windows Forms Winforms Datagrid Vs DataRow BeginEdit

  Hi Folks, Scenario:- I have a DataTable (T1) with 2 columns "id" and "name", i have bound this to a winforms datagrid (D1). The table T1 is added with a uniqueconstraint as here. T1.Constraints.Add(new UniqueConstraint("say the Name column")); // So this says that, the name column, can't have duplication of value. Assume that the T1 is having 2 rows with values like this row 1 - "1", "Bill" row 2 - "2", "Mill" When i run this application, the grid is displayed. i can edit the value in the datagrid. If I am editing the value of second row to "Bill&qu ...Show All

• SQL Server SQL DataReader Mischief ! HELP !

  Why oh, Why is this happening.. Fastest winner gets a gold star ! hehe Just after i check the value of the data reader against the string in the IF statement, the code skips. If there is a record (=) to my varible everything is fine. However the IF ELSE will not work inside the While loop ! If i remove the record from the database and run the below code the IF statement skips (well skips the (Else)) and bombs out. Public Sub SqlCh( ByVal setobj As String ) Dim connectionString As String = "*************************************************" Dim sqlConn As New SqlConnection(connectionStrin ...Show All

• SQL Server adding a new data column (not derived) midway thru a data flow

  I need to know what a table's max row Identity is part way thru a data flow.  I can't get it at the beginning of the data flow.  I need to either (1) add it to the data buffer part way thru or (2) set it into a package variable and then reference the var in a script component. I've not found a way to add a database column to the data buffer without doing a lookup for each row (too slow and not appropriate here) or some goofy oledb source and then merge join into the data buffer on a contrived join. I've read questions about referencing package vars in scripts but I can't get that to work.  DTS.V ...Show All

• Windows Forms Excel-like control

  I need a freeware control which would provide the functionality of the Excel component. Any suggestions You can use this freeware VisualPaseo: URL : http://www.paseosoft.com/produits/visualpaseo_tele1.php It's a development freeware that includes 33 .net components (such as File Management, SQL Request Import Export, Telnet emulator, Executable command, POP SMTP, FTP transfer, Date control, Timer and Period control, Variable calculation, Word, Excel...), and you can control it through visual studio ! ...Show All

• SQL Server SSIS Failure - can not add a row to the Data Flow task buffer

  I have a relatively simple SSIS package that I'm building for a data mining process. The package starts with an OLE DB data source, passes the results of a SQL Command (query) along to a conversion step, which then gets sent to a Term Lookup task. The Term Lookup then writes the result to an OLE DB Data Destination. Pretty simple. The OLE DB data source query returns about 80,000 rows if you run it through SQL WB. The SSIS editor shows 9,557 rows make it out of the source, and into the conversion step, 9,557 make it out of the conversion and into the lookup, and about 60,000 rows make it out of the lookup and are written to the results table ...Show All

• Visual Studio Team System VSTS Beta 2 -> RTM migration story

  It's known that there will be changes from Beta 2 to RTM, including schema changes in the database.  It's also known that various MSFT teams and TAP participants are using VSTS in a production environment today. Presumably those internal and close teams are going to get some support for migrating their Pre-RTM repositories to the RTM product, or they wouldn't have agreed to be using VSTS in production today. So what's the story for the rest of us   I've read that officially there's not going to be any supported migration tool, yet it seems that such a tool will likely be created.  Can we expect to see a tool show up as an ...Show All

• .NET Development Binding Business Object Properties to RDBMS Tables

  (I'm asking this from a newbie knowledge base --- here goes:) What is the general solution in .NET for binding business object properties (and perhaps complicated structures, like a collection of collections) to RDBMS tables    1)  I see the value of ObjectDataSource for automagically binding buisness object properties to databound controls...is there something analogous to binding business object properties to DB tables     2)  Or must this be done "manually":  first bind the DB table to a dataset, then move the dataset into the business object data structure, using custom code par ...Show All

• Smart Device Development Need to know how to magnify

  dear members, I am for the first time doing a project on smartphones.It needs to capture the contents of the screen,magnify it then.I have source codes in Delphi,Windows API,C++.I am very new to this concept.I dont know how i should go about launching the application in .Net.How do i do this,I am a novice,I would be grateful if u could help.If so i will post the code.P Take a look at Graphics.DrawImage(). Specifically the overload that takes both a source and destination rectangle. If the dimensions of the destination rectangle are larger than that of the source, your image will be " ...Show All

• Visual Studio Express Editions vb6

  Where, oh where, is a free download of vb6 I am taking a class that is going to teach vb6, but the book for the class was only available used. Therefore the s-ware that WAS bundled with the book is no longer. I specifically need vb6, and was unable to find the download on ms.com. My textbook says it is available from ms for free. I need a rather specific answer, and thanks in advance from a novice! Not only is there no free download, the product is completely unsupported anymore. It's no longer shipping with MSDN, even. I'd suggest you try ebay, if you have a specific need to use VB6. VB6 is three versions o ...Show All

• Visual C++ good books on win32 programming

  i am a computer engineering student and i have been a .net developer for a few years now. i want to delve deeper into the world of windows api programming using vc++. please suggest good introductory texts, books and resources for begining my journey. please recommend books for windows api porgramming and not introductory C++ stuff. See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=107484&SiteID=1 for recommended books. If non looks enticing then the folks at the windows newsgroups at http://msdn.microsoft.com/newsgroups should be able to suggest more books. Thanks, Ayman Shoukry VC++ Team ...Show All

• SQL Server New Query button -- always prompts for authentication

  Every time I click the "New Query" button, or drag a file into the editor, the system prompts me for authentication. This time and time again leads to executing commands on the wrong database, and the only workaround is basically to accept the necessity to hit the enter key when prompted for auth, and to always double-check which database you're about to execute your query against. If the user account you are authenticating as has access to multiple databases, then you always have to change the database after creating a new window. I am sure I'm not the only one very frustrated with this tool. Has anyone found a real workaround ...Show All

• Windows Forms Adding Controls to a User control

  Hello, I'm trying to add custom controls to a user control, and render them to it. I have a viewer user control in which several of these controls are built: //Create a verse item and assign the values to the property VerseItem verseControl = new VerseItem(); verseControl.Visible = true; verseControl.Enabled = true; verseControl.Anchor = AnchorStyles.Left | AnchorStyles.Top | AnchorStyles.Right; verseControl.Number = verse.Number; verseControl.Text = verse.Text; //Add the control to the collection this.Controls.Add(verseControl); Then after the for loop, I invalidate the user con ...Show All