- Strength to Increase Rep
- +6
- Strength to Decrease Rep
- -1
- Upvotes Received
- 25
- Posts with Upvotes
- 22
- Upvoting Members
- 16
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
I am a self-employed IT Professional with 16+ years of "pc hacking". I worked my way up from break/fix to MIS Director of a 150 seat law firm in Hartford, CT before going independent in August 2008.
- Interests
- C++, VB.Net, VBA, XBox FPS
- PC Specs
- (Usually) HP Elitebook 2740p, Core i5 M240 @ 2.53Ghz, 4GB RAM, Visual Studio 2010 Pro, SQLExpress 2008
82 Posted Topics
 | Here's [some source code](http://archive.msdn.microsoft.com/Connection/Release/ProjectReleases.aspx?ReleaseId=3863 "Data Connection Dialog") at MSDN for the Data Connection Dialog that was ?packaged/affiliated/an add-in? for Visual Studio 2005. Alternatively, there's [this project](http://www.codeproject.com/Articles/59796/UDL-Net-A-ConnectionString-Editor-Built-from-Scrat "UDL.Net Connection String Editor") at CodeProject.com.  |
 | You'll probably not want to increase the "stock on hand" until you take delivery. What I recommend is to track that amount in a separate column, "On Order"  . If you have MSAccess, there's a pretty good inventory layout in the Northwind sample database. See screenshot inline. (yes, …  |
 | FWIW, I also see some text editor bugs, but cannot replicate them on demand. Using IE Version 9.0.8112.16421 on Windows 7 Build 7601: Service Pack 1; *it seems to be after a big paste operation*. For me, I've only noticed issues with placing the cursor back to the end of … |
 | |
| | Codeproject has a webservices intro, with a client-side console application to consume it. [Click Here](http://www.codeproject.com/Articles/8257/How-to-make-a-simple-WebService-and-consume-it) to view the article. |
| | Google has a custom search API, [Click Here](https://developers.google.com/custom-search/v1/overview) for the overview. What are your specific requirements? How many websites do you need to be able to view? How much of each website do you need to "block"? Is this for a class project, just killing time, or what? |
 | |
| | While you're at it, put some error handling in... Imports System.Data.SqlServerCe Public Class Edit_Sensor_Form Try ' Shared variables Dim con As SqlCeConnection = _ New SqlCeConnection("Data Source=|DataDirectory|\Database1.sdf") Dim myDA As New SqlCeDataAdapter Dim myDataSet As New DataSet Dim DataGridView1 As New DataGrid Dim ret As New SqlCeDataReader Dim mySelectQuery As …  |
| | Assuming that the "windows login" you are referring to is actually the browser prompting for credentials, try this example [here](http://vbcity.com/blogs/jatkinson/archive/2009/12/12/programmatically-entering-and-data-using-the-webbrowser-control.aspx). |
 | In order for the other computers on the network to access the DB hosted on your computer, you will need to leave SQLExpress running. The other machines would then use a connection string something like: `connectionString="Data Source=" & YOUR_COMPUTER_NAME & "\SQLEXPRESS;InitialCatalog=" & YOUR_DATABASE_NAME & ";Integrated Security=True;User Instance=True"` Where YOUR_COMPUTER_NAME is …  |
| | For your "Service Based Database", you are using MSSQL? |
| | Have you looked at `schtasks.exe`? There is a section of documentation [here](http://technet.microsoft.com/en-us/library/cc766266.aspx) on MSDN that gives an overview of the requirements for running a task on a remote computer. |
 | Try [this](http://www.daniweb.com/software-development/vbnet/threads/441295/set-connection-string-at-run-time-in-vb.net "Set Connection String at Runtime in VB.Net") discussion, see if any of the suggestions help you. |
| | We need the exact text of the error message. Clean and rebuild in Debug mode, see if you get the same error. I take it you get an error when running it somewhere other than your development machine, correct? Almost certainly a permissions error, or missing|unsupported assembly |
 | The `GROUP BY` clause allows you to associate the Average values with a specific item, if you just want them to display in a different order, look into `ORDER BY` |
| | # Have you ever tried using the String.Compare method for a case-insensitive string comparison? # The [documentation](http://msdn.microsoft.com/en-us/library/zkcaxw5y(v=vs.100).aspx) on MSDN for the overloaded method: 'Declaration Public Shared Function Compare ( _ strA As String, _ strB As String, _ ignoreCase As Boolean _ ) As Integer states `Compares two specified String …  |
 | Do you actually have 15 physical Serial Ports? I don't know for certain, but I suspect that you cannot just arbitrarily decide to give yourself another serial port without the appropriate hardware - at least not using this method. I don't see any mention of a "virtual" port in the … |
| | What do you have so far for requirements, design, and code?  |
| | No idea, since I don't use Crystal Reports; but they have a lot of documentation and community support on their website [here](http://scn.sap.com/welcome), Sample Code and SDKs [here](http://www.sdn.sap.com/irj/boc/samples). |
| | Known issue. First hit on a Google Search.... Click [here](http://search.sap.com/ui/notes?id=0001525432&boj=/sap/bc/bsp/spn/scn_bosap/notes.do?access=69765F6D6F64653D3939382669765F7361706E6F7465735F6E756D6265723D30303031353235343332&ssocompatible) for workaround. |
| | Please confirm that I understand. If I understand correctly, you can: 1. Determine which database to connect. 2. Connect to either database per user choice in ComboBox. 3. Retrieve the correct data. **All at runtime** Is that correct? |
| | Too late, the OP is banned now...  |
 | |
| | I believe you need to provide a the connection and logon properties separately for Crystal Reports. I haven't had a chance to look into it yet, but have seen that mentioned in other discussions. You might try the Crystal Reports SDK [here](http://scn.sap.com/docs/DOC-27465), and look through their discussion groups to see … |
 | Confirmed. Both methods have 2 overloads, Save method has same overloads LoadFile(String) LoadFile(Stream, RichTextBoxStreamType) LoadFile(String, RichTextBoxStreamType) |
 | I've seen it for at least a week or two, I just "assumed" it had always been there, but unnoticed by me... :) |
| | Send the text to Word first, then use Word to print it. **Did you search the forums first?** If you search the forum for "Word RichText" you'll find 6+ pages of discussions - I'm sure some of that code can be adapted to your needs, [this one](http://www.daniweb.com/software-development/vbnet/threads/441075/send-text-to-word-#post1897194 "Send Text to …  |
| | How about some table defs and data? Would that help? Lethugs had sent this out on a previous post, I do not know whether the db structure has changed since then, but I suspect not - as I suggested rethinking the design and his reply indicated that he was "constrained"... |
 | If you step through the code, what is the value of e.Index on Rows 58 & 59? You should use a loop for that incremental count too. You'd have to put the textboxes into an array in the order you want them filled in, then just loop 0 to 59. … |
| | Do you not need the bookmark after the first insert operation? A quick look [online](http://word.mvps.org/faqs/macrosvba/InsertingTextAtBookmark.htm) shows me that unless you redefine the bookmark after inserting the text, it's lost. Can you not just set the page layout for different first page, then let Word decide when to page break? |
| | Clean and zip your project, then upload please. It sounds as if you may have copied the databindings when you copied the textboxes, you should have gotten a compile error if that were the case however.  |
| | What is the text (and details, if any) of the error? |
| | What method did you use to databind the combobox? |
| | Don't you need to add the row *after* setting the values? |
| | When you say "Column 8" is that a 1-based count, or 0-based as in Columns(8)? I'm only seeing Columns 8 & 9 in your Select statement, unless you changed the DataGridView column indexes to start at 1. Assuming the DataGridView does indeed have a 0-based column index, your `BackColor = … |
| | Truncate table does just that - there are no empty rows after running that command. What you are probably seeing is whatever SQL has for the default value on that column. *This is more of a SQL question, rather than VB specific* |
| | In the future, please "clean" your project/solution before compressing and uploading. It saves everyone time and diskspace... |
| | Per a quick read at DigitalPersona.com, *ftp* is a legacy Fingerprint Template format, their newer formats are *fid* and *fmd* - with *fmd* being the enrollment data. That same quick read did **not** tell me definitively what format their data is in, although they hint at it being an image … |
| | [This](http://www.hushpage.com/WinExit/winexit.html "WinExit") might work for you... |
| | Post should be in Web Development |
 | This is that same project I already helped on, right? If you zip and upload it to rapidshare, I'll take a look |
| | Post the code you have so far. |
| | The first two things that come to mind are this: 1. Does pdfSharp require an assembly on the client machine 2. Does Acrobat exist at that path on the client machine |
| | Create a parameter for your SQL query. See [this](http://www.daniweb.com/software-development/vbnet/threads/252333/sql-query-where-clause-and-vb.net) discussion for sample code. |
| | Why are you filling the ComboBox from the SelectedIndexChanged event? I would've used the `Form_Load` event to call a `FillCombo()` subroutine. The ComboBox supports "TypeAhead" natively with the [AutoCompleteMode](http://msdn.microsoft.com/en-us/library/system.windows.forms.combobox.autocompletemode(v=vs.90).aspx) & [AutoCompleteSource](http://msdn.microsoft.com/en-us/library/system.windows.forms.combobox.autocompletesource(v=vs.90).aspx) properties. There is also a sample project [here](http://www.codeproject.com/Tips/104971/AutoComplete-ComboBox-Control-From-Database) on CodeProject that fills that source from a DataTable, the code … |
| | Have you tried putting the data in a ListView and then printing that? |
| | It looks to me like you need to start over... 1. Item One: Only one of your arguments to the class method match a variable in the class 2. Item Two: That's an endless If..ElseIf..Else..End If statement, use a loop 3. Item Three: I would pass an array of checkboxes … |
| | You need to set the ImageIndex or ImageKey property for each item. See [How to: Display Icons for the Windows Forms ListView Control](http://msdn.microsoft.com/en-us/library/z4ka5fex.aspx "How to: Display Icons for the Windows Forms ListView Control"), and [How to: Extract the Icon Associated with a File in Windows Forms](http://msdn.microsoft.com/en-us/library/ms404308.aspx "How to: Extract the … |
| | > How do I set the if exists to actually match the phone number from data table, as opposed to simply checking whether or not if there is any data on that field? Assuming your input has been validated so that it *has* to be either an exact match or … |
| | If you can't ping the other IP address, you'll never get it to work... 1. Turn off any firewalls on both computers 2. Assign/Configure their IP addresses (DHCP, Static, Static DHCP, or Automatic Private IP Addressing) 3. Ping each computer from the other, using the IP's you posted above - … |
The End.