Doug 123's Q&A profile

• .NET Development No value given for one or more required parameters- error - oledb to Access.

  Hi, Below is the code i am trying to execute against MSAccess database to return a dataset. And i get the error "No value given for one or more required parameters". strMSUSSQL = "SELECT [Fee Amount] FROM " + strTable + " WHERE" 'get the location text. Select Case strPOS Case "3" , "4" , "5" , "A" strLocationTextVal = "SP" Case Else strLocationTextVal = "GP" End Select strLocationText = " [Location Text] = '" + strLocationTextVal + "'" strSQL = strMSUSSQL + strLocationText strTOSVal = " AND [Type Of Service] = '" + strTOS + "'" strSQL = strSQL + strTOSVal strProc = " AND [Procedure Code] = '" + strProcCD + "'" strSQL = strSQL + strProc objDA = ...Show All

• SQL Server Connection provider for DBF file

  Hi, I want to upload some DBF files to SQL server using Integration Service. I already check every provider, but not found provider for DBF file. Anyone can help me Hello, When you create a data source, just use the provider "Microsoft Jet 4.0 OLE DB ..." Then try a OLE DB Source or a Datareader source over the data source created. Hope it helps ...Show All

• .NET Development ThreadPool on Multiple processor machines

  Hi, I am writing a number crunching server application and would like to be able to split the work across multi processors on my server. Would it be sufficient to use a .Net ThreadPool and queue the tasks on the different threads I am not sure about this because from the operating system point of view all the threads are running within the same operating system process and would therefore not get split across different processors. If this is the case then how can I make use of multi processor architecture on .Net applications Regards Vikram Windows automatically distributes threads among available processors, there's nothing you have to do... ...Show All

• Software Development for Windows Vista Using wimgapi.dll with VB6 - WimApplyImage causes VB6 IDE to freeze?

  I'm writing some code to use the wim imaging api wimgapi.dll with VB6. The code works 100% on capture, with the callback function correctly getting progress information and updating my form with progress bar etc. This works fine when run from within the IDE or from the compiled .exe. The apply image code is a problem though - the WimApplyImage code locks up the IDE part way through. When run from the compiled exe, I get no progress messages to the callback - I do get all the process messages though, and it actually works in that it correctly applies the image, but it stops updating my form until it exits the WIMApplyImage function. Anyone have any ideas I've tried registering the callback both immediately before the WimApplyIma ...Show All

• Smart Device Development lineGetGeneralInfo returns LINEERR_OPERATIONUNAVAIL

  Hello I'm trying to get the IMEI number of my phone using lineGetGeneralInfo but I keep getting LINEERR_OPERATIONUNAVAIL. The line is open and all previous set up calls work fine. I read ( http://www.codecomments.com/archive329-2005-6-517414.html ) that the function is privileged and I would like to know if there is any way I could sign my CAB ( and application so I can do on device debugging ) so that this function works Has anyone ever been succesful in using this function on a smartphone Many Thanks Martin Malek Hi You should find all information how to sign your code in the MSDN article named ' Windows Mobile 5.0 Application Security ' Michael ...Show All

