Preferred Method For Generating Locally Unique Identifiers?
Aug 31, 2010
I'm looking for a method of generating unique identifiers for a record class being created locally and then persisted in various formats (XML, SQL, etc.) I've seen people using DateTime and GetHashCode, but that seems to lend itself to duplicate identifiers depending upon the sample size. GUID is a bit overkill, as I don't need anything that unique (large) at the global level. I'm also aware of using GUIDs and GetHashCode to get the size down a bit, but duplicates tend to crop up here as well. Any best practice or method for generating simple unique identifiers?
View 3 Replies
ADVERTISEMENT
Aug 14, 2010
Question: When you have a .NET GUID for inserting in a database, it's structure is like this:
60 bits of timestamp,
48 bits of computer identifier,
14 bits of uniquifier, and
6 bits are fixed,
128 bits total Now I have problem with a GUID, because it's a 128 bit number, and some of the DBs I'm using only support 64 bit numbers. Now I don't want to solve the dilemma by using an autoincrement bigint value, since I want to be able to do offline replication.
[Code]...
View 3 Replies
Jun 11, 2012
This is newbie VB question. My son is learning VB and I am learning with him. We have RichEdit control application (non WPF), where we input text, formatting its Style (bold, italic, underline, etc.). Our next task is to save the text together with its attributes into the file. The question is: what type of serialization is preferred at this case?
View 3 Replies
Jan 4, 2010
I have a situation in which I must execute a dynamically built stored procedure against tables that may, or may not be in the database. The data retrieved is then shunted to a VB.Net backed ASP based report page. By design, if the tables are not present in the database, the relevant data is automatically hidden on the report page. Currently, I'm doing this by checking for the inevitable error, and hiding the div in the catch block. A bit kludgy, but it worked.I can't include the VB code-behind, but the relevant stored procedure is included below.However, a problem with this method was recently brought to my attention when, for no apparent reason, the div was being hidden even though the proper data was available. As it turned out, the user trying to select the table in the dynamic SQL call didn't have the proper select permissions, an easy enough fix once I could track it down.First and foremost - is there a better way to check for a missing table than through catching the error in the VB.Net codebehind? All things considered, I'd rather save the error checking for an actual error. Secondly, is there a preferred method to squirrel out a particular OLE DB error out of the general object caught by the try->catch block other than just checking the actual stack trace string?
SQL Query - The main gist of the code is that, due to the design of the database, I have to determine the name of the actual table being targeted manually. The database records jobs in a single table, but each job also gets its own table for processing data on the items processed in that job, and it's data from those tables I have to retrieve. Absolutely nothing I can do about this setup, unfortunately. [code]
View 1 Replies
Jun 17, 2010
I don't know if I can do this here...but here goes. I want to generate a unique ID of fixed length The trouble is, the code example I found on the web is in C# (or C maybe) which I know nothing about. I tried a web-based C# to VB.net converter but the result doesn't work so its hard to understand what's going on (especially since I have not worked with bytes either this makes it more difficult).
[Code]...
View 5 Replies
Nov 24, 2011
How would I go about doing this, is there a for next loop involved and is there a way not using the for next loop ?
View 15 Replies
Dec 6, 2009
creating unique IDs for each row in a table, to avoid duplicates when inserting the data to a server. The table looks like this:
+--------------+----------+------+-------------+
| brikkenummer | tid | post | anvendt_tid |
+--------------+----------+------+-------------+
| 3086360 | 09:43:02 | 98 | 09:43:02 |
[code]....
"Brikkenummer" is the number of a device that each person carries with him/her, and "tid" is the time the runner has passed a specific post. The post he/her has passed is described in the column "post".Out of these three columns, is it possible to generate some kind of unique ID? The ID that is generated have to be the same if a row is displayed twice or more, to avoid duplicate entries.
View 2 Replies
Jun 18, 2009
I need to generate a globally unique ID of fixed 16-lengthThe GUID is too long for my purpose. So I wonder is there any way to convert it to a 16-length?If this is not possible, I have a program key of 8 chars, and is thinking of using the DateTime as my key.
View 4 Replies
Mar 12, 2012
generating unique ids for invoices,customerids and employee ids, etc. and thought it would be great to share this as i will use it within my aps all the time now.[code]
View 7 Replies
Jan 24, 2011
I have a .net dll and when I add it in the references, it goes without any issue. The problem is that its namespaces start with an integer e.g. 3gppsa5.org.AlarmIRPSystem and when I try to use or import it, the intelliSense doesn't allow and says identifier expected.I don't have the source of this library so I can't change it. I know it is compiled and the Object Browser is correctly showing all of its classes and functions. However, I am unable to use it in my code. Is there any way to use it in VB .NET
View 2 Replies
Oct 10, 2011
I have a form, user logs in and another form is generated. User submits a query. My problem is that I cannot keep a record of who is making the query.
The user has a uid and usernamae but once the new form is generated where the user submits the query both these identifiers are gone. Is there a way in which I can overcome this?
View 2 Replies
Mar 26, 2009
I'm looking for a list numeric type initalization identifiers for both C# and VB.Net.[code]
View 3 Replies
Aug 31, 2011
ALTER PROCEDURE [dbo].[generateTrackNo] AS
DECLARE @tempYear VARCHAR(5),@tempMonth VARCHAR(5)
SET @tempYear = Year(GetDate())
[code].....
View 1 Replies
Feb 13, 2012
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)
View 2 Replies
Jan 10, 2009
I'm using the datagridview. This is the sample data:
[Code]....
How do I parse through the grid to rename the duplicate values in a particular column (in this example it's the l_name field) into such a format?
[Code]....
View 1 Replies
Nov 26, 2009
I am attempting to send a string to a textbox in the webbrowser control and the page I am trying to do this with has random name= and value= fields which makes it difficult to use the typical methods for placing text in the textbox. I have spent quite a bit of time searching and attempting to figure this out and I'm stumped.
[Code]...
View 6 Replies
Mar 21, 2011
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")
[Code].....
View 1 Replies
Dec 6, 2010
why is it that we have a date and a datetime which are exactly the same thing, and is it preferred to use new Date or new DateTime?
View 4 Replies
May 8, 2011
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?
View 2 Replies
Jan 28, 2011
I have an ASP DataGrid and I'm applying sorting to it. Well, as I was looking at an example, they had a function similar in function, different in name, to[code]...
View 3 Replies
Apr 12, 2011
I have 4 rounding options: None, Standard, Up, Down If they choose None and the number is 108.7879, I just want to display 108.78 with no rounding. I know I probably can use Math.Ceil for Up and Math.Floor for Down, but I am not sure what to use for None or Standard.
[Code]....
View 4 Replies
Jan 25, 2010
Which language is preferred by most developers especially targeting .NET & silverlight? Is it C# or VB.NET?
Are there any advantages/disadvantages of both languages when compared with each other?
View 6 Replies
Jan 31, 2012
I have adopted a technique where I pass existing objects to forms so that they can display the object's content and allow the user to alter it if necessary. The form is not bound to the object, so when it comes time to act, the form sweeps up the content of its controls and puts them into the object. The object is then validated and any issues reported to the user. If the object is valid, it may be handed back to the caller so the caller can refresh a view/list/etc.
So far, so good. However, if the form's content, or lack of, creates an invalid object and the user does not correct it, maybe cancelling the form, there's a chance the form will hand an invalid object back to the caller. This is not good.
Essentially I'm looking for an elegant and efficient way of either leaving the object as it was or rolling back if the user cancels the form/action.
I have considered a range of techniques, each with many pros and cons. I'm keen to consider some other views.
View 3 Replies
Aug 5, 2011
I need to add attributes to certain controls in a Windows Forms project. It needs to look something like this: [code] I can go in and edit the designer file to get more-or-less the desired effect, but those designer files sometimes come with the caveat that they are automatically-generated files. I'm worried that the designer might overwrite any changes that I make to the file. That said, is there a way to add attributes to controls using the designer or is there some way that I can add the attributes in a separate file?
View 1 Replies
Jun 14, 2011
I'm modifying an existing form in Visual Basic 2010 Express and attempting to work out some small kinks I've noticed. The one that I'm having an issue with is getting the form to completely fill the screen without the border going off screen. When I set the form's Size values at W:1024,H:768 the page always opens a little off. I tried setting the size a little smaller, W:1020,H:764, and it still does not perfectly fill the screen. Does the Size value include the border pixels or are the border pixels added to the form's Size value? Is there another value somewhere that could be affecting this?
View 5 Replies
Jan 6, 2012
This my working method to send a email
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 ...
View 1 Replies
Oct 19, 2010
Consider a MyForm class that contains a shadowed implementation of Show(). It also contains a CreateForm() method, which accepts an instance of the form and calls the shadowed sub:
[Code]....
View 3 Replies
Jul 1, 2010
Well whenever I reference a file I have been doing so using the full C://location/here kinda way, but my next program will be on CD so I need to figure a way to locate files that will be on the CD drive.In other languages I have used, %A_ScriptDir% and then go from there, is there something similar in vb?
View 10 Replies
Nov 15, 2011
I a function belows which is being used to preview an image but that involves saving the image locally in my drive. I am using this feature in an data entry form which means if the user discards the form, I have to delete the image which I feel is not efficient. How can I go about previewing the image and only save it locally if the user saves the form.
Protected Sub save_btn_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btn_Save.Click
If uifuVouTypeUploadfile.PostedFile IsNot Nothing Then
[Code]....
View 1 Replies
Jan 29, 2011
How to connect locally on server machine?
View 1 Replies