In my winform, i m using a datagridview.. I m also allowing to enter data through it. User has to select a product and put in price for it. for products column i have used combo box and for rate column i have used text box.I want that once user has selected a product, he is not allowed to select the same product for other rows... I mean duplicate product selection not allowed... how do I prevent it..
View 11 Replies
If I have an unbound DGV with hundreds or thousands of rows what is the easiest way to find any or all duplicate rows? ie. where the data in all the columns is the same in 2 or more rows.
View 4 RepliesI'm doing a simple database thru VS2008 and Msaccess without using any builtin relationship between records, now i need to know how i can retrieve specific data from access using the oledbadapter or any, example seek if the value from the textbox1.text is already existing in msaccess table then msgbox "Record already exists.", note that the code is in keypress event of the textbox1.
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 have a datagridview with rows and 2 columns the first for staffname the second for the price the first column name is "staff" the second is "price" I want code count's how many time the row have been repeated to count the item price
View 8 RepliesMy browser application has an option to display all the "href" elements of a web page in a datagridview.
I use the code below to populate the datagridview.[code]...
I am trying to delete a row if the program finds a duplicate entry.
View 3 RepliesI have a bound DGV that took a bit of work to get its columns set up. I'd like to show a 1-row version of this identical DGV on a second windows form. Is there a way to programatically place a copy on the second form. I would adjust the height and position of the 1-row version, and create a new binding source on the second form so that I could filter the data.
View 1 RepliesI have a simple database with our customers data. I'm using access database, dataset, and a datagridview. So when I selected a row, I want to make a new row with datas from selected row. Here is my code:
[Code]...
how to prevent duplicate RECORDS in datagridview cell vb.net
View 2 Repliesi've this code to insert records into datagridview
PrivateSubForm1_KeyUp(ByValsender
AsObject,
ByVale
AsSystem.Windows.Forms.KeyEventArgs)
[code]....
the trouble is that i need to evaluate the duplicate item from serialtextbox when the scanner put in the code?
Wondering if there is a way I can duplicate controls and have them work properly? basically, i have a datagridview with code in it plus buttons that do various things to it etc etc. ideally, i'd like to be able to have two of these datagridviews on show. So, user presses button, second datagridview shows. Note that I don't want them to both display the same data - they should both be independetly editable..
View 3 Repliesi'm using below code to save data to sql but i need to save the new data only not all data
table name :
CHECKINOUT
key :
CHECKTIME
[Code]...
Anyone who know how to make a validation for duplicate data?. i have my own code but not working. This is my sample code
[Code]...
i'm got this sql query code in dataset designer
SELECT pkt.fldPackageID, pkt.fldPSID, pkt.fldQuantity, pkt.fldQuantityUsed, pkt.fldRetail, pkt.fldPK, ps.fldName
FROM tblPaketRow AS pkt INNER JOIN
tblProdukDanService AS ps ON ps.fldID = pkt.fldPSID
WHERE (pkt.fldPSID = @param)
I'm trying to display the results in datagridview,i drag from the data source in vs 2008..I can't figure out to do that.I use this code to set the @param on form_load event.
Me.TblPaketRowTableAdapter.JoinTable(SalonDataSet.tblPaketRow, modCommon.s)
In first search, result will show.In second search, the result in first searching will also show with the result in second searching. [code]
View 4 RepliesI have 2 applications that collect data every 5 minutes and imports that data into a SQL Server 2005 table. Every so often the location that I'm quering to get the data hasn't updated thier values so the application is trying to insert duplicate data into the database table. Because I have Primary Keys set on 2 of the 3 columns the insert fails which of course causes an error in my application.What I am needing to do is if it runs into a duplicate insert wait 1 minute or so and then retry running the download data Sub.Each sub calls the next sub in the process line.
Downloadxml sub
call Verifyxml Sub
Verifyxml Sub
[code].....
I have this line of codes here to check if the records exist.
Try
If StudentInfoBindingSource.Find("StudentNumber", StudentNumberTextBox.Text) = -1 Then
ToolStripLabel4.Visible = True
[Code].....
This codes works perfectly but there is a problem, if I close that certain form and reopen it and try to input the same student number, the ex.Message for the Try appears and still the progressbar() command executes although the data will not be saved. I want to ged rid of the execution of progressbar() how can I make it work? And as much as possible I want the message box in Else to be executed and not the msgbox in try catch.
in that form i have 1 button and 1 webbrowser but is there any way i can when the button is clicked.it takes some data from the website and duplicate all of the data so like if there is a integer on a website and its the number of the viewers on the websitecan vb take the data and duplicate with another number and show it in a label.
View 3 RepliesI'm trying to automate a data entry. I have a form with several textbox, combobox, etc.. and i will like to know if there is a way to get a specific row of data from a binding source and duplicate it so I can then simply make the necessary changes to a few columns.
View 3 RepliesI'm using the following code to write the data and schema of a dataset to a XML file.
[Code]...
I have this data in txt file and the data keeps changing all the time.
[code]...
I would like to read all lines and compare, if the same name and same address is found, which is in the [......], then i need to count it and show the most frequent buyer!should i read it all and put in array, and compare and put the duplicate data and count into another array?
i have this sql table
Table name: Project
Fields: PrjCode, PrjName
i want to save my Project codes and name to this table, but before i will save the data from my form i want to check if the user input (PrjCode) already exist in the database. and if the prjcode exist it should not allow to save the entry since it will duplicate. (NOTE: ProjctCode is not auto number. the user will input it)
base on this scenario have this code
If PrjCodeTextBox.Text = "" Or PrjNameTextBox.Text = "" Then
MessageBox.Show("Please Complete the information required!", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error)
[Code].....
How to save data in datagridview using vb2008.
View 1 RepliesTable gpass has data as
gate-----date-----c----bno----acccode----tittle----weight-------qty
1----18/01/2010---a----2--------2----------abc-----10.00-------15
Then there are two textbox having values as
txtgat.text=1
txtdat.text=18/01/2010
I these codes and it generates error message as ArgumentOutOfRangeException was unhandled.Idex was out of range. Must be non-negative and less than the size of collection. Parameter name: Index
Private Sub txtGat_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtGat.TextChanged
If Len(Me.txtGat.Text) > 0 AndAlso Me.txtDat.Text IsNot Nothing Then
str = "Select * from gpass where vou_no= " & Val(Me.txtGat.Text) & " And Date = '" & Me.txtDat.Text & "'"
dt = GetTable(str)
[code].....
I have 4 DatagridView's. I want to take the data from 1,2,3.. and then place it on 4. (I am adding some images). The Names in 1,2,3.. Should correspond with that is 4. SO ,,that means i want to accumulate the totals of each player and place it in the final DataGridView.
View 1 RepliesI'm new to VB and as every beginner i've begun with a browser, i've added a combobox that records the current url of the website and adds it to a "history" combo box, the problem is that when i go on a site once, the site name shows up multiple times in the combobox. I was wondering if there is a code to only add a certain value only once,
Private Sub WebBrowser1_DocumentCompleted(ByVal sender As Object, ByVal e As
System.Windows.Forms.WebBrowserDocumentCompletedEventArgs) Handles WebBrowser1.DocumentCompleted
[code].....
I am creating a program and calling it 'Dcrews Task Machine', And It's a Bot for some useful Info! I have googled this before searching and searched the forums!It's not a bad Bot in actual fact it is a good Bot and helpful/useful! It does tasks on your computer as you choose from a selected list or record as you wish to do! What I am trying to do here.. Wait! I should mention and include info of my Cursor so far..It is a form with a picturebox (Picture of Cursor myMake)The reason being as i want my own cursor as instead of the system cursor is it is my theme and i would like a nice cremy colored cursor to do the job/task!What I have already managed to do is make it move to places!What I wish to know is how do I make it click (I know how to make the system cursor click but not this) When it clicks i want it so it clicks from the themed app Cursor instead of the system cursor!
View 9 RepliesHow could I make the datagridView to unload data from database. I mean, once you make datagridview, it will load data from database so I would like to make it to not load any data. This is for searching purposes where you want to display datagridview look like empty and when user enter information to search in, it then has to display data.
Something like Students.datagridView.
I have a little big problem in one application.
I have a datagridview with data from a datatable, this datatable have these fields (id,num1,num2, date,user,ref,qt,cost,center), some of them are hided in the dgv (id,num1,num2,date,user). The user can edit,delete and add new rows to the dgv.
I have a save button that performs this actions:
First check if there are new rows, and if yes it fill the hidden fields. Then validate the inserted values by the user with a couple of ifs. In the end, i call the bindingsource EndEdit, and call the adapter Update command against the datatable...
This sometimes works others not really, i don't understand why.
The error it's: "Concurrency violation: the DeleteCommand affected 0 of the expected 1 records"
I think sometimes when Updating it occurs to.