• Windows Forms how can i import excel data to a datagridview

  Hi all. I've been searching around for a easy way to import a excel file to a datagrid. I have tried a few of these examples, but nothing works. Why don't this work: private void button1_Click( object sender, EventArgs e) { DataTable test = getDataFromXLS( "c:\temp.xls" ); if (test != null ) dataGridView1.DataSource = test; } private DataTable getDataFromXLS( string strFilePath) { try { string strConnectionString = "" ; strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFilePath + "; Jet OLEDB:Engine Type=5;" + "Extended Properties=Excel 8.0;" ; OleDbConnection cnCSV = new O ...Show All

• Visual C++ Using Visual Styles in VC++ 6

  Can anybody give me a sample code for using visual styles in VC++ 6. I wanted to display texts using XP's font and style. Urgent. what exactly do you want to look like XP The caption of the window, for example text and drawing should not be affected by or related to XP visual styles. Can you give an example of how they're different ...Show All

• SQL Server How to enable the option of " Create New SQL Server database " from Database Explorer

  Hi there I am working on Visual Web Developer Express Edition 2005. When I right click on database explorer to create an SQL server database then I always find the option " Create New SQL Server database " Disabled. Can any one tell me how to enable that option please You are probably in the wrong forum for this question, but do you have SQL Server Express installed http://msdn.microsoft.com/vstudio/express/sql/ ...Show All

• Visual Studio Express Editions Clipboard Help

  Hello all, good morning :) need some help with this one please: I have 6 textboxes on my form. I need to assign each textbox with a shorcut key (eg. alt + 1, atl+2 etc..) and then copy the contents to the clipboard. I take it that I would have to put the code in a timer event & would the shorcut keys still work even if the form is not displayed on the screen Thanks, Stuart I would imagine that you feel you've clearly descibed what you want and perhaps I'm just dull, but it's still not clear to me. You are moving data to Webbrowser forms and filling in fields Is that any webpage or a page you control Is this your webbrowser of any webbrowser ...Show All

• Visual Basic Is there a Way to Open a Website's Source Code into a Texbox?

  Dim allText As String Dim LineOfText As String FileOpen(1, "http://www.msn.com", OpenMode.Input) Do Until EOF(1) LineOfText = LineInput(1) allText = allText & LineOfText & vbCrLf Loop RichTextBox1.Text = allText FileClose(1) I tried that code and I got an Error stating the URL format is not supported. Thanks! I was trying to make a view source button in a windows application which had a web browser object , I got from the COM tab when I right clicked the toolbox then selected add which then opened a dialog box, I then hit COM and selected the webBrowser object. I had the button get the code from the same url path that the browser.n ...Show All

• .NET Development OraOLEDB.Oracle.1 provider is not registered on the local machine

  I have a working ASP.NET web application in production that I have ported over to a new staging server that I will use for development. Both servers are running identical versions of software, i.e., Windows Server 2003, .NET Framework 1.1, Oracle 9i OLEDB Driver. The production server works fine. When I attempt to run the same application on the Staging server, I get the error: The 'OraOLEDB.Oracle.1' provider is not registered on the local machine. Exception Details: System.Data.OleDb.OleException: No error information available: REGDB_E_CLASSNOTREG(0x80040154). Blogs I've read have suggested changing various registry settings, granting IUSR and other accounts access to the Oracle\Ora92 folder etc. and I'm still getting this erro ...Show All

• Software Development for Windows Vista Automatically starting installer setup.exe in Compatibility Mode 'Windows XP SP2'

  I have a installer that works correctly when running in 'Windows XP SP2 mode' (right click setup.exe, click properties, in Compatibility tab select 'Windows XP SP2'; re: http://windowshelp.microsoft.com/Windows/en-US/Help/bf416877-c83f-4476-a3da-8ec98dcf5f101033.mspx), but will not work correctly otherwise. Is there a way for me to tell the Vista OS to start my setup.exe in that mode without the user's intervention, so that the user does not have to set that setting themselves I'm trying to avoid having the user do extra steps such as running the Application Compatibility Wizard, or manually changing the settings on the setup.exe file etc. Is it possible to create an installer that will startup my original installer in that mode (ie. a ...Show All

• Windows Forms Text Size

  How would you set the size of the text becuase I have this: RtextboxUC thisrichtextbox = GetCurrentTextBox(); thisrichtextbox.TextBox.Font.SizeInPoints = new Font (thisrichtextbox.Font, TextSizeCombo.SelectedItem); but I get 2 erros with the thisrichtextbox.TextBox.Font.SizeInPoints = new Font (thisrichtextbox.Font, TextSizeCombo.SelectedItem); 1:The best overloaded method match for 'System.Drawing.Font.Font(System.Drawing.Font, System.Drawing.FontStyle)' has some invalid arguments2:cannot convert from 'object' to 'System.Drawing.FontStyle' Thanks :) Hi, From the error message 2, its saying that you are passing invalid argument for System.Drawing.FontStyle. Did you try passing the fontsty ...Show All

• Windows Forms How to install windows and web application using a single setup file

  Hi, I have two applications. One is a windows application and the other is a web application. I created two msi's for these projects individually. I want to create a setup file, that will combine the installation of these two files together. Also, i want to know, how to modify the config file to change the connection strings for these applications, after getting the user input for these. Also, provide us with some help on how to create a setup file same like that of the SQL Server 2005. (with same installation steps and the screens). Thanks Prasanna You could use a Web Setup project. It includes the basic folders and built-in custom action support to create Virtual Directories and such. ...Show All

• SQL Server question about different query results with wildcard

  Hi, I'm working with a third party app on SQL Server 2000, and from what I can gather, programmed in C# & VisualFoxPro. When we search with Note contains 94949 we get 571 results, when we search with Note contains 94949* we get 575 results. There should be at least a hundred different entries that start with "94949-1" so I expected the query with the wildcard to return something like 680 results, not an additional four rows. Searching with Note contains 94949-1* got 483 results Note contains 94949-10* got 0 results Could someone explain or point me to more documentation on the difference results we get Thanks Assuming that the application is using SQL Server Full-Text Indexing, t ...Show All