I am using vb.net code and sql server 2005. I have textbox in my application which is linked to a sql column. Now I want to check that it should not insert any duplicate record in table. I mean everytime it insert in table the value should be unique. data is inserted in table on button click.
I am using objectdatasource for sql connectivity and FormView for dataentry.
What i am trying to do is to have a fixed initial row heigh of 60. Then the user is to put Data into the empty fields. When it user clicks the add button it will loop until it reaches an empty record and then it will insert the data into a SQL Database. Its simular to my code below but with a DataGrid. Also, this DataGrid is located on a ControlTab. The code below is just to show the logic of what i am trying to do.
Private Sub btnInkjetGenerateTicket_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInkjetGenerateTicket.Click
'Description: This INSERTS and Generates ticket from the InkjetTab fields
[code].....
I have a table with one column auto number key ID. I have an index on another column as unique value. Every time that I try to add a new value into the ddbb that already exist on the index column, I got an alert using on error procedure. This is fine, but since the error is got when the insert command is execute a new ID is created and next time a correct value is added, it means, not duplicated, the ID number jumps. For example.
auto ID=1 new record (OK) unique value
auto ID=2 new record (OK) unique value
auto ID=3 new record (got error) not unique value, no new record added
[Cdoe].....
The question is, there is anyway to check if the value exist before to do the insert() command? or anyway to avoid ID number lost.
The ddbb is open using gridview with sqldatasource.
For my database I need to create unique numbers and insert them in the column "ID". Can I add them via a SQL query? The numbers would simply be 0001 to whatever.I'm using the "Show Table Data" gui.
View 7 RepliesI am using SQLite and what I am doing is passing a simple SQL statement to the database, however I want to also return the Unique ID that the insert statement has been entered to, however I am not sure how to do this within a single SQL statement.
My code is below:
Dim mySQL As String = "INSERT INTO DisplaySetFolderTbl (parentID, folderName) VALUES ('" & selNode.Tag & "','" & Trim(Me.txtName.Text) & "')"
Dim cmd As New SQLiteCommand(mySQL, MISData.Instance.dbDRV)
Try
cmd.ExecuteNonQuery()
Catch
Exit Sub
End Try
MISData.Instance.dbDRV is the connection string
I have a sorted array of files saved in the following format of filenames:
XXX
XXX_XX
XXX_XX_XX
I want to insert a new file (with a unique filename) between two given filenames (which could be in any of the 3 formats above).
For eg., a new file between 401 and 403 could be inserted with name 402 and a new file between 401_01 and 401_02 could be inserted with name 401_01_01. etc
The idea is to conform to the sorted list. Is there a way I could generate filenames for the files to be inserted, given the two filenames between which it needs to be inserted?
In my app, I connect to a table to get the next unique id (t_IDs). The code basicly looks up a specific table name and returns the next value. This is fine in testing, but the application is going to be used between multipul sites. I can see an issue where this may cause the app to slow down while it waits the next id before saving all the data to another table.
My question is, Is there away to set a SQL trigger to go and get the next id value and update the record when a new record is created? BTW - I did look at the uniqueidentifier option (NewId()) but the Id is too long. I need 1,2,3,4 etc.
currently, what i want to do is, add a column in a table "default" during runtime. Well, I've got that covered already.
The problem is, the column names are actually taken from the users input through a textbox or drop down list and of course, if the same column is added already in the table, it generates an error since it has to be unique.
That is why i wonder if it is possible to know if a column already exists without viewing the form which contains the grid view of that table?
Is there a quick way to put unique value to column in a table? Assuming I want numeric values starting from 0.
View 4 Repliescreating 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.
how do i create restrictions whereby there cannot be two similar username in the table, while registering? i am using SQL server.
View 3 Repliesim trying to join two tables together, (this messaging system) and im having trouble with the query.
Select Message_ID, Firstname, Surname , Subject , Message FROM messages, guardian_users INNER JOIN messages ON guardian_users.User_ID = messages.Sender_ID WHERE messages.receiver_ID = 3
and im getting this error: #1066 - Not unique table/alias: 'Messages' (joining tables Messages and guardian_users)
I'm developing a policy administration system and I need to generate a unique policy in this formart
RP000000/HH
Where R is the Region i select from a Combobox, P is the product the client chooses and the auto generated six digit number and HH is the hour when the record was entered in the system. I want the auto generated number to be the ID in my ClientDetails table in my DB.Here is my code of what I have done so far.They want to be able to tell the region and the product by just looking at the policy number.
Private Function PolicyNumber(ByVal intRegion As Int16, ByVal intProductCover As Int16) As String
PolicyNumber = intRegion.ToString & intProductCover.ToString & "000000" & "/" & Hour(Now).ToString
End Function
[code]....
I have run into a problem. When I insert some data into a table with the Insert Function, I want it to return to me Id key.Say a table is like this
ProductId
Product
Quantaty
If I run
Code
Insert Into [table](Product, Quantaty)Values(Cd, 3)
I want it to return to me the value of the ProductId so that I can use it, is this possible?
I have a database, 3 or more tables and a one of them with 3 or more columns.In this table i have ID column, Name Column, Date Column etc.I like to select one record for printing and give to the person one or more Receipt of payment (bill).But every time i like the number of Receipt to be unique. For all persons in my table and all payment.
View 1 Repliesi able to insert the table but i unable update to another table at the same time
my
Imports System.Data
Imports System.Data.OleDb
[Code].....
I do this in Oracle databases just in a snap, but now I have to do it in VB using ADODB and I don't know how to do it.
I have two Access 2007 tables. Table A contains: Col1 (text), Col2 (text), Col3(date), Col4(amount), Col5(text)
Table B contains Col1(date), Col2(amount) What I need to do is to insert into table B the records of table A (col4 summed) grouped by date of table A. The date is a variable contained in a text box so it cannot be hardcoded into the SQL statement.
In an application i am developing, I have to put an entire table in a cell of different table using vb.net . The process of creating a table is completely automated as per the input.
View 4 RepliesI have a form that fills a table adapter with this:
Me.Scratchpad3TableAdapter.Fill(Me.MDRDataSet.scra tchpad3
and what I'd like to do is when users edit something on this form that they post the changes to a table called exceptionsedit which is not part of that dataset. What I don't know how to do is to how to insert those edits to the exceptionsedit table.
I have a csv file that I need to import into a sql table, this portion is working correctly. The code grabs the data, displays it in a datagridview and then imports it into the sql table. What I need to do is add an additional field that will automatically number itself by the amount of rows inserted at that perticaular moment. Let me explain a little clearer. The data I grab from the csv file is a day snapshot broken down to the hour. So lets use todays date 6/28/2010 will be broken down in the csv file like this:
Date
Time
Num#1
Num#2
[code]....
I am having major problems with creating my tables and populating them.The problem for the creating seems to lie when I try to create my table named WeeklyUnitStaffRota. I get the run time error 2147467259(80004005) No unique index found for the referenced field of the primary table. This has only started happening as I have been tinkering with my tables to get them to populate properly.I seem to have a problem when I have two columns with the same info but relating to a different college ie two MSC being run at 2 different colleges.[code]...
View 1 RepliesI 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 RepliesI'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]....
i want piece of code which generates a unique extension for my windows application and that should be opened by my application only. when i click submit button it should save all the details i have entered and should save them as a file of my application type only
View 2 RepliesHow 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].....
Is there a way to auto generate unique number on the form when an application starts up and it should incremente in the dataadapter and database too. How can i set it up?
View 10 Replieswe do have incidents that two different users signing on the same website and seeing other's account, one possible reason is the session id assigned to each sign on user got a collision - although the possibility could be extremely low, but in our case it is not acceptable as long as it is possible. So I am looking for a 100% absolutely secured session id?
View 4 RepliesUnique 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 Repliesi am using visual studio 2005 and database sql server 2000. i want to read table of database and readed data insert in temporary table again update that inserted record.
View 3 RepliesThis 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 ...