timleong's Q&A profile

• SQL Server Filter using a combobox

  Hello everyone, I am working on a filter function for my sql database (C#), and am running into a bit of difficulties, and I thought I'd ask if someone can see something wrong with my code. In my program, I basically have 3 comboboxes: gendcombo, agecombo, and regioncombo. I have filled them (except region) with search criteria (I want to get the other two working first). When I hit the OnRunFilterBtn, I would like to load the filtered criteria into the ListView... which is composed of 5 items: ID, Title, Text, Age, Gend. I'm not sure where I am going wrong with this one, and any direction would be helpful. I initially tried to ...Show All

• Visual Studio Team System Could not find KB913393 anywhere

  I am installing TFS trial edition, it complains about asp.net 2.0 QFE KB913393, I could'nt find it anywhere to install. please help! It should be on the installation medium. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=241725&SiteID=1 ...Show All

• Visual Studio Tools for Office Dynamic XMLNode controls

  Hello, I am interested by the ContextLeave/Enter events of VSTO XMLNode controls. However, unlike bookmark controls, there does not seem to be a way to add XML Node controls dynamically. If this is true, I will have to re-code the context enter/leave mechanism from the global XmlSelectionChanged event, comparing the path of the nodes in the DOM tree, and so on ... I am kind of lazy when it comes to something that I know already exists ;) Does anyone know if there is any way to add XMLNode controls dynamically on top of existing Word XMLNodes If this is not possible, I would be curious to know the reason of this limitation. Tha ...Show All

• Visual Studio Team System Unassociate mpp with a team project

  Once an mpp is associated with a team project how is it unassociated with a team project Not sure I understand your question. Why do you want to unassociate an mpp from the team project Are you asking how you can disconnect the mpp from a TFS server and project Thanks! ...Show All

