Search results for query: *

The label appears but the % is not updated either. When it is done the message box and label are updates fine

500 records take about 23 seconds

Style of the progress bar set to "Blocks" = Yes Enabled=true = Yes

Sorry forgot to specify. The list is prepared OK and the stored procedure to move the files executes but the progress bar never shows any progress at all.

I am using Visual Studio 2012 Microsoft Visual C# Compiler version 4.6.1586.0 for C# 5 Thanks

...reader = cmd.ExecuteReader(); reader.Close(); cs.Close(); int percentage = (i + 1) * 100 / rowCount; backgroundWorker1.ReportProgress(percentage); } FileList.Clear()...

Hello I am struggling getting my DatagridView refreshed when the confirmation form closes. Here is the layout of my application Form_Appt_Main - this has the datagrid which on load populates with all the appointments schedules. I have a button btnNew which opens Form_Appt_New Form_Appt_New -...

Hello, I am trying to control my Windows Form Menu Item based on a list of access (already in place) by user. When the form loads I am getting the current user name and getting a list of forms the user has access to. So my store procedure return a list like this Receiving 1 Receiving 2...

I have been trying for a while to get his to work. I have a table that list the root folder, sub-folders and reports in a database. I am trying to bind this to a TreeView in a windows form My raw data looks like this Type IDParent NameParent ReportName Root NULL Management...

Hello I have a new project. I have a table with customer number and a numeric value that represents the number of record I need to retrieve. For example Customer Records 042 10 317 25 I want to be able to run my query against my item master table and get 10 unique...

Hello again, I been trying to get my query to return a NEWID for each group in my results. Here is what I have so far SELECT NEWID()M WAREHOUSE, ITEM, SUM(QTY) AS 'QTY' FROM INVETORY GROUP BY WAREHOUSE, ITEM This returns something like this NEWID...

Hi folks, I got this issue where I need to flag certain records so I can process them differently (or not) based on the count of the number of items per line number. My data looks like this. ERP_Line_Num Item Count 001 0083104 001 0210901 002...

...a better way it would be greatly appreciated Thanks RJL Here is my code namespace MOD10 { public partial class Form1 : Form { // ********************************************************************************** // Connection Strings //...

Thanks for the response. It turn out the customer had only sent the middle of the manufacturing date. There was a leading alpha character and a trailing digit so this is what I came up with after a couple of hours of playing with it. DECLARE @mfdate VARCHAR(7) = 'S405061'; SELECT...

Correct

Sorry I should have posted that. We are going under the assumption that is current decade since we do not think they have product 10 years old coming to us since it perishable items. Thanks

I have a customer that is goign to be sending us a manuafacured date in the following format YMMDD Example 40506 Year = 4 Month = 05 Day = 06 I need to convert this to a YYYYMMDD so 40506 would be 20140506 Any suggestions on how to go from a single digit year to a 4 digit year is...

Hello, Ran into this and there may be an easy way to solve but I cannot seem to find it. Any help is appreciated. I have a list of order and the qty that the requested. However some of the order are for the finigh goods item and the components that make that finish item. So for example I have a...

Thanks for the super fast response. Will try first thing in the a.m.

OK is been a while but I am in need of some suggestions. I have a new request to get a report for out invetory records that show invetory that is whitin a certain number of day from the expiration date. The problem is thta each family of items has a different days to expoire value Here is some...