MartinL's Q&A profile

• Visual Basic vb and access

  Hello all, Well I am building an application (as for my final project in the university), and I want some help: I have report in Access, how can I have a button in VB that can call that report thanks Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\accessfile.mdb;") Dim dacv As New OleDbDataAdapter("Select * from table", con) Dim dscv1 as new Dataset Dscv1.Clear() dacv.Fill(Dscv1, "table") DataGrid1.DataSource = Dscv1 DataGrid1.DataMember = "table" Dscv1.WriteXml("C:\queryresult.xml", XmlWriteMode.WriteSchema) finally; you can relation crystal rep ...Show All

• Visual Studio Express Editions Cannot create a new project that opens startup form

  Have been using vb 2005 express final now for a week or too.  Have had no problems using and modifying example code and connecting to a MySQL database.  However i am now trying to create a new project and no matter what form is selected under startup form nothing displays when code f5 is pressed.  Message that build is ok in status bar screen refreshes and back to IDE.  However existing projects work ok.  Even creating a simple one form app leaving default form name as form1 the form will not display.  Any ideas please!    step by step 1 new project windows app 2 add button to form 3 add ...Show All

• SQL Server set parameters in sub-selects

  I'm trying to execute the following statement in a 'execute sql task'. DELETE FROM WORK_EFFORT_PROCESSOR_POINTS_F WHERE (WORK_ITEM_ID IN (SELECT WORK_ITEM_SNAPSHOT_F.WORK_ITEM_ID FROM WORK_ITEM_SNAPSHOT_F INNER JOIN AUDIT ON WORK_ITEM_SNAPSHOT_F.AUDIT_ID_UPDATE = AUDIT.AUDIT_ID WHERE (AUDIT.DW_DATE_UPDATE > ))) I keep getting : "Incorrect syntax near ' '.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. I've tried usi ...Show All

• Visual Basic I am attempting to write my 1st DLL in Visual Basic

  I am using Visual Basic 2005 Express to attempt to write my 1st DLL and keep getting an Entry Point Not Found error when  go to use the DLL even though it compiles.  What do I need to do to fix this problem.         You need to specificy your routines like this: <ComVisible(True)> _ Public Class NetComTool     <ComVisible(True)> _     Public Function Test(ByRef Input As String) As String         MsgBox("You've called Test" & Input, MsgBoxStyle.OkOnly, "")    &nb ...Show All

• .NET Development Type Sharing

  Is there a way to use type sharing in vs2005 With wsdl.exe i can use /sharetypes switch to do this by specifying the wsdl from where I want to share types. It would be great to have some trick to make vs2005 share all types from all the web references in a project. -JR ...Show All

• SQL Server Report Builder limitations

  Can anyone confirm the following 1. Can't add images to reports. 2. Can't have fields in a non-tabular layout (e.g. mailing labels, letters, etc.). 3. Can't control column or row spacing of fields or have details that span more than one row. Thanks. Alrighty then. Can anyone at least tell me if there are any 3rd-party products out there that might be more robust than Report Builder ...Show All

• Visual C# handling exceptions .

  you know when you do a try catch .. and you catch an exception... what do the developpers do with the exception basically what is the use of try/catch i know its for catching an exception .. but what do developpers do with it usually Thanks, I use it to catch any error i feel i might have missed. itz for like saftey puposes for me. If u get an exception while running my program i go fix that problem. I leave the try-catch just incase a user finds the error that i might not have seen. ...Show All

• Visual Studio Team System Microsoft Project Professional and Project Server 2003

  Whenever I publish enterprise projects from project professional 2003 to Project server 2003 the task appear scrambled when viewed in the Project center using Project Web Access. Why is this I'm sorry but this forum is for supporting people with Team Foundation Server issues and we don't have a great deal of expertise with Project and Project Server specific issues. I'd recommend finding a forum focued on those products as you are likely to find better expertise there. Brian ...Show All

• Windows Forms ComboBox filling available space in toolstripbar

  Hello, I updated my application to .NET2 and replaced the old toolbars by toolstripbars. My application does contain an addressbar similar to that  of Internet Explorer with some buttons left and some right of the combobar. The right buttons are right-aligned and are automatically positioned at the right border at runtime. I now want to fill the space between the left and the right buttons with my combobar. But when sizing the combobar in the ToolStripBar Resize event, the combobar gets a bit too large (as the right buttons seem to not yet have been repositioned) and the right buttons are shown as drop down menu. How to prevent this or ...Show All

• Visual Studio Express Editions USING SQL 2000 with VB 2005 Express

  Does anyone know if you can connect and use SQL 2000 Server with VB Epress 2005 datasources tab wizard I use the datasources tab to try to connect but it keeps failing to connect. VB6 seems to connect fine using the data environment wizard. I can connect to the SQL 2000 database with code without any problems in VB Epress 2005. Hi Tommy, Express editions have design support for local data only (.mdf and .mdb files). The version/feature matrix is located here: http://lab.msdn.microsoft.com/vs2005/productinfo/productline/default.aspx hope that helps ...Show All

• Visual C++ Splitting intergers into seperate characters

  I am new to C++.Net and I am also having to take some "refresher" courses in math at the local college. I have run into a problem that i am sure i am "over thinking". The project from my book wants me to design a Console program that takes a 5 diget integer, lets say 45339 for kicks, but the book says any. Using only the modulus and division optrs., "pick off" each character and then print to console with a space seperating each digit. 45339 out puts to: 4 5 3 3 9. I was smart enough to figure out an earlier project that determines if one number is a multiple of another number using the mod, but for some reason i just stare at the book a ...Show All

• Windows Forms selected item in a list

  I'm trying to programmatically select item in a listbox in another program. I figured out the handle to the listbox but I'm having trouble selecting the items in the listbox. I have tried this so far and this doesnt seem to work. Can anyone help me out w/ whats wrong by fixing my code or proposing a new way to tackle this. //I'm trying to setselectionmark to 11th item in the list. SendMessage(tester1,LVM_SETSELECTIONMARK,0,10); //I believe this doesnt change the state of the item so I tried: IntPtr pointer1= Marshal.AllocHGlobal(Marshal.SizeOf(typeof(LV_ITEM))); Marshal.StructureToPtr(lvItem,pointer1,true); lvItem.stateMask=LVIS_SELECTE ...Show All

• Visual Studio VS .NET 2003 Help Integration - F1

  Hi, I am working on integrating a help collection in VS .NET 2003. I have a .HxS file that I integrated with VS .NET 2003, using HelpIntWizardBeta.EXE. So I can see my help in context, index and searching windows. This help collection contains custom compiler messages. So when I compile a file I get my message in output window: c:\test\test1.c(1,10) : warning Q0001:   Custom Message   The problem is when I select the line and press F1 key, the MSDN help doesn’t open to my Q0001.html page. How this thing could be done   Thank you, Ionela Does your solution programmaticall ...Show All

• Visual Studio Team System VS2005 TS RC VPC extraction error

  I have downloaded the file " Visual Studio 2005 Team System Release Candidate VPC (English)", when I extract it, error prompted "Some installation file corrupt. Please download a fresh copy and retry the installation THe extraction error shown in the WinRAR self-extraction box is CRC failed in VSTSRC1.vhd............(this line are in red colour) I have tried to extract the file on different platform but the result is the same!!!!!! Even I download again, the result is the same Hello Franklin,     I dont know if you were given a solution to your problem yet but, if not here is what I d ...Show All

• .NET Development TCP Connections and Web Service Calls (Reposted from WebServices newsgroup)

  Hi Everyone, I have a windows service which consumes a web service on a separate machine in our network. I modified my machine.config to allow my service application to make 200 connections to the server at once, and I spool up to 200 threads at once to make calls to the server. All of this works great and as expected. However I have noticed that by default the underlying connections tend to stay open for about 90 seconds after my web service calls terminate. So if I use a tool like TCPView I can see that I still have hundreds of connections that remain open even after explicitly calling the .Dispose() method of my proxy objects. Is there a ...Show All