• Software Development for Windows Vista about "StateMachineWorkflowInstance.EnqueueItem "

  what's the meaning of " StateMachineWorkflowInstance.EnqueueItem () " when and how could i use it Victor - all of the communication between a Workflow host and a workflow instance is done via a system of low-level queues. EnqueueItem is used to send a message to one of these queues. The HandleExternalEventActivity is actually a higher-level implementation based on interfaces built on top of this queueing system. You'd use EnqueueItem whenever you where using a StateMachineWorkflow (although WorkflowInstance also has a EqueueItem method) - and you are using the queueing system directly (i.e. not using HandleExternalE ...Show All

• Microsoft ISV Community Center Forums Need help with opening and closing recordset objects

  I recently converted my access application to an ADP and am having some errors with a simple procedure im trying to write off a click event. I think the errors have to do with how I am opening and closing the recordset objects. I know that is a bit vague but i wanted to see if anything stands out as incorrect. Please see below...Thanks. Private Sub Add_Record_Click() On Error GoTo Err_Add_Record_Click Dim cn As New ADODB.Connection Dim rs1 As New ADODB.Recordset Dim rs2 As New ADODB.Recordset Dim strSQL As String Dim intUserid As Integer cn.ConnectionString = CurrentProject.Connection cn.Open strSQL = "select user_id from tblusers where ...Show All

• Windows Forms Manipulating background color, size etc. of a textbox that was created in runtime

  Hey howzit, The code below creates a textbox during runtime. But once it's created I also want to access its events like MouseClick GotFocus etc. So for e.g. I press a button and it creates the new textbox. Then when the user clicks on the textbox it must change background color. I cannot access that event in design time, because the textbox does not yet exist. Any clues //create and position new textbox TextBox MyBox = new TextBox (); MyBox.Location = new Point (System. Convert .ToInt32(page.Height - field.Top), System. Convert .ToInt32(field.Left)); //MyBox.Multiline = true; MyBox.Size = new Size (System. ...Show All

• SQL Server Data Flow Source for dbf (DBASE IV) files

  We're trying to read DBASE IV files as a source, but can't find any providers for that format. Will these be included in the final release Is there another way DBASE has always been supported, so it's kinda stranged. Thanks, Dirk Has anyone had any trouble moving a package using a OLE DB Connection Manager reading DBASE IV files While developing I never had a problem, the confiugration string described here worked just fine. Now I'm finding as I move my package to production I can't access any of the files. I will always get a error as follows... The AcquireConnection method call to the connection ma ...Show All

• Visual Basic Streaming text from a view to a file.

  The following code is supposed to place data rows from a SQL Server 2000 view (vwExport) into a text file: G:\doc\Output.txt. The compile error I get is: 'Application.ApplicationDataSetTableAdapters.vwExportTableAdapter' cannot be converted to 'System.Data.DataTable'. Code: Dim strExport As String = "" Dim strExportFile As String = "" Dim x As DataView = New DataView(VwExportTableAdapter) Dim z As Integer Dim y As Integer For z = 0 To x.Table.Rows.Count - 1 For y = 0 To x.Table.Columns.Count - 1 strExport = strExport & x(z).Item(y).ToString & vbCrLf Next strExport = strExport & vbC ...Show All

• .NET Development the server is unable to process the request?

  i implement a interaction (web service) between a sql server and a java mobil phone, now i can directly get a response with a simple datatype from web service, but if i want to receive a response with a custom datatype, i get such an exception: ******************************************************************** SoapFault - faultcode: 'soap:Server' faultstring: 'System.Web.Services.Protocols.SoapException: the server is unable to process the request ---> System.InvalidOperationException: an error occurs when generating the xml documents ---> System.InvalidOperationException: the type System.Object can not be used in this context at Sys ...Show All

• SQL Server Volatile parent key

  I get this message every time i start Server Management Studio Express CTP, i have lates download ie 11/11/2005 V2. Can not create a stable subkey under volatile parent key. I click continue and Server Management Studio Express CTP seem to start OK. Can you help with this. I haven't heard of this one.  I'll need a little more information to investigate this.  Do you have any other Microsoft SQL Server or Visual Studio applications or components installed on the machined   Which components   Which versions Do you see a "Show Technical Details" button at the bottom of the exception messag ...Show All

• Smart Device Development scroll bar with label

  I have a label that is larger than my screen. I am wanting to be able to scroll down so that I can view all of what is written in the label. I have tried to use me.autoscroll = true, but that does nothign for me. How to I make a verticle scroll bar and "attach" it to my label or my whole form so that I can scroll up and down to view all of my text. Can't you just use an uneditable textbox Just set Multiline to true, set the scrollbars to whichever are needed and then set enabled to false. Alternatively to setting the enabled to false (if you don't like the grey colored text) you can catch TextChang ...Show All

• Visual C# Am I missing a seting in my relationship

  Hi I'm a newbie from Delphi and I am trying to build a data application. I have set up my xsd dataset but I think I might be missing something in my relationship. In Delphi when you can set relation ships the same but the big difference is when the dataset goes to retrieve the data. In Delphi a child table only fetches data from the database that relates to the parent table and not the whole table as my dataset appears to be performing. The only way I can seem to stop this is by limiting the query in my dataset to say in the child table only bring but what is in the parent table (customer is the parent table) ie. mySqlCommand ...Show All

• Visual C++ Any way to get a list of QFEs available?

  Is there any way to get a full list of QFEs (quick fix engineering patches) for Visual C++ 2005 It would be nice to browse through them to see if any are applicable to my situation. If you think this is a good idea, please vote http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx feedbackid=244c0587-f75d-4684-9783-8e959b39275f Voted on the primary thread at http://lab.msdn.microsoft.com/ProductFeedback/ViewFeedback.aspx FeedbackID=de16e24b-a9f0-4e6e-82f0-e4a07b4d5a50 Excellent suggestion. ...Show All

• SQL Server Using HTTP Post to secure parameter values?

  It is mentioned in "MS SQL Server 20005 Reporting Services" (good book by the way) that you can get around URL access limitations by employing the HTTP Post method. I have employed the HTTP Post example from the book and parameter values are still exposed in the URL. Am I missing something I have searched the internet trying to get a definitive answer to this issue and came across this blog ( http://blogs.msdn.com/tudortr/ ) entry which states "You can try to hide the parameter, so it will not show up in the report viewer toolbar, or not show the toolbar at all, but parameter values will still show up in the URLs generated ...Show All