I have 2 tables
First table contains
ID and Name
1 X
2 Y
3 Z
Second table contains dates. That my employees exit time
Id and Hour
1 17:00
5 17:01
6 17:02
7 17:05
Now I want to compare 2 tables and find who is ID number 1 ? How can I do this?
I have a two different tables, Table 1 and table 2.
Table 1
-----------
Resource
Start Date
End date
[Code]....
Here I have to match the total hours of each table according to the resource,
then have to find the mismatched data and find difference with that values of mismatched data.
We are presently developing an application, let's call it APP1, which uses a SQL Database which have about 800 stored procedures, 600 tables, etc. APP1 was originally created in order to replace another application, APP0, from which we do not have source code but only SQL tables, Stored Procedures, views, etc. Previous programers of APP1 used some DB objects from this same database and added some other objects specific to APP1 because it becomes bigger than APP0. And we do not need APP0 anymore as APP1 does all what we want, and more.
So, now, we are thinking about a way to find out which objects are used by APP1 in order to remove objects which are ONLY used by APP0.What is the best approach to discover all objects used by APP1 without having to open every single class and form?
Once we will have a complete list of these objects, it will be easy to use a program we bought which detects all dependencies for all SQL Objects specified directly from SQL and remove objects which do not return from any dependencies. Any ideas of how I could get this list without having to go through all our program that have many, many, many classes and forms?
Note : I know, in a perfect world, all calls to PSs and tables should be in a DAL but in the case of the application we're presently working on ... this is not our case! Yippy! (sarcastic yippy) ;)
Note 2 : This application is not using any ORM. So all queries are directly using SqlCommand. So any call to any DB objects are in string format.
I would like to know how to compare two tables which are in a datagridview each one. I imported one from excel and the other one from sql, i want to add the info that is in each cell of excel's table in sql table..though i don't want to have duplicated data.I want to do something like this
'datagridview1=exceldv
'datagridview2= sqldv
for each item1 in exceldv
for each item2 in sqldv
[code]....
We have an access database that contains Version table. the same file is stored in 2 separate locations, how would i pull the information from both c:db1.mdb and \servernamedb1.mdb's table so i could compare the two?
View 14 RepliesI have one dataset with two tables and when some values from tables are changing I need somehow to change the values from table 2. Table one is conected to an SQL server. One table 1 receives a message from sql service broker it automatically reload all the information. I need in that moment to compare what I have new in table 1 and put it in table 2. I have made with <br />For i=1 to ..<br /> </p>
View 6 RepliesI have three Tables in the MS Access database as below:
Company_Data
Name|Age|Department|Salary
User_Data
[Code].....
and i have a compare button on the VB form. Is there any code that can compare the Company_Data with User_Data and copy all the records not found in User_Data to Changes_Data table. When updating it should update the "updated on" Column to the current Date.
Same needs to be done in the opposite way. Compare User_Data with Company_Data and note the diff. No Need to update Salary in this case.
I have three Tables in the MS Access database as below:
Company_Data
Name|Age|Department|Salary
User_Data
[code].....
i need to compare two different tables which are Enlistment and Schedulings Table . in schedulings Table , there was a columnnmae AvailableSlots wherein the AvailableSlots in every sections in every year is recorded.. in Enlistment table, i used to count the number of records that satisfy my query : "Select Count(*) as Total from Enlistment where YearLevels = '" & TextBox4.Text & "' AND Sections = '" & ComboBox1.Text & "'"Now, i need to know how many slots are taken that satisfies the query.. to know the number of students that can only be enrolled on that particular sections ..
here's my codes :
con = New OleDbConnection("Provider= Microsoft.ACE.oledb.12.0; Data Source=|DataDirectory|Enrollment System.accdb;Jet OLEDB:Database Password=jhedonghae;")
Dim ewaaa As String = "Select Count(*) as Total from Enlistment where YearLevels = '" & TextBox4.Text & "' AND Sections = '" & ComboBox1.Text & "'"
[code]....
I created a typed dataset and my database guys are constantly updating and adding columns to tables.. is there a way to do a comparison
View 1 Replieshow to compare 2 sql tables and show data that are in table 1 but not in table2?
Dim strSQLL As String = "Select t1.run from ML533 t1 left join portal t2 on t1.[run] = t2.[runNo] where t1.[run] <> t2.[runNo]"
Dim comm As New System.Data.SqlClient.SqlCommand(strSQLL, conn)
Dim ds1 As DataSet = New DataSet()
[code]....
i have tried google and other sites.. but still cannot find solution. maybe i post the wrong question. but i manage to do this code. but its only shows only 1 record missing, but its supposed to show 5 records that r missing.
My approach is to setup three different queries and save to three different variables and then save the data in the three variables into the new table. I have the new table setup in ms access.As you can see from my code, I had tried many different ways to generate my sql statement but none of them works. Now I am trying to figure out which part of the sql statement goes wrong by testing one by one. The two that is uncomment:
1)Dim SDFH As String = "SELECT SegmentCode FROM SegmentPlantTable WHERE DatePlanted < cdate('" & Date.Today & "')"
2)Dim SDFP As String = "SELECT SegmentCode FROM HarvestTable WHERE DateOfHarvest <
[code].....
In my ASP.Net (VB Code) that I had 3 variable to store 3 different date.how can I compare 3 variable to find the last day between 3 date? [code]
View 3 RepliesI am working on a lottery application for homework. I am trying to have the Compare function return a number. I want to know how many numbers matched. I don't think that I am moving the random numbers into my lottery array in the correct place.
Module LotteryModule
'Array to hold user numbers.
Public intUserNumbers(4) As Integer
[code].....
If not, maybe someone could write such an article and the view count would go through the roof?
View 1 RepliesI have 6 array lists and I would like to know which one is the longest without using a bunch of IF STATEMENTS."if arraylist.count > anotherlist.count Then...." <- Anyway to do this other than this?
Examples in VB.net or C#.Net (4.0) would be helpfull.
arraylist1.count
arraylist2.count
arraylist3.count
arraylist4.count
arraylist5.count
arraylist6.count
DIM longest As integer = the longest arraylist should be stored in this variable.
i want to compare the two data table columns and find duplicates for example
dataTable1
autoid ponbr polinenbr quantity
1 0001 10 5
2 0002 12 6
[code]....
in the above two dataTable i would like to compare the ponbr and polinenbr column and find the duplicates and get the autoid..
I pass it a valid dataset that has the department name and the Department id as a number..20, 40, 30..... I want to get the department number.. I pass it HR(which is in the ds.table) but I am getting an error on the rows.find() "Input string was not in a correct format" it is a string.. what else could i be doing wrong here...
Public Function GetDeptID(ByRef ds As DataSet, ByVal strDepartment As String) As Integer
'Dim dr As DataRow
' Check to see if date is already in the table
[code].....
i wont to creat application, in wich with file location find tables and use them in my app. as databases
View 1 RepliesI once posted a question on generating a policy number by table ID and user selctions from comboboxes. [URL]FYI . I am doing my project in vb, that why i posted it here. I managed to do that when i choose a region and product from two different comboboxes i generate a number but now my problem is that whenever i click on the comboboxes a policy number is generated before i save the record, so if my previous nummber was 72100002 whenever i click on the product combobox i generate a number e.g if i click on it five times by the time i save the number would be 72100007. I am using a stored procedure for this. Is there another way of doing this or i might end up with my first record as 72100001 and my second record 72100006.
[Code]...
I am working on a program to match overlapping images together to make one complete image. This isn't for panoramic purposes, it is from a video game generated overhead map, so there is no perspective issues to deal with and the overlapping images (gained from screenshots while a player moves) should be pixel perfect (still running tests to verify this, but lets assume they are pixel perfect at this time).
1) I need to compare each new (small) overhead map section to the larger map, find what edge it fits on, and copy it over.On other forums I have seen people suggest taking the bitmap apart in the form of an array of colors, or 3 arrays per image for r, g, and b. I am wondering why this is done instead of directly going to the bitmap object and using GetPixel. Is an Array lookup significantly faster? Speed would be an issue with my program, I would like to do this match as fast as possible, and the overall map could become large, even if I keep making new map sections to manually paste together later.So, faster to loop through a graphic with getpixel, or faster to go through 3 two-dimensional arrays with r, g, and b, or faster to go through 1 three-dimensional array with rgb all inside it?
2) The bitmap object that contains the overall map will keep getting larger. What is the best way to resize that bitmap dynamically?I am thinking of just making a new, larger bitmap when I get near an edge, then using getpixel and setpixel to copy over the old bitmap to the new one. Is there a faster way to make a new, larger bitmap object containing the old one with the graphics class? I admit to finding the graphics class somewhat confusing in how methods on it affect the image object that is defined as it's surface...or something. There might be a faster way with graphics and drawimage, but is that really faster than a getpixel/setpixel loop? Finally, if I do store the graphics data in arrays instead of actual bitmap objects, would redimming the array be the best way? If I need more room at the 'beginning' of the array I would have to make a new array and then copy the data over shifted. And this might involve 3 arrays if it is best to use one each for r, g, b.
I need to count the number of records that match on the GIDs from the 'Directories' table (GID) and the 'ClientSubscriptions' table (DirectoryGID), and also the 'FranchiseGID' from both; as follows:
Dim iSubscriptionCount
SQLCommand = "SELECT COUNT(*) AS Counter FROM Directories.GID, ClientSubscriptons.DirectoryGID FROM Directories, ClientSubscriptons WHERE Directories.GID = ClientSubscriptons.DirectoryGID;"
[CODE]...
I need to determine whether or not to show a menu option based on the above.
Full Code: Default.asp
<!--#include virtual="/System/Startup_Admin.asp"-->
<!--#include virtual="/Admin/FranchiseAdmin/DirectorySetup/i_Directory.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-
[CODE]....
i have an array consist of ({9,2,10,5,7}) and i have a total = "17".
the question is, how do i find which sum of array that match the total ??
do you people know the algorithm or in vb.net language ??
the number in array not always the same and so the total is. that is just an example.
search a dataset table and search a column within that table for a value than if the value is true in the column find out which row number it was on
View 7 RepliesSuppose I have a number[code]...
View 4 RepliesFor example, black is 0, how can I find out what number other colors are?
View 12 Replies,how to find the number of words presented for a page in the pdf file using itextsharp. To get total number of page--reader.NumberOfPages.Like wise i need how to get total number of words for a page.
View 6 RepliesIf I have four items in the listbox, e.g. a, b, c, d, how can I find the name by knowing from the top the item is number 3 (c)?
View 6 RepliesHow do I check to see if the first character of a string is a number in VB.NET? I know that the Java way of doing it is:
char c = string.charAt(0);
isDigit = (c >= '0' && c <= '9');
I have a Credit Card Number in an XML Message and I want to use a regex to find the Credit Card Number and encrypt it. All numbers are 16 characters long and they are not always in the same place in the xml, so basically I think I just need to find a string that is 16 characters and decrypt it, but I am not sure how.
[Code]...