Click here to Skip to main content
Page 1 of 5
Page Size: 10 · 25 · 50


Author filtered by: Mike Meinz [x]
Answer 2 May 2013   license: CPOL
As you requested, the following Stored Procedure returns a count of how many routes it finds. If the input parameter contains an invalid route (one that does not exist in the table), the count is unreliable. With your input parameter, the following Stored Procedure yields a count of...
Hi Jeff by Mike Meinz
Forum Message 2 May 2013  
Nice to see you contributing on CodeProject. I miss your presentations and our discussions a General Mills. You're been a great developer evangelist and teacher. ;)
Answer 1 May 2013   license: CPOL
See Microsoft documentation for DateTime Structure[^]The documentation shows that the DateTime Structure can be used in C# and C++.
Answer 1 May 2013   license: CPOL
The reference manual is a good place to start:DigitalPersona Developer Reference Material[^]The developer support web pages may have information that could help you:Developer Technical Support [^] and DigitalPersona Developer WebPortal[^]
Answer 30 Apr 2013   license: CPOL
1. STUDID looks like it is a number and not a string. Therefore, do not put apostrophe around STUDID in the query. 2. If the table is named STUDENT, then you need to correct your query to SELECT from STUDENT instead of STUDDET.3. The .Text property is already a string. You do not have to...
C#
File directory control by Mike Meinz
Answer 25 Apr 2013   license: CPOL
You can do it all using the System.IO Classes in the .NET Framework. Upon click on directory name in the left preview pane, use System.IO.FileInfo class to retrieve details of each file found via the Directory.EnumerateFiles method.Some examples that you can learn from:How does...
Answer 25 Apr 2013   license: CPOL
I found several articles via Google using the search string add entries to windows context menuHere are just two of them: Adding Entries to the Standard Context Menu[^] How to Add Any Application Shortcut to Windows Explorer’s Context Menu[^]
Answer 24 Apr 2013   license: CPOL
I used this code to retrieve the name of my SQL Server and it worked fine on my PC with Visual Studio 2012 and SQLExpress 2012. public void Main() { // Retrieve the enumerator instance and then the data. SqlDataSourceEnumerator instance =...
C#
Answer 24 Apr 2013   license: CPOL
1. Create a Class that implements IComparer.Compare See the example in the ListView.ListViewItemSorter property documentation.2. Set the ListView.ListViewItemSorter[^] property to the IComparer.Compare Class.Quote:You can use this property to provide custom sorting, for example, when a...
Answer 24 Apr 2013   license: CPOL
I found this via a Google search using search key problem timeout uploading file greater than 30mbUnable-to-transfer-files-over-30MB-with-the-Web[^]
stopping SQL for input by Mike Meinz
Answer 24 Apr 2013   license: CPOL
There is no "popup" like PL/SQL in SQL statements in VB .NET code.Your user enters the value to be found in a TextBox on the form. You use that TextBox value as a parameter to the SQL statement. In my example, I trim spaces from the beginning and end of the TextBox value because sometimes...
Answer 22 Apr 2013   license: CPOL
Here is an example of how to run another program from within a VB .NET program. Dim process As New Process Try ' The program to be started by the Process Class: Dim pgm As String = "C:\Test\MyTestProgram.exe" ' The string parameter to...
Answer 21 Apr 2013   license: CPOL
Please look at SQL Server Configuration Manager and ensure that the SQL Server Browser is running.In the following posting from the Microsoft SQL Server Forum, there are several other tips that may help you. See Problem sharing SQL server over a home network[^]
Answer 21 Apr 2013   license: CPOL
I looked up the SHGetFolderPath function on MSDN and found that the documentation named the replacement function. See SHGetKnownFolderPath function[^]
C++
Searching second listbox by Mike Meinz
Answer 21 Apr 2013   license: CPOL
You have your closing parenthesis in the wrong place causing the first IF to be always true.I also added a line of code to remove spaces from front and back of ziptextbox.Text in case user accidentally types spaces before or after the zip code.Furthermore, the Label.Show method is for...
Answer 21 Apr 2013   license: CPOL
I use Microsoft's ClickOnce (the Publish feature in Visual Studio) if my users are all on a local area network or have access to a web server. Otherwise, I use the free InstallShield Limited Edition software that owners of Visual Studio 2012 can download to create a setup program on a USB Flash...
Answer 18 Apr 2013   license: CPOL
testDataLabel.Text = testDataLabel.Text & typeListBox.Items(typeIndex).ToString & " " & guests.ToString & " " & totalCharge.ToString("C0") & vbNewLine
Re: Great story! by Mike Meinz
Forum Message 18 Apr 2013  
Fortran II does sound familiar. Your memory is better than mine.
Re: Great article by Mike Meinz
Forum Message 18 Apr 2013  
Wow! Thanks for those very kind words! Whoever you are?
Answer 18 Apr 2013   license: CPOL
Create a task in TASK SCHEDULER. Put the web page URL where the program name would go. The web page will have to be designed so that it generates the report and any other activities without requiring someone to click something.
SAP Connection in csharp by Mike Meinz
Answer 18 Apr 2013   license: CPOL
Here is a CodeProject article on using the SAP .NET ConnectorSAP .NET RFC Server with SAP.NET Connector 2.0[^]
Article 17 Apr 2013   license: CPOL
Welcome to our continuing series of CodeProject interviews in which we talk to developers about their backgrounds, projects, interests and pet peeves. In this installment we talk to Mike Meinz, who shares some highlights from 45 years in the industry.
Answer 17 Apr 2013   license: CPOL
Add this to the beginning of the source file using Microsoft.Win32;This works fine for me. I tested it!Registry.SetValue("HKEY_CURRENT_USER\\Software\\ZSPL", "Asset", "AssetManager");Your second statement Registry.setvalue(my project); won't work because SetValue letter case is...
C#
Answer 17 Apr 2013   license: CPOL
I don't have MySQL but here is what it looks like in Microsoft SQL Server Transact-SQL. This example handles the situation where there are no hours during the holiday and returns 00:00:00 for that case.-- Create temp table for demonstrationDeclare @tb table (emp_name varchar(30),time_in...
Answer 16 Apr 2013   license: CPOL
Put the full path name of the image file into the BackgroundImage property of the form.
C#
Answer 16 Apr 2013   license: CPOL
See Spy on a Folder to Detect When it Change[^]See FileMonitor[^]See Watching Folder Activity in VB.NET[^]See Advanced FileSystemWatcher[^]See Folder Listener: A Tool to Watch File System Activity in any Folder [^]See FileSystemWatcher - Pure Chaos (Part 2 of 2)[^]
VB6
My vote of 5 by Mike Meinz
Forum Message 15 Apr 2013  
Excellent job! When I was in the Navy from 1967-1971, I did Autocoder, SPS and RPG programming on IBM 1401, also. Mostly Autocoder!
Answer 14 Apr 2013   license: CPOL
Encrypt the data!The .NET Framework has crypto classes that you can use to encrypt and decrypt data as you put it into and retrieve it from the database.
Answer 12 Apr 2013   license: CPOL
I use this in a BAT file to do a scheduled backup of my SQLExpress database:In the files below: * Change mycomputer to your computer name. * Change mydatabase to your database name.Contents of mydatabase_Backup.bat:C:cd C:\Program Files\Microsoft SQL Server\110\Tools\Binnsqlcmd...
C#
Answer 12 Apr 2013   license: CPOL
I suggest changing the definition of your database so Date and Time are in one column of Data Type DateTime. It usually is easier to have the date and the time together in one column.try{using (SqlConnection cn = new SqlConnection( "Your connectionString goes here")) using...
C#
Answer 12 Apr 2013   license: CPOL
Remove the code Block2, put it in it's own Sub. Call that Sub from the appropriate ComboBox and Button events.
From where to start .Net by Mike Meinz
Answer 12 Apr 2013   license: CPOL
The current version of Visual Studio is Visual Studio 2012. The current .NET Framework version is 4.5. See #define Visual Studio[^]
Answer 11 Apr 2013   license: CPOL
Compile in Release mode rather than Debug mode and get the EXE from the /bin/Release folder.
Answer 10 Apr 2013   license: CPOL
Using Google search with keywords windowstate maximized hides taskbar, I found this article that explains that this is a problem with WPF. Are you using WPF? You didn't say.See Maximizing window (with WindowStyle=None) considering Taskbar[^]The article says that the problem only occurs...
Answer 8 Apr 2013   license: CPOL
Better help could be provided if you included DDL for pertinent columns in the database tables, real samples of data in the database table and real samples of 'FormTime' and 'Totime'. Also, you did not say what the problem was. "Not working perfectly" could mean a syntax error or the wrong rows...
Answer 6 Apr 2013   license: CPOL
Here is a query that is a simple extension of the original query that I put in the solution to your original question on 9 March 2013. I just added a check for the date to the two subquery Where clauses.select distinctCE.Emp_Name,(select min(Emp_Time) from Raw_Record As MINCE where...
Answer 2 Apr 2013   license: CPOL
Once again, Google answers the question. Factorial Calculator[^]Factorial Program using C#[^]
C#
Answer 2 Apr 2013   license: CPOL
The easy solution is to change all of the SELECT statements within the CASE statement to SELECT TOP 1. That, however, may not be the correct solution. It could be that the CASE statement is the wrong thing to use for your business requirement. You should study the data and determine if...
Answer 2 Apr 2013   license: CPOL
According to the Help file for SerialPort.DataReceived:The DataReceived event is not guaranteed to be raised for every byte received. Use the BytesToRead property to determine how much data is left to be read in the buffer.That tells me that the DataReceived event is raised before all 10...
DBF file name truncated by Mike Meinz
Answer 2 Apr 2013   license: CPOL
You're not showing us the ConnectionString but I suspect that the driver in the ConnectionString is causing this issue. Perhaps because the .DBF extension dates from the DOS era, the filenames are created in the old DOS 8.3 format. Via a Google search, I found this article that talks about...
Answer 2 Apr 2013   license: CPOL
You have a syntax error in the commands that you are sending to PowerShell.Change your code a bit so you can see the error message from PowerShell. In Visual Studio Debug mode, capture the value of "c" just before you assign it to startinfo.arguments and use it in an interactive PowerShell...
inner join in asp.net by Mike Meinz
Answer 31 Mar 2013   license: CPOL
"SELECT userinfo.user_id as User, userinfo.User_last_login as [Last Login], orginfo.Dept, orginfo.Div FROM UserInfo INNER JOIN OrgInfo ON userinfo.Org_Code=orginfo.org_code WHERE userinfo.User_ID='" + txtUserId.text + "';"
Answer 30 Mar 2013   license: CPOL
There are some good ideas in the following links. There are many more on Google, available using search keywords how to disable print screen key C#Low-level Windows API hooks from C# to stop unwanted keystrokes[^]plz help me ,how to disable print screen?[^]how to disable “PRINT...
C#
Answer 30 Mar 2013   license: CPOL
After you have successfully deleted the row from the database, execute the following code. try { File.Delete(@"C:\foldername\" + imagefilenamegoeshere); } catch (IOException e) { }
Answer 30 Mar 2013   license: CPOL
You are not capturing the result of the NetworkStread Read method. The result tells you how many bytes were read. In Socket_Control dll:... Dim intLengthRead as Integer = serverStream.Read(receiveData, 0, 10000) Return...
Tip/Trick 29 Mar 2013   license: CPOL
The COM Interop Runtime Callable Wrapper (RCW) is a "Black Box" that creates references to memory that need to be released before the called program will end.
Answer 27 Mar 2013   license: CPOL
This version compiles. You weren't clear enough to say whether it was a compile error or a run-time error. If your problem was a compile error, this version resolves that. Because it is C# code, the upper and lower case must match. I corrected the clauses to use upper and lower case like this:...
C#
Answer 27 Mar 2013   license: CPOL
Write a separate Stored Procedure for each need.
Answer 26 Mar 2013   license: CPOL
The system generated error message box will allow you to "View Details" and the StackTrace which can tell you which of your methods is the location of the error and the actual line number. Using that information, modify your program to add Try...Catch blocks around all of your code that is...
Answer 26 Mar 2013   license: CPOL
The error message that you provided says that the expected parameter is "@ASAm_FIRMA_PRES_JD' but you show in your example code that you are setting the parameter name to "ASAM_FIRMA". The name that you use when you add the paramater has to match the name that the SQL Server expects....

Page 1 of 5
1 2 3 4 5


Advertise | Privacy | Mobile
Web02 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid