Search results for query: *

I have the code below and I am trying to get the progress bar to update as the files are moved. SO far no luck I am not sure what I am missing or what I have wrong with the code. Any help is appreciated. I am trying to move 500 records for testing purpose Thanks RJL public WEPK_Data_Mover()...

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...

Hello everyone. I have a piece of code that I am working on to print some container labels. The application allows the user to put in the quantity they want to print and the code loops that many times executing the stored procedure which returns a container ID with check digit already...

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...

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...

I have the following piece of code that searches a directory for a file containing a specific order number and return the full path. Depending on the directory it searches it can take some time so I like to run this using the BackgroundWorker but I am not sure how to pass the resulth (full path)...

Hellow again, I need to read a file(.txt) and get a particular row. the file containes a sngle row per order shipped. This an sample of how the data looks. For this sample file I need to read the text file by using the tracking number 848257570000106 and when it findthe row with the tracking...

Hello, I have a small application which is a work in progress. My next step in this applications is to allow the end user to search files in a directory for a file containing a specific string. The application has a text box where the end user enters an order number. I want to search a folder...

Hello folks I been wracking my brain trying to figure out how to calculate time in minutes and seconds. I have these 2 date time values DECLARE @STARTDATE DATETIME DECLARE @ENDDATE DATETIME SET @STARTDATE = '2/7/2013 9:51:54' SET @ENDDATE...

I am new to C# and trying to learn how to best get a particular value from and XML. I have the following URL (http://maps.googleapis.com/maps/api/distancematrix/xml?origins=Paris+TX&destinations=Sherman+TX&mode=driving&language=en-EN&sensor=false&units=imperial) that returns and XML document...

I have an application that runs a stored procedure to retrieve all invoices based on Reference ID and populates a data grid (dgResults). All this is working fine. However the databse is large and poorly designed and takes a while to return the results to fill the datagrid. While this is being...

I have a sting that contains a qty (in this case 50) that I need to extract. I am having trouble trying to get just he 50 out of the string below Quantity Received=50;Detail Row=1; Any suggestion on how to get this value from the string. My field type is text in the DB Thanks RJL

I have a query with a Months field. I need to get the value from another table based on the value of the Months field on the main query. Employee table has the Months field EmpID Months 161 48 600 140 benefits table has the MaxVacation BenID MaxCumAvail...

I'm working on a form that will return information from a DB. When the user presses the search button it wil lexecute a Stored Procedure (SP_WEPK_X12_LOOKUP_INBOUND01). This stored procedure will return 6 columns EDI_TRANSACTION SEND_PARTNER REFERENCE_ID RECEIVED_ON SA_CTRL_NUM ACK I like ot...