[URL]...From this link, it explains the formula of how getting the critical level of the products, but I can't imagine how to automatic-compute it because every month and every year there's a computation to be done
View 3 RepliesI have a program that prints using the printdocument control. How do I check for errors in the program. Sometimes the program prints ok, sometimes the print does not print at all or give any feedback about the status of the print.
Bireirectional printing is enabled on the printer.
The program prints barcoded orders to a barcode label printer. The supplier's only cue to supply is the printed barcode label. I can see in the program that the orders are getting queued, and at certain intervals a timer runs to update each available order's status to "printed".As far as I am aware, there is no "Error" event of the printdocument control, and the printing is an asynchronous operation. So how should I check?
In my projects (WPF) I use System.Windows.MessageBox to show the user a confirmation dialog for operations that are critical, such as a delete-operation.
My problem is that if I specify as button value MessageBoxButton.YesNo, the user cannot use the escape-key to cancel the operation. IMO this is one of the most annoying things, a program can do, showing a dialog without the possibility to cancel/close the dialog through the escape-key.
Other possibilities are MessageBoxButton.YesNoCancel, but IMO this is confusing because it shows three buttons for only two operations . Or one can use MessageBox.OKCancel, but this is IMO not clear enough. In my dialogs I want to ask the user if her really wants to execute the operation. And for this, a simple ok is not appropriate. A yes (I want) is much better than an ok (go on).
How do you handle this? Is it a non-topic or do you think as I do and have an own MessageBox-implementation or do you know a possibility to extend the System.Windows.MessageBox-class?
i know how to show errors from event viewer but i am not able to show critical errors of system from event viewer
View 11 Repliesjust if you are using Microsoft Access Data Connectivity Components 2010 in your application to read data from mdb access files, you might get unexpected exceptions and your application will crash!To reproduce this behavior the best way is to run my sample application which will allow you to see the bug directly in no time.This behavior may occur at any time, any where, but I found if you use Application.DoEvents, you increase the chance to run your application to crash.To reproduce ::
1. You should not have any Office version installed on your system (I am using Windows 7 x64).
2. install the Microsoft Access Database Engine 2010 x86 (or x64 and you'll have to set your project to x64).[URL]
3. Download and run my sample application in VB.NT 2010, and press the button, you will get it [URL]Where is Microsoft going, do you think?Should I hope to receive an official response?
I am creating an Excel add-in written in VB.NET. I would like to bind KeyDown and KeyUp events to the spreadsheet to record when the user presses and releases the arrow keys while navigating the spreadsheetIdeally, these events would be built into Excel alongside the native SheetActivate and SheetSelectionChange events, for example. Alas, they are not.
View 1 RepliesIn Visual Basic 2008, there's two different ways that I know of to accomplish the same thing:The Dim on the member level:
Dim counter1 as integer = 0
Dim counter2 as integer = 180
Public Sub SampleSub1()
[code].....
I have created a simple program which uses a two tier structure of SQL Tables.At the top level, one record holds the date of the activities and linked to it using its primary key as a foreign key, three subordinate tables hold time stamped records.The issue I have been unable to solve is that before adding any of the lower level records for a given date, a newly added top level record must be saved to the database.Doing this manually is simple - but can I rely on my users to remember to do this before they start plugging in the lower level data?I thought not, so I am looking to save the top level automatically.I've failed miserably but I refuse to believe that it's not possible.
View 14 RepliesI have multiple level of For Each and in each level, i have a Linq that is the 'In' criteria as in:
[Code]....
It will go inside each for (because the value is not nothing), however, it will only loop (next) in the very inner 'For Each t In tFor'. After it is finish inner loops, the outer Fors' or Next will not execute... even thought there are more than one values in that 'In'... like 'sFor' or 'fFor'. i've noticed while debuging, while break at the for (for example 'sFor', before stepping in), i get the error message:
"Enumeration yielded no results" when i expand the result for that variable and it will not step into it. but if i do not expand the result, it will step in. It seem that some how, once an element is accessed for that 'In' collection, it breaks (meaning does not loop for the rest of the elements) the next for that collection is this a bug or am i missing something in Linq? BTW: i believe it has something to do with the SqlDataReader in the Linq. I'm working with IAsyncResult.
I want to copy datatable to dbo.Products
View 9 RepliesI have build a program until now with an MySql database. The programs add records for the customers and the products of the company(Its works perfect).. I am trying to build now the Orders the last part of my project but I have a little problem.. First of all I need 4 different type of database:
Cash
Credit Card
Check
Debit
Price Offer
This is the the type of the payment. The user must add the order by the payment of customer so we need to seperate each one.. Unitl here I am fine::
Now, my serious problem is with the order table:: If i used the code that I use for my other adding records (like product and customers ), for each order it's add only one product!! BasicallyI need to be able to add multi products and the user have the ability to change the price of one product:: for example "to make an offer for some special customers" without change data into the database of products..Thats has a lot of typing code but I need a base to start since I have a little bit of confused. At the end am trying to load data from database customers into text boxes:: for example the user select one name that loaded into a combobox and then appears the city and the mobile into a text boxes I build a code below but it's works only One type, actually fill the text boxes but after I clear all the boxes and try for a new customer or the same isn't fill anything.
Dim ServerString As String = "Server=localhost;User Id=root;Password=root;Database=test" ''Sting Server
Dim SQLConnection As MySqlConnection = New MySqlConnection ''SQL Connection
Dim Sql3 As MySqlCommand = New MySqlCommand("SELECT * FROM customers", SQLConnection)
[code]....
I was trying to do a 'Latest Products' page for an eShop project I'm working on. asically, I want to show a number of products, say 10, from a table in my db that where added in my database in the last 30 days or less.irst I tried to use the GridView function in VB.NET, where it auto-populates the table but can't be limited and then I tried this SQL statement, which isn't working, giving me an error.
SELECT *
FROM Product
WHERE DateAdded > (SELECT DATEADD(d,-30,(SELCT MAX(DateAdded) FROM Product)) AS "Last 30
[code].....
I got database with products of restaurant. What i want: I Want to create cocktails with multiple products (products are registered in database). When i put cocktail in the sales list, i want when sales complete, automatically to change stock of included products in the cocktail. I attached a screenshot to be more clarity. If u help me, i apreciate this.
View 2 RepliesI want to grab Top 10 most Ordered product by customer... Im counting how many lines that this product have been ordered .
Sample data:
ProdName
A
B
C
[Code]....
Ive done this in other database using LIMIT 10.. but here in SQL server the result of that query is the bottom record's
i have to write a program that will calulcate the percentage growth of four catagrogies of products a company sells that sells fruit.
Grape $565.000 $600.000
banana $600.000 $520.000
strawberry $150.000 $325.000
pineapple $75.000 $82.000
the result has the be a percentage.heres is my code so far.[code].......
I can't seem to figure out how to write this query properly. I've tried various combinations but nothing's worked yet.Below is the relevant portion of my database model:
I need to select the products that match a given Category and Group, and that match a given Year, Make, Model, submodel. This I've done below: ItemList = From P In gDataContext.Products.Include("Groups").Include("Groups.Category1").Include("LookupYearMakeModels") From G In P.Groups Where G.Category = Cat And G.Grp = Group From Y In P.LookupYearMakeModels Where Y.Year = YMM.Year And Y.Make = YMM.Make And Y.Model = YMM.Model And Y.Submodel = YMM.Submodel Select P
[Code]...
IN one application, I need do the following: When user press one button, show a combo box with ptoducts kinds, and the application create a new record in the database. Next, and automatically, I wanna another form to be opened, with all the complementary values of this products, for the operator complete the values.My problem is: The form cant be the same, cause each kind of product show one different form Open the detail form, how can I know what record ID was created??
In later use, the products will show in DGV and double click works. But at the product open, I wanna this form apeear automatically.
I'm trying to make the following snippet work in VB6 but it's one error after the other. can anyone make heads or tails of this?
Basically i'm after a little proggy which will store the names of a couple of products, calculate product code (first three and last three characters of product name) produce a list of products stcked with their initial stock levels, allow info on products be search for, allow the products to be purchased.
CODE:
U0161 import a Platinum level Advisor .jar to use with this Platinum level product key.How I can get this and import it to continue my completion of setup of mysql download?From where I can download that file?To enable this application, please provide a MySQL Enterprise Product Key or your MySQL Enterprise credentials.
View 1 RepliesI'm currently trying to create an Information System of customers who does have different prices for one generic set of products. For example, there's a list of customers, then once you choose one, the system will show a generic product list but a set of price list specifically encoded for that specific customer. I'm sorry but i'm not that good with databases, and I'm using ms access as the database and VB.Net as the programming language.
View 1 RepliesI'm trying to generate a report that shows the products ordered for a given customer.
I'm getting an error on the line that states:
lblList.Text &= rowInvoices(
"ProductCode")
& " "
& rowInvoices("Quantity")
The error message states: Column 'ProductCode' does not belong to table Customers.
I have three tables: The Customer Table, which points to the Invoice Invoice table via the CustomerID.
Also, the Invoice table, which contains the product code, points to the Invoice table via the InvoiceID.
If possible I'd like to bring in the Products table to get the Product description.
[Code]...
Here is a link to a FREE whitepaper relating to;"From Hack to Counterattack: A Guide to Protecting Software Products Against the Top 8 Piracy Threats"in case any of you want to get it? url...If you do not want to enter your details on the above page then go here: url...Try the World's Strongest Software Protection Today.You can download the Sentinel HASP software DK Version 5.10 right now or request the full Sentinel HASP DK at no charge. The standard Sentinel HASP DK enables you to test Sentinel HASP with both HASP SL (software) and HASP HL (USB dongle) protection keys. The software DK enables you to test Sentinel HASP with HASP SL protection keys only following a simple software download.[code]
View 6 RepliesI have a datatable which contains a column (ProductName) and it has 10 rows (products). This number of rows in this table varies.The database table (Products) contains 2 columns (ProductID and ProductName). Is there a way to retrieve the ProductID and ProductName from the database table Products by using the datatable instead of creating a one big SQL statement using WHERE clause using?
View 14 RepliesI have a datatable which has rows of product names. I have a table in SQL Server which has product details, with ProductID.I need to retrieve the ProductID for each product name. I can do this using a for each loop but this is way to slow. Is there a way to retrieve the relevant ProductIDs for the products with one transaction rather then using the for each loop?
View 3 RepliesI am having trouble opening 2007 office products with in a webbrowser control. 2003 office products did open, but for some reason 2007 won't. I have read about rolling my own activex document container, but I don't know where to start. [URL]
View 9 RepliesI'm trying to make the following snippet work in VB6 but it's one error after the other. can anyone make heads or tails of this?
Basically i'm after a little proggy which will store the names of a couple of products, calculate product code (first three and last three characters of product name) produce a list of products stcked with their initial stock levels, allow info on products be search for, allow the products to be purchased.
[code]...
We receive an HTML document in an email which has some special pricing and products. I want to be able to parse the data, perform some lookup operations on it, assign some pricing markups, save it to a data source for future referance and do it with VB.net and a web browser. I'd really like to use MSHTML.HTMLDocument, but all the documentation I have is based on HTTP URL's, but since these HTML pages will be opened from an eMail or saved to a fileshare, they won't have the HTTP. I've also tried to read it as a text file and parse with RegEx, but it's not very effecient and to be honest, RegEx is still a fog to me.
Would anyone be kind enough to suggest a way to do this? Is MSHTML able to do it and if so; how do I set up a reference to a non-HTTP URL?
I've got 2 seperated programs.
One is a program where you can select a product and select how many of them you want. Then the total price wil be displayedin a label. And the list of selected products will be saved in a .txt file.
The second program is an Edit program. The user can edit his selected products. Here he can change the total of a product.So if he had selected 1, he can change it to three or something. When the user clicks the button Save. The changes will besaved in the same .txt file and the total price will also be changed and displayed in program one.
Program one is compleet.Program two has problems and here i need your help:- the user can't make a change in the numbers, seems that the textbox is read-only or something. How to solve?- Then when i click save, the changed must be saved in the .txt ( i can't test this yet because no changes can't be made)- the total new price must be showed in program 1 (i think i programmed this well, but can you take a look)
Here is a part of my code of program 1:
CODE:
I am making a minor basket system which the user selects a number of products from a datagrid and it adds them to a basket using an array list (arrItemID).However on the ViewBasket form I want another datagrid however a query is formed listing the selected products. Though the datagrid seems to be empty (though the query when outputted to a text box is ideal. [code]
View 3 RepliesTrying to build a project that lets users click an item from a list of products (tabbed form). Once an item is selected (check box) find a way to store that item.Then when the user has finished selecting items they can click a button showing what they have selected in a new form that will open.Whats the best way to store what items they select? An Array?
View 2 Replies