I am upgrading a system that has a Product Table with a Product No Field.This is a string field but most of the existing product Nos are numeric but all over the place.I want to provide a default numeric Product No when the Users are creating a new product record.All I can think of is to use the Identity Field [ProductID] and test to see if it has been used and if so keep incrementing to find the next free numerical, available No.A better solution would be to start at 1 and increment to find the first available but it looks to be several hundred records into the Table. how to find the first available number?
when setting a column to identity it will auto increment 1,2,3,4..however if you delete 4 & 5 and then insert another record it will go in as 6.If you do this a lot you end up with huge gaps in the numbers,is there any way to make SQL default back to filling in the gaps and only count higher if there are no gaps?I know I can do it in the application, or even a UDF, I just want to make sure I am not reinventing the wheel?
How to find the correct DashOffset and DashPattern to fill in the gaps with another color within a dashed line if the 1st DashPattern has an array of mixed values? If the 1st array for a DashPattern is like this though? myPen.DashPattern = New Single() {20, 15, 30, 45}
I am using VB .Net to access the eBay API and store all completed orders in a database. This database is then fed into a proprietary shipping system, which can not handle an order number larger than 20 characters. eBay returns an order number like so 230407279314-680141236013 which is too long. The order number is always 12 numbers a hyphen and 12 more numbers. What I need to do, is turn this (the result can be alpha numerical) into a shorter, unique order key to store in my database alongside the true orderId (so that this can be referenced by the shipping software instead of the actual order number). The reason for the 20 character limit is the barcode algorithm used. Is there any way to achieve this in VB .Net 2010? This number can be anything unique, so long as it does not exist already (even a good uniqueid function would work, but I would have to query the database to make sure it isn't taken)
How generate the unique no. 1,2,3 and so on .... on button click of each new user ..
the code mentioned below is a readwrite coding in vb.net ...
but the problem is it generate the same id for different users on button click event... but i want the no. of times button clicked the new ids will be generated
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim FILE_NAME As String = Server.MapPath("counts.vbi")
Unique constraint - these columns currently doesn't have unique values..?? I have created Unique Constraint with 3 columns. My code works perfectly but once - two users @ same time entered same data and somehow it saved in DB; after that incident. This UniqueConstraint gives me error - These columns currently doesn't have unique values. How can I check if user enters this kind of entry or how can I restrict the Entry?
I was wondering what the best approach is for sharing a menu across all wpf windows/views. My Application doesnt really fit the navigation model, so will probably use a Ribbon control. I am leaning towards creating a user control for the menu and dropping it on each view, but have also seen Josh Smith's msdn article, where he loads user controls.
I am working in vb2008. Is there a simple way to clone the contents of a datarow in a datatable into a new datarow instance that can be added elsewhere in the table. Can I create a new instance of a datarow and set it equal to an existing datarow?
Say I have a connection to a database. After reading some stuff I want to connect to the same database. So I naturally use the first database mysqlconnection.serverstring the password and username is not included in connect1.ConnectionString. So how can I do so? Is this by design?
I'm attempting to run different tasks in there own processes, waiting until each is done while keeping the UI responsive. So far it works exactly how I want it until I try to reuse some of those processes....here is a sample of the
Private WithEvents TaskOneProcess As Process Private WithEvents TaskTwoProcess As Process Private WithEvents TaskThreeProcess As Process
[code]....
This is a over simplification of what's going on but it gets the point across. So it works exactly as expected, a button is pressed and the sequence starts. As each task gets disposed it recalls the StartFixing statement which then calls the next one in order until they are all done. BUT when I go to do it a second time the Disposed never fires assuming since it's already disposed. How do I recreate the same named process so it can be reused and still have it fire the disposed event?
I have a set of controls and code behind them that I'd like to reuse on multiple forms. How can I do this? I know of reusing code via modules, but I'm not sure how I can add the same controls and their underlying code. If I achieve this, will changing data on one form affect the values of another form when they're both open? For example... Cbox1's selected item affects the choices within Cbox2, and Cbox2's selected item affects the choices within Cbox3 (and so on). So if I do something on Form1's Cbox1 and it changes Form1's Cbox2, will it NOT change Form2's Cbox2?
Not sure if this has been asked before (couldn't find an answer), but is there a way to reuse a user.config file from a previous version of the application? For example a user.config file is stored in:
C:UsersJohnnyAppDataLocalCompanyApplicationName.exe_Url_wxcnyrmstqy3oj1qwckdjq3gjqkq4fel1.0.0.0user.config After a new version is installed it gets stored in:
C:UsersJohnnyAppDataLocalCompanyApplicationName.exe_Url_wglmejvw01nagu5t1y5yl12chynjomny1.0.0.1user.config The user then has to enter all settings again, even if the new version does not save more settings. An other problem is that although the user.config file is very small, it does get messy after a while when newer versions of the application get installed. Is there a way to clean up the unused user.config files and their folders?
It's the same problem with System.Windows.Forms.Application.LocalUserAppDataPath, that I'd like to use to save other files (containing Listview data), which points to:
C:UsersJohnnyAppDataLocalCompanyApplication1.0.0.0 The Listview data and other files created by the app can't be used anymore.This can be solved by getting the user's appdata folder with Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) and creating a new folder there with the name of the application. But this means there's one folder where the application is installed (user can choose this folder in the installer), one folder to save my own files to and one folder where VB stores the user.config file.
Can something be done about this "mess" or is this just something I have to live with?
I save the size of a form to a variable (One Size or two Integer variables--doesn't matter), and then I close the form. Before reopening the form, I set the form size to the size I saved before--which by all accounts of logic and reason should exactly the same. Except, no, it's not. On one system the form "grows" horizontally and vertically by 15 or 16 pixels. On another system the form grows only vertically 15 or 16 pixels. I'd love for someone to explain this perfectly insane, yet MS typical, behavior to me.
created a menustrip (MenuStrip1) by dragging the tool onto my form (form1.vb). And designed the headings/items etcI have now created another form (form2.vb) within the same project.I would like to use MenuStrip1 that i designed for form1.vb in my new form2.vb.
I am very familiar with modules from my time with VB and my other programming, but what is the most commonly used practice and the best way to go about this for a website application with ASP.NET? Say I have multiple pages (in multiple directories; some in the root directory, some in child directories from the root) that will call the same set of functions and subroutines, how do I go about putting this reusable code in a place where the pages and their respective classes can call the functions/subroutines?
First of all, I wasn't sure whether this was VB.NET or General Developer content... It's not technically about VB.NET code, but it's not very general either since it is specifically about Visual Studio. Feel free to move it if required.A while back I realized that all of my database connection code was getting very biolerplate. had 'developed' my own method of connecting to an Access database and storing the results. Basically, for each table I create one 'Manager' class and one 'Entity' class. The Entity class represents a single record in the database and has properties for each field.
Sub emailConfirm() Dim email As String = txtMail.Text Dim name As String = txtPrenom.Text + txtNom.Text[code]....
note:I want to send Link contains a unique identifier and verify the unique identifier in the login.aspx.I don't know when to do this...I found nothing interesting on the net ...
I have an application the contains several excel files bundled with it. I'm not opening the files and processing them within my application. These files contain a data-connection to reload all of the pivot-tables within each excel file. I have a 'link' on my form, that when clicked, it determines which file to open and calls a sub using filename and executing Process.Start(filename) for any excel file I want to open. I have no problems opening any one of the files and then exiting excel.
The problem is when I 'close' a file, but don't exit Excel; then try to open another file(clicking link on form)... it creates a new instance of Excel.
I know from experimenting that the fileopendialog form will 'reuse' an existing Excel instance, IF it does not already have a file open.
How can I do the same thing without using the fileopendialog?
I don't want the end-user to have access to the folders where these files live. That's why I have multiple 'links' on my form, one for each xls that already exists. I just want them to be able to click on a link and the xls file opens AND if they choose to merely 'close' a file and not exit... Don't create a new instance of Excel, but re-use the existing one.
how unique is this ? will i ever get duplicates ? and will it ever change ?... i want some way of relating my software to the customer .... is there a system GUID?
Function GetCPUID() As String Dim sReturn As String = "" Try
I'm making a sign in/out program using mysql and visual basic and need a little help I have two tables event_in and event_out and under each table I have event_id, which automatically generates a number(starting from 1) for each row. I was wondering if it's possible to generate the numbers based on the users. So let's say User A comes and signin, 1 is generated into the event_id. Then User B comes and signs in. I want 1 generated for him too...so all User A's event_id will be 1,2,3... and each user's event_id for both the in and out table will also be the same.
With this I will be able to subtract each user's timestamp in event_out from that of event_in to get how long they were in. I believe that if I don't generate the numbers separately for each user, then let's say User A signs in (1 is generated for event_id in the event_in table) but does not sign out yet and then User B comes and signs in (he get 2 for the in) but then he signs out before User A does and he gets 1 for the out and user A gets 2 for the out. So now user and with my current query I will not be able to calculate the timestamp.
i would like to get the unique catlogs, so from this list i want to extract only 7190, 7192, and 7193. i have a script that puts it into a dropdownlist by using:
DropDownList1.DataSource = dv DropDownList1.DataBind()
I want to generate a unique ID in VB.NET that starts with ASXXXXX where XXXX represents a number. The number has to start in an orderly fashion. This ID will then be stored in a SQL Server express table.
I'm a non developer user of VB. I'm using a simple form to input data to a database. have some text boxes bound to data and use a Binding navigator. I want to be able to handle or catch the error when a non unique ID is added. I have tried to include an error handler in several places but the exception is generated anyway. For example I select to add a new record the change the id to a duplicate value and navigate to the previous record and get the error. I want to check or validate the value before it generates the error to avoid the program crashing if someone includes a duplicate id.
Is GUID really unique? I have a webservice that the client application connects to, which generates a GUID. I know GUID are generated using the mac adress of the NIC. Is the NIC in the webservice server used or the client NIC?
I have a database (using Sqlite) that has ID has a primary key with autoinc, that loads the values into a listbox control. If I loop through the database normally, adding the values of the database into my listbox, I can't get the ID by using SelectedIndex because the Index will not always be the same as the ID, and the ID will not always be the Index. :( This makes it painful when I want to query to delete the row, based on SelectedIndex.
I want to delete the row by ID, but I have no way of getting that ID with the loop I use Is there some hidden field type attribute I can use?
Primary key must be unique....while inserting data into the database,i need to check whether the data already exist in the primary key column or not.......If not then only data will be inserted in the database else a msgbox will be displayed and data will not get inserted in the database....
