i have imported some data from excel and into datagridview but does anybody know the code to compare data in 2 columns to see if they are equal and if they are not equal a messagebox would show "there are errors" else it would show "there is no error, you may continue".
the attached file is an example of the excel data i imported to datagridview.
I have 2 DataGridViews, each has a similar column:
DGV 1 has column named "LOCATION"
DGV 2 has column named "FC_STORE_NO"
The problem I face is that the data contained in each is just a BIT off of what I need to compare them. LOCATION has the store number as a 5 digit number, usually 3 digits with 2 leading zero's, but not always. The FC_STORE_NO has the number stored with no leading zero's. I need to loop through the the first DGV's rows, comparing this LOCATION column to the FC_STORE_NO entries to find a match, but I don't know what my condition would be to match the two..
For example:
I need 00577 to match 577
00001 to match 1
00026 to match 26
Any way to convert that DGV field to the correct format (5 digit) before displaying it would work too?
I finally got this code to work:
vb
Dim path As String = OpenFileDialog1.FileName
Dim myDataset As New DataSet()
Dim strConn = New OleDbConnection("Provider=Microsoft.ACE.Oledb.12.0;Data Source=" & path & ";Extended Properties=""Excel 12.0;HDR=YES;IMEX=1""")
Dim myData As New OleDb.OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn)
myData.Fill(myDataset)
DataGridView1.DataSource = myDataset.Tables(0).DefaultView
Now that I figured that out I was going to try and place the data in a specific location. On my application I have a datagridview set up with 4 columns. What I would like to do is put column A of the excel file under the 1st column of the datagridview and column C of the Excel File in the second column of the datagridview.
So replace:
vb
DataGridView1.DataSource = myDataset.Tables(0).DefaultView
With:
vb
DataGridView1.columns(0) = myDataset.Tables(0).columns(0)
DataGridView1.columns(1) = myDataset.Tables(0).columns(2)
Obviously this doesnt work, and something tells me I might need a for loop to import the data, but I have never imported information from an Excel file before and to make it worse I have never worked with datagridviews before so I have no idea how to go about this.
I would like to do something like this if I could:
vb
For x = 1 To xldoc.rows.length - 1
DataGridView1.Item(0, x).Value = CType(xlDoc.Cells(0, x + 1), Excel.Range).Text
Next
In my application I read data (using data binding) from an Excel spreadsheet into a DataGridView. This works, but the data columns contain text fields (strings). I would like to set the data type for some columns to "Date" and Decimal. I cant do this on the DataGridView (error: cant change properties for data-bound stuff) and I cant figure out how to do it on the dataset or data-table that I bind to the DataGridView.The following is the code I use to read and bind the data:
Using con As OleDbConnection = New OleDbConnection(cs)
'
'open the OleDbConnection
[code]....
The commented out code (below the 'Todo: comment) causes a additional table, but I want to change the table with the data.
I'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
i need to be able to compare data from a text file with the collection of a combo box.My algorithm currently populates the combo box with data from the text file on the form load event.I have included an update button that updates the combo box collection.[code]
View 1 Replieshow can i compare both datagridview by using ID?
example 1 : ID 4016.. the data from client looks edited on filename "New Divide(beta)".. so, that ID will put into listbox..
example 2: ID 4039.. the data from client different from server on Notecharter "Y..JZ".. so, that ID will put into listbox..
so, how can i compare all data in row for each column from server datagridview? If the data in row are same with server, it will be ignore..
How to compare data from two database... The fields of the database are very much the same.
Example location of the database..
Database1
C:Program FilesMySystemDatabase.mdb
TableName: Person1
Database2
C:MysystemDatabase.mdb
Tablename: Person2
i have threee list box namely listview 1 , listview 2 and listview 3 Listview1 uses opendialog to get the folder i wan and display the filesname inside the folder into listview 1Listview 2 draws data from a notepad(Default.txt) i have hard code the file name into it , and it displaydata from the notepad into listview2 what i wan to do is to compare listview 1 and listview 2 files name , if listview2 contains file listview 1 doesnt have than it shld show up those files name in listview
View 7 RepliesI have a whole bunch of information that has been parsed from a web page and i want to insert the data into a multi-demensional array and the compare the data of a certain array element to another array in the same format to determine which is missing/added.So if i have this:
Type of animal | Color | Age
Cat, Brown, 15
Dog, Pink, 6
Fish, Orange, 4
[code].....
I only want to compare the type of the animal and the color and age is irrelevant.I want it to let me know whats missing and what's been added.Sounds bizarre but yeah. It doesn't need to be arrays, it's the only thing i know of though.
I have been searching many ways to compare 2 images and still I havent got anything usefull.
I was wondering how can I compare 2 images and either return TRUE or FALSE
is there like a DLL and I send 2 images and either return TRUE or FALSE?
I am wondering if there is a easy way of comparing data in two datatables available in following format:
datatable1
Quote:
ID Length Width Height Qty Rate
ID1 1.50 3.50 1.15 10 55
ID2 2.50 3.50 1.25 20 65
ID3 3.50 3.50 1.35 30 75
[Code]....
ID column of both the tables are unique ID's and can be used for comparing both the databtables.
I am wondering based on these ID's, both the datatables can be compared.
For example, if datatable 1 is used as reference table, data in ID2 and ID5 of datatable2 are different when compared in datatable 1
For the past day or so, I have been trying to compare values in my SQL server against an actual calendar. I have had mixed luck with this and I have exhausted my limited knowledge. I am looking for a shove in the right direction.
Background:Right now, I have a program that writes a record to a database when the program completes successfully. This time stamp has both the date and time on the SQL box. I want to grab that information and compare it against the basic calendar. I have attached a picture that should help explain things. This is just my test app,
[Code]...
I have this
[Code]...
All that is happening above is two players are being compared by scores and a winner is then decided. The calculation works fine and places the winner in the correct spot (txtWinner1.Text) as long as the numbers are positive. So if txtU1D.Text has 13 and txtU2D.Text has 14...txtU2 is the winner. Works with no problems. However, if txtU1 has -1 and txtU2 has -2...it says txtU2 is the winner. The negative scores are common in the game being played so the situation often happens, but may be one player only. It seems to work if one is positive and one is negative, but if both are negative it thinks the higher negative number is the winner for some reason. So it will give the win to someone who has -9 over someone who is -4.
We publish official documentation into pdf's, tiffs, and cals depending on the document type. Recently, we have discovered that somewhere in our publishing process, the system can hiccup and cause a character or two to become missing. It's intermittent and not consistent. We have a fix for it, but unfortunately have hundreds of thousands already published in the repository. It was brought up that we may want to consider developing a batch comparison tool that would compare a newly published version to the original published version to identify the problem documents. There was multiple thoughts on how to do this:
1.) Compare file sizes... unfortunately, any variation will cause the sizes to vary and small variations may not accurately reflect in it.
2.) Binary comparison... not sure how this would work at a file level like this
3.) Hash MD5 Compare... not sure how this would work either.
So I thought I'd ask those out there with some similar experience, what is the best way using the .Net Framework to compare one tiff to another, one pdf to another, and one cal to another?
I have a program that backs-up remote locations to a centralized FTP server. Upon successful completion, a record is written to a SQL database with the following information:
GUID (uniqueidentifier)
StoreID (varchar(5))
DateStamp (sqldatetime)
ProgramAndVersion(varchar(50))
I am currently managing the program by running a report on who has written a record to the database. If the record is not written, I manually go in and backup the necessary files.The problem with this, is that it can take up to 30 minutes/day to do this task. While that's not a long time, it's getting somebody to be dedicated when I'm off and that has proven to be difficult.
I want the program to automatically search for missing records, but I'm not sure how to do this. I was thinking about bringing in the last 30 days with a SELECT statement and then comparing the information that I have in the SQL database versus a calendar control (or something). I need to make this process completely automated and not very intensive on the SQL server. I only have the following
2010
Sub FindMissingBackups(ByVal DaysToCheck As Integer, ByVal StoreNumber As String)
Dim TodaysDate As SqlDateTime = Now()
Dim PastDate As SqlDateTime = DateAdd(DateInterval.Day, -DaysToCheck, Now())
[code]....
I have this piece of code which goal is to compare ALL records from recordset rs1 to ALL records of recordset rs2. Im doing something wrong because, when the code finishes I find that some records that fulfill the matching condition are not being considered as matched.
[code]...
how to compare two list boxes and remove identical values or add them to a 3rd list box, but for some reason it's not working when I retrieve the data from a mySQL database using ADODB, here's my work cut down by a fair bit for it to be easy to understand.
For k As Integer = lstFriends.Items.Count - 1 To 0 Step -1
If lstDBFriends.Items.Contains(lstFriends.Items(k)) Then
lstFriends.Items.RemoveAt(k)
End If
Next
I've tried everything from changing the data type on the mySQL database to storing the retrieved data from the database to String declaration and it simply wont compare the two listboxes
I have a DataTable that's constantly being updated with new data from my database via a timer. That data is eventually reformatted and displayed in a DataGridView control.In an effort to prevent the DataGridView from completely refreshing from re-databinding (thus, clearing out selections, resetting scrollbars, defaulting sorting settings, and making the gridview flash as it reupdates), I'm simply removing old rows from the datagrid that no longer exist in the DataTable, and adding new rows to the datagrid that appear in the DataTable since the last update.
For the sake of simplicity, we'll call DataGridView the LEFT table, and DataTable the RIGHT table I'm looking for a way to go through both tables (LEFT and RIGHT), and remove old rows that are no longer in RIGHT and delete them from LEFT. And look for new items in RIGHT and add them to LEFT. Each table has a column called "RecID" containing a unique id for each entry that can be used for comparison. is there a way to do this all in one loop? What I'm looking for, in pseudo code:
<loop through everything>
if RecID does not exist in LEFT but exists in RIGHT
add new item to LEFT
if RecID does exist in LEFT but does not exist in RIGHT
[code]....
I have a query in Access 07 that identifies the following fields: ContractID, status, start date and end date. For each contract, I've been able to search a network share and upload its corresponding file; however I need to skip the import and write a record to a table for contracts with the same start and end date. I've included a placeholder (in bold below), but how do I make the date comparison work? Do I need to create a multi-dimensional array for that or can it be done with the code I have?
Private Sub cmdRefreshList_Click()
DoCmd.SetWarnings False
'Create an array based on the true-up contract IDs.
[code]....
how can i insert data from data base with selected Datagridview columns i have insert combobox to Datagridview and it can load data from DB now i need insert data to another columns in Datagridview when i change combobox items?
View 7 RepliesI am trying to read and save data into a access Database but using the rows and colunms valeu can
View 1 RepliesI am creating a project in VB.NET in which one of the reports require that the name of employees should be displayed as column names and whatever work they have done for a stated period should appear in rows below that particular column.Now as it is clear, the columns will have to be added at runtime. Am using an ODBC Data source to populate the grid. Also since a loop will have to be done to find out the work done by employees individually, so the number of rows under one column might be less or more than the rows in the next column.Is there a way to create an empty data table and then update its contents based on columns and not add data based on addition of new rows.
View 1 RepliesI want to get two rows out of 6 columns in datagrid from database out of 6 columns so kindly give me a query of this programme but give me linq to sql query
View 2 RepliesWhen using a listview with several columns.
How do I for example get data from the second line and column 3?
how to add information in to a listview with information from a dss. So far i have managed to get all the information from SQL and now im just in the process of populating the listview.
Im aware i could use a datasouce for this but i want to learn it this way
So heres my code
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim retrieve As New GlobalFunctions
[Code]...
It doesnt throw an error it finishes loading and then presents with me a listview with a vertical scroll bar but with an empty screen....i think i may have got things a bit muddled up
I need to add data to columns after the headers. But I don't know how.
View 6 RepliesI'm writing a report scheduler that is somewhat of a clone to the backupexec scheduler and the layout can be seen in post #10 here: [URL]..It works great and saves/edits/deletes records just fine, but now i need to compare those records one at a time in a windows service that i'm writing in order to trigger automated report creation and emailing - i already have the report and i already have the code for the emailing, i'm just looking for the most efficient way to loop through the table (that i've pulled in to a dataset) and compare its records with the current date and time - if true, the event fires.
[Code]...
1stSun, 2ndSun etc are bit fields, time is a datetime, and the remainder are varchar. My service checks the database every thirty seconds.The english version of what i'm trying to do is "Connect to the database, grab the entire table (it will always only have 5-6 entries max, so i felt 30 second sweeps was okay), and If today is the 1st Sunday of the month, and it is currently 11:00:00 a.m. (could be any day or time, this is just an example) - loop through the dataset to identify if any records match the time field or greater - if they do, fire the report
I am trying to insert data into a grid with 3 columns, in VB6 you could select a grid's column number, something like this :
grid1.column=3
grid1.row=2
grid1.text ="hello"
how do you select the column in VB2008 as i can't see any similar command ?
I am retrieving the data from AD and sending it to th CSV file. but the data is not coming in Column1,column2 and Column3. Can you guys help me with formatting.[code]When i export the data to Excel the 3 fields i am retrieving are merged. Can you guys help me on how to get the data into excel with individual columns?
View 4 Replies
