How To Merge Two DataSets On Specified Rule
Apr 13, 2010
I'm trying to merge two datasets based on these rules:
1. With ds1 and ds2, If the Unique Key from ds1 is not found in ds2, copy it to ds2 and move to next row in the table, else, goto the next part
2. If the unique key in ds2 is found in ds1, check the DateLastEdited row.
a. If DateLastEdited in ds2 is greater then in ds1, copy the row from ds2 to ds1, else , do nothing
I'm just having trouble with the loops. Here's what I have:
Dim ds1 As DataSet = fillNetwork() 'this function fills ds1 with the dataset from a table found on a network
Dim ds2 As DataSet = fillLocal() 'this function fills ds1 with the dataset from a table found on local drive
Dim returnRows() As System.Data.DataRow = Nothing
For Each dtDs1 In ds1.Tables
[Code] .....
This bit of code is just trying to segregate the one that are in both tables from the ones that are just in one table.
View 6 Replies
ADVERTISEMENT
Mar 19, 2010
I have two datasets called ds and ds1 that I want to merge into a grid. I get data from the first dataset to display in the grid but the second dataset where I want to display a count I don't get any data from it. I am trying a ds.Merge(ds1). here is the code i have for the sub.
1. Public Sub LoadSessionDateGrid(ByVal iSchool As Integer, ByVal iProgram As Integer)
2. Try
[Code].....
View 3 Replies
Apr 6, 2011
I have a very simple Business Rules Engine that has only three methods. One gets all the rules for the current operation, one will retrieve a list of parameters for the rules, the last applies the rules. The rules are stored in the database as user defined functions using parameters. The client will call the BRE pass in the operation and a Lot Number and the BRE checks for any rules that apply to this operation for this Lot. The client gets a list of rules that apply (the names of the corresponding UDF's in the database) and at which step in the operation the rule applies. When the material gets to a step that has a rule, it calls BRE to get parameters for the UDF for that operation, fills in the parameters with data contained in the GUI and calls the BRE to apply the rule with this lot's specific data. Multiple lots can share the same rule that is why there are parameters for the UDF. This all works well. However, this is assuming we have a set number of rules for each lot at each operation. If the lot needs a new rule applied at this operation we have to add a new rule and corresponding UDF into the BRE database. This is not a problem, the client will now see two rules, however, it only knows how to apply the parameters for the first rule, and there is no code for applying the parameters for the second rule.
For example: Rule 1 states that only the same Lot number items can be put into a carton. So the UDF expects one parameter called LotID and one parameter called Carton ID. It runs the rule (UDF) with these parameters and checks to ensure the lots match. Now the Lot requires a second rule: Only 25 items can be packed in the carton. We create a new rule and corresponding UDF, but this rule has the CartonID and a quantity associated with it.
The GUI can handle Rule 1 because it knows how to apply the correct data from the GUI to the parameters for the Rule and execute the rule, so LotID from the GUI = LotID in the parameter name in the UDF and CartonID from the GUI = CartonID parameter name in the UDF. Now there is a new rule, the GUI sees this new rule, gets the parameters, but has no way to applying the quantity to the new parameter to execute the rule without having to change the GUI. We don't expect there to be many rule changes, however, when they do occur we don't want to have to recompile the GUI every time. Does anyone have any suggestions on how to create a class that could determine the how to apply set the correct parameters? We have thought about a table in a database that maps the parameter names in the UDF with parameter names in the GUI so when we add a new UDF we update the table with the corresponding data from the GUI. That could work but may get cumbersome and would require us to make sure that, that table is kept current. Another suggestion was to name the parameters in the UDF the same as the parameters in the GUI, but this too, would require us to maintain the names in two locations.
View 5 Replies
May 5, 2012
I'm trying to write a rule to compensate for laziness caused by program changes. Used to be, case numbers for family law cases where I work were written as follows: 12-DR-012345. Now, you can get away with 12DR12345, and the file management program accepts it.
View 1 Replies
Apr 27, 2012
The general purpose of my application simply reads a line of text for example:
1. I have a printer issue
2. I have a software issue
I have a rule set as follows:
'Define the class 'Printer' with 14 values as a string...
Dim Printer(13) As String
'The string 'Printer' gets assigned a value, this is repeated another 13 times...
Printer(0) = "Printing"
[code]....
The code simply uses a number of keywords to detect if the issue is a 'printer', 'software', 'telephone',. or 'password' problem.I want to apply this rule set to 10 issues within the same rich text box, with the results sent to a text file. The exporting to a text file I can do, however the main issue is, i cannot read the lines individually.
View 5 Replies
Apr 25, 2012
I'm using ASP.NET 4 / VB.NET / IIS to build a web application. Folks will access the web application via a URL like so: [URL] So, for example, here is the urls for Jane Doe, John Doe, and James Doe respectively: [URL] I need to somehow pass them off (no matter what name is entered) to a default.aspx page which then pulls in the name portion of the url and uses it to perform a lookup against the database which contains info. about this particular person and displays a personalized page based on that information.
[Code]...
View 1 Replies
Mar 5, 2011
Let's say I have a rtb with a few lines.
line1: (empty)
line2: (empty)
Line3: "blablablablabla"
Line4: ..... etc
How do I get/read the first, only the first line? ("blablablabla")
View 9 Replies
Mar 30, 2011
I have a simple business rules engine that I need to write. I have looked at both Biztalk and Windows Workflow, but they are to much for what we need to do. This is a process that material will come to an operation, the GUI will check for three rules, one for the operation, one for the steps in the operation, and one for the item coming into the operation. These are the only three checks that will be done. It is possible there will be more than one rule for each check. I have a simple database set up to contain all the operations, steps and products and there is a crosstab table that links all the rules to each item. Here is an example of some rules (these are actual rules from the process):
View 5 Replies
Dec 29, 2011
So I'm working on a software in VB.Net where I need to scrape information and process it according to rules. For example, simple string replace rules like making "Det" into "Detached" for a specific field, or a split/join rule, basic string operations. All my scraping rules are RegEx and I store them in a database in rows of rule sets for different situations.What is the best way behind creating/storing rules to manipulate text? I do not want to hardcode the rules into the software, but rather be able to add more as there will be a need for them. I want to store them in a database, but then how do I interpret them?
View 1 Replies
Dec 2, 2010
Is there a dataannotation validate rule for a collection based property? I have the following
<DisplayName("Category")>
<Range(1, Integer.MaxValue, ErrorMessage:="Please select a category")>
Property CategoryId As Integer
<DisplayName("Technical Services")>
Property TechnicalServices As List(Of Integer)
I'm looking for a validator that I can add to the TechnicalServices property to set a minimum for the collection size.
View 1 Replies
Oct 25, 2011
I want to programmatically change ACL for all the subdirectories into a containing one. Specially when ACL of a particolar user is found I want to duplicate that ACL, change the security identifier and add the rule.
Look at this code:
cDirectoryInfo = New DirectoryInfo(strPath)
cDirectorySecurity = cDirectoryInfo.GetAccessControl()
cAuthorizationRuleCollection = cDirectorySecurity.GetAccessRules(True, True,
[Code]....
View 5 Replies
Dec 8, 2010
I place these 2 questions in this forum simply 'cause those that know GDI+ best are probably .Net vs. VB6 classic users... So here it goes.I'm using GDI+ flat file to generate a textured brush with image attributes. Creating these are no problem, but I can't find documentation that says whether disposing of the brush will dispose the original image & attributes handles I've assigned to the brush or whether I need to destroy those also? I can't locate anything that says whether GDI+ copies the handles or uses the ones I provided. Destroying the handles well before the brush is destroyed does no damage. Thus my assumption is that the handles are copied. But you know what they say about assumptions.
2. Likewise I use a GDI+ function to return the image assigned to a textured brush. Again, I don't know if that returned image handle is to be disposed by me or not. The returned handle changes every time I call the function, so I'm assuming that I should be destroying it. Thanx to all that can shed any light whether from personal experience or pointing me to some black & white documentation.
View 1 Replies
Dec 15, 2011
I want to enforce validation rule in create table statement for a coloumn. im using vb.net as front end and access as back end.
View 2 Replies
Jul 29, 2009
I would like to automatically create an Outlook rule (move email containing something in subject to folder xyz) but dont know how to achieve this. Of course I can create the rule and export it to a .rwz file. This file can be imported manually, but how can I import it automatically?
Can I import a rule through my VSTO 2005 Outlook (2003) Addin? Or can I create the rule from within this addin?
View 2 Replies
May 21, 2011
I need help from the Regex wizards out there. I am trying to write a simple parser that can tokenize the options list of a Snort rule (Snort, the IDS/IPS software). Problem is, I can't seem to find a workable formula that breaks apart the individual rule options based on their terminating semi-colon. The formulas that I have cooked up grab all options between parenthesis into a single capture group.
I am using the excellent RegExr tool at the GSkinner site with some of the below sample rule options from Emerging Threats (I parsed off the rule header -- that's easy to tokenize):
[Code]...
I had to play with a few example regex's that work with quoted strings. Finally realized that I am staring at negative look-behinds that avoid quotes that are escaped. This seems to solve any other escaped character, too, because escaped characters only appear inside unescaped quotes.
View 1 Replies
Feb 9, 2011
I have the following directory structure in my asp.net webdirectory i want when any body access anypage inside my admin folder then it auto redirect to login page of admin folder until they login
View 1 Replies
Jul 30, 2009
I'm trying to work with an ODBC driver for Interbase in VS2008 (vb). I succesfully inserted the data tables I want to use in the project datasource. Then I want to add some rows in one of the tables of the datasource. I used myDataSet.addTABLENAMErow(field1, field2, ...).The compiler gives me no error, but when I open the database with InterbaseConsole, the line I've add is not there. Do I do something wrong? Must I open/save the database (how do I do so). I've tried meDataSet.AcceptChanges whitout result.I'm not used to work with Datasets and tables...
View 1 Replies
Jan 29, 2010
Anyway to view the content of a dataset or datatable in debug? I don't mean looking up a specific element of the dataset but to view the hole thing.
View 4 Replies
Mar 14, 2009
difference between the two statements given below
1. Dim ds as new DataSet
2.Dim ds as DataSet = New DataSet
View 2 Replies
Oct 8, 2010
I'm trying to combine two datasets, each with 1 datatable and each having the same schemas. Datatable 1 would have a list of records. Datatable two may, or may no, have some or all of the records from table 1 plus more records. I would like to remove all the records from table 2 that are present in table 1.
This is what I got so far:
For Each table1 As DataTable In ds.Tables
For Each row1 As DataRow In ds.Tables(0).Rows
ds.Tables(0).PrimaryKey = New DataColumn() {ds.Tables(0).Columns(0)} 'Where 0 is the index of the column that's your key
row2 = ds2.Tables(0).Rows.Find(row1("ID"))
'if its found, delete it
Next
Next
View 2 Replies
Aug 2, 2011
how to join two datasets together.
First Dataset
Dim sql As String
sql = "SELECT payment.Debtor, SUM(Value_invoice) AS before_this_month,debtor.nama FROM Payment INNER JOIN dbo.debtor ON Payment.Debtor = debtor.debtor" & _
[code]....
Now i just want to either inner join or left join PaymentBeforeThisMonth and PaymentThisMonth into another dataset?
View 4 Replies
Feb 10, 2011
I have a dataset that contains only employee ID's. I need to loop through that dataset and for each employee ID I need to loop through several other datasets and pull data. I need help with this looping syntax. Here is a sample of some code that I am receiving an error with:
Dim EMPID as Integer
Dim CommandEmpid As New OleDb.OleDbCommand
Dim EmpidDS As New DataSet
[code]....
View 4 Replies
Mar 2, 2011
I have a form that needs to load data for 20 different combo boxes - the data is always the same. To get the combo boxes to function properly i need to create a separate dataset for each combo box. Doing this when the form loads takes it about 7 seconds each time a search result is double clicked and the form pops up displaying the correct data. The form is bound to the main table. Is there a way to store these data sets in memory somewhere so the user can close the form but still have them loaded? I can put this code behind the login form and it works until the form is closed, then the combo's no longer load.[code]
View 8 Replies
Jan 8, 2010
i want to check if datasets have changes and after that use msgbox (vbYesNoCancel) when program closes ,when i wrote this code it had error "Operator 'Or' is not defined for types 'System.Data.dataset' and Boolean"..[code]
View 2 Replies
May 17, 2009
I want to use my main dataset (dbds) on a second form. It's simple, on my main form, the user clicks a button, opens a new form, they enter an item number and I want to find that row, and change a value in another column of that same row, and have that be in effect onthe main dataset to send back to the database.[code]...
View 1 Replies
Dec 3, 2011
I have declared a dataset (let's call it 'Fred') as public in a VARs module. In the main form in a sub routine called at the start of the project I connect to an Excel spreadsheet and read it into the 'Fred' dataset into one table (called 'Table') I then bind the dataset table to a datagridview and I can see the spreadsheet. Which is very nice :-)
Having loaded the dataset I want to be able to get some values so I created a button and used the following
msg = Fred.Tables("Table").Rows(0).Item("Name")
I think this should get the value in the first row and in the column called 'Name' in the table called 'Table'
But I get an error when I click the button 'Object reference not set to an instance of an object' which I think means I need to use the 'New' keyword...
So I added to the button
Dim Fred = New DataSet
But I get the same error.
Now I have to admit that I've never really got my head around how to use the 'New' keyword and would have hoped to be able to get data from a dataset through my entire project - especially as I've declared it as 'Public'. Surely if I use 'New' all over the place then I create new datasets
View 3 Replies
Dec 1, 2009
What is the best way for me to have several datasets ?i've thought about creating a routine for creating datasets with a number in their names, each one with the desired data, but that's not very intelligent (although might work)i'd like to create what would be like an "ARRAY OF DATASETS"
[Code]...
(obs, i've done the same code loading one XML to one dataset and it works perfectly, i've gone back and forth more than one time to assure that it isn't just a logical mistake, it's syntax and lack of programming knowlegde.
View 3 Replies
Sep 4, 2009
I need to very quickly write an exe system on a laptop where when the laptops are connected to the network they read a database table and store the data locally, so staff can use the laptop while they roam.The laptops have quite small capacity and the company would prefer not to use SQL Express or Access.
My question is, can the data initially be downloaded into the exe application via a dataadapter and dataset, and will that dataset the retain the downloaded data, or will I need to ensure the dataset is written to an XML file and then loaded/unloaded each time the laptop application is started while the staff are travelling ?
View 2 Replies
Sep 16, 2010
What I'm looking for are videos in vb.net for console application that will show me how to use DataSets and TableAdapters step by step. Please provide links
View 4 Replies
Oct 14, 2011
I'm using the MYSQL .NET connector with an adapter to fill a dataset from a SELECT statement. Between different SELECT statements I use the DataSet.Clear() function. The Getxml shows me that the dataset is empty, however when cycling through the Table's columns, I have all the columns from all the tables used in prior SELECT statements.
How do I go about that without Dimming new Datasets for each table?
View 1 Replies
