I have two tables populated in a dataset using sql data adapter.. i created relation by specifying two columns in each table.. added it in dataset and made datagridview to show related records.. but it shows only first record...
---code
Dim cons As New String("Data Source=xxxxSQLEXPRESS;Initial Catalog=emp;Integrated Security=True")
Dim sql1 As New String("Select * from tab1")
Dim sql2 As New String("Select * from tab2")
I have a data set with a parent child relationship between a patient table and an insurance table. There can be up to 4 insurances for each patient. I want to display them in 4 separate panels of a vb.net form. So if a patient had 2 insurances, then txtName1.text on panel 1 would have the company name of the first insurance, txtName2.text on panel 2 would hold the company name of the second insurance, and so on.
How do I display only the insurances related to the current patient? I've tried moving through the rows of the related table, but that gives me all the rows, not the ones I need. Everything I see on the internet suggest using a datagrid, but that's not an option in this case.
I want to make relationship between them Where In the F column of Table2 will sum the numbers in F column of table 3 according this condition ( show in the pic.)For the same data in columns(B,C,D) between two tables Example: Table 2 include in B,C,D data HH XX FF There are many data (HH XX FF) in tables3 in same columns(b,c,d) so it will sum the numbers in F column that in the same row with the data (HH xx FF), and insertded the results in the in table2 in F colmn in the same row with (HH XX FF)
If I use the following code to draw a rectange, do the values inserted into 'fromleft' & 'fromtop' set a co-ordinate from the top/left corner of the paper or from the top/left corner of the margins.
Dim R As Rectangle Dim across As Integer = 5 Dim down As Integer = 13
[Code]....
The reason I am asking this question is because I am trying to print labels so the position of the labels on the sheet are fixed. When the printer is set to papersize = letter the first label is in the correct position but when I change it to A4 the first label has moved 4mm to the right. With the margins set to 0 I still cant get it justified correctly. The printer is obviosly capable of printing 4mm from the left because it does so when set to 'letter'. Can't use letter because I need the extra length of A4 for the bottom row of labels.
I have the following code that creates a master/detail scenario between a products table and a test table based on the productid: [code]Unhandled exception has occured. the constraint cannot be enabled as not all values have corresponding parent values as you will see, where I add the datarelation between the two datatables i've added a false. This ensures constraints are not created.That solved the problem. However, I want to know if this is the correct solution. It is really difficult to troubleshoot as I cannot reproduce the error. The database is accessed through the network. it could be the network was down at the time so the child records where not inserted hence the error.
I want to program a water supply pipeline network in a treeview control. It has five node (junctions). The parent-child relation is based on a parameter (say pressure). Initially, the node 1 is parent and its child nodes are 2 and 3. The node 3 has child nodes 4 and 5. At run time the pressure changes. Now, node 3 is parent and its child nodes are 1, 4 and 5. The node 1 has child node 2.
I have recently built an N-Tier app using VB.Net 2008. The application is based on Beth Massi's tutorial at [URL] I am trying to incorporate a datagrridview control on a Parent form - one parent (father and mother) to many children. For example,
I have two dataset , each with with table . each datasets is connected to a separate dataadapter to get data from sql server database file (two different tables SQLtableOrders & SQLtableCustomerA))
datasetOrders.Tables("Orders") >>> the first column "orderID" is a primary unique key. Its structure is details below : OrderID----OrderName----OrderCost--------Date 1----------A---------------54------------11/11/2010
[Code].....
note that I had already made this by getting the data by SQL Statement "Select SQLtableOrders.* , SQLtableCustomerA.orderID FROM SQLtableOrders, SQLtableCustomerA WHERE SQLtableOrders.orderID = SQLtableCustomerA.orderID" It is really working fine , but the problem that it takes time to get data from the SQL server each time I disply orders. I already have the datasetOrders.Tables("Orders") data on the client PC , I need only to make the client PC extract which orders are assinged to a ceratin customers. I can do it by For... Next , but I guess it will take time , specially if "orders" data contains many data .
<HttpPost()> Function Edit(<Bind(Prefix:="Article")> ByVal Article As FormCollection, Optional ByVal DepartementID As Integer = 0, Optional ByVal LeverancierID As Integer = 0) As ActionResult ', ByVal ReferenceSupplierID As Integer ' Dim Art As Article = ArticleService.GetArticleById(Article.ArticleID) Dim _toUpdateArt As Article = ArticleService.GetArticleById(Article(0)) UpdateModel(_toUpdateArt, Article)
[Code]...
toUpdateArt.Departement = Nothing and _toUpdateArt.Supplier = Nothing is to remove the optional relationship.But it only works when i debug it and sometimes after several loops of the command, before the relation is actually removed and it's stored in the database.When there isn't a breakpoint on the "function", the Relationship will never be nulled.Does anyone has an explanation for this and how to fix this?
I am a newbie. I have been able to Add new entities where there is a One-To-Many Relation. I am having a problem (don't Know how to do it) adding a new Entity when the relation is using Many-To-Many. In my EDM I have:
I am designing a system for our sales team to enter their sales expenses. I have designed an input form and need some advise on what exactly I should store in the expenses table VS lookup from the employee table.
First, the form has a text box where the user must enter their EmployeeID. Management asked for a text box VS a combo box because they do not want users looking at each others expenses. The form has a search feature where by after you enter your employee number, it will look for an existing expense ticket first before allowing you to create a new one. Anyway, here are some of the decisions I have to make.
When the user enters their employee number, I would like to display their employee name. The EmployeeID is saved in the Expense table but should I also store the name in the expsense table? If I do save it, it's duplication of data, if I do not, I have to look it up each time the record is loaded. But is there a point storing the name long term? Does this qualify as related data? If I was to perform some reporting, could this cause a problem if an employee changes their name etc.
The expense data is spread over 2 tables, the first for the header details including employeeID, expense date and Expense ID etc. The second table contains the expense lines information. Amount, customer, category etc. My next question is when the employee chooses an expense category, there is an associated general Ledger code with that category. Again, the expense category data is stored in a table. When the user chooses the expense category, should I store the categoryID or store the values associated with the ID (GLAcct, CategoryDescription etc.) Does this qualify as related data or should lookup values always be duplicated in the master table? It is possible that over time, the GL accounts associated with the Expense categories could change. So for accuracy purposes, should they be stored in the expense lines table?
I want to have a combo box with a list of names. When one of the names is selected, I want the phone number and email to be displayed below it in a text box (or something similar).
i have two tables ( employees and departments )i want to insert data in employees table via employees form .so how can i put the departments names in a combobox and when the user choose a specific one it will return a department number so i can pass it to the INSERT statement? i mean what is the exact SELECT statement to load the the information to the datatable do i need two SELECT statements or innerjoin or something else?
i am trying to get the angle of a line in relation to the x axis. The line is being drawn in a picturebox. So its the Upper right quadrant of the cartesian plane ... but its flipped over the x axis.im using this code
a=pt(1).x b=pt(1).y c=pt(2).x d=pt(2).y
z=math.atan2((c-a),(d-b))*(180/math.pi)
The issue is that the line im drawing is almost parallel to the x axis but its returning a value of roughly 90 degrees .It seems like it is giving me the angle in relation to the y axis, but not being super good at the math myself im not exactly sure what to change here.
i have a login form that contains a combo box and a text box and a button. the items of the como box are from the databse while the person selected can only log into the system if the password he enters on the textbox matches the password details in the database.(of the name selected)
my problem is, the second tab contains a couple of textboxes and combo boxes that need to be filled in. but i want the first combo box in the second tab to have drop down value of the name of the person that has logged in to fill in the form.
the person login in the first tab, his name should appera on the combo box in the second tab
I've made a ContextMenuStrip to use in my program to change the image in a picture box. However, it's used with multiple picture boxes which each need to have their own changed. What I want to do is make my command change only that picture box leaving the others as they were before. An example, if this were a plausible code.
Private Sub TestToolStripMenuItem_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles TestToolStripMenuItem.Click Self(aka the control that currently has the menu open).Image = My.Resources.Picture End Sub
I have this code working fine , it takes pictures of the correct size and correct file name , however , all the pictures it takes are in the top left corner of the screen , rather than where i have the form to. FYI the picture box in the middle has no picture in it , and is transparent , i want to save a bitmap of the contents of the picturebox ( a user defined size of the screen). The picture box and button are docked so that the form scales properly when being resized.
If I do the mousedown event in my picturebox, is there a way to calculate the mouse position in relation to the picturebox itself, or will I have to calculate it from the X/Y of the mouse and the X/Y of the picturebox? I can do the latter, just wondering if there's a command for the former.
i am new to vb2005 and i am developing a project of a restaurant in vb2005. i have two combo boxes of PRICE and SOFTDRINKS. there are 5 different soft drinks and there are five different prices of the softdrinks in the combo box of PRICE. my requirement is that when i select the soft drink in the combo box of SOFTDRINKS then automatically the price relevant to that soft drink should be selected in the combo box of PRICE.
How do I add relations for two colums between two tables? I tried below way but it does not work. Is there any other way?
Dim relCompanyEmp1 As DataRelation = ds.Relations.Add("relSectionEmp", ds.Tables("MST_COMPANY").Columns("COMPANY_ID"), ds.Tables("EMP_MASTER").Columns("COMPANY_ID")) Dim relCompanyEmp2 As DataRelation = ds.Relations.Add("relSectionEmp", ds.Tables("MST_COMPANY").Columns("LOCATION_ID"), ds.Tables("EMP_MASTER").Columns("LOCATION_ID"))
Not sure if I am using the correct term, but it's not child/parent since they aren't nested objects. In my application I've got a User, UserUserGroup, and UserGroup objects which are pretty standard, UserUserGroup is a linking object with corresponding IDs. I am using Linq-to-SQL so unforunately it doesn't used nested objects, but it still knows the relation.
I have created a strongly typed dataset in the VS 2005 Dataset Designer. There are two tables that relates to each other in a one to many relationship: Claim and ClaimDetail. The designer automatically creates a function GetClaimDetailRows which returns all ClaimDetailRows for a ClaimRow. Why is this Array's length always 0? Because ClaimDetail contains more than 40 Million rows, i did'nt fill it before i call GetClaimDetailRows but had configured it's selectcommand that it takes a parameter idData to fill only the related records. But that seems not to work because the ClaimDetail-Datatable is empty.
The automatically generated function in the ClaimRow-Class which returns all related ClaimDetailRows: Public Function GetClaimDetailRows() As ClaimDetailRow() If (Me.Table.ChildRelations("Claim_ClaimDetail") Is Nothing) Then Return New ClaimDetailRow(-1) {} Else Return CType(MyBase.GetChildRows(Me.Table.ChildRelations("Claim_ClaimDetail")),ClaimDetailRow()) End If End Function
When debugging I see that it jumps into the else block but returns 0 rows. Do I have to fill the Claimdetail-Datatable first(ClearBeforeFill=True) for each Claim? But then I don't need to use this function anymore. I now fill the Datatable(ClearBeforeFill=True)before i call the Child-function and it works. But I don't understand why it could not throw an exception(optionally) when I try to acess a child-relation without having that datatable being filled(at least with 0 rows). Instead of that it returns 0 rows what can be correct or incorrect and is difficult to detect.
the form backcolor is 14221235 , but when i set the customcolor in colordialog to equal the form backcolor, it sets it to 5046311 !!! what is the problem?the reason i am turning it into a string is because i will feed it into a string which has "32498239, 234234234, 23423234, 32234432432, 423324234"then i take this string and put it in customcolors like this. btw this piece of code works fine:
Dim numberStrings = My.Settings.mytext1.Split(","c).Select(Function(x) x.Trim()) ColorDialog1.CustomColors = numberStrings.Select(Function(x) CInt(x)).ToArray()
I am going to ask a dumb question. I want to update my tables (two). There is a one to many relation between them. I know how to update when only one table is update, but how do i update when there is many on the other side. My problem is that , if one of the records on the many should become redundant, how would i delete it in the update process. If only the content changes , it is not a problem, i know the data just gets written back to the tables, but if one of the child records is not delete, how would it work I need some clue on the SQL statement using OLEDB
With a 1-many relation. Ok, I have constructed the schema, and now I want to make the appropriate forms in which a user would scroll for a customer and then by pressing a button, a new form would appear showing all the orders that he has made.
I am interested in the way of building two forms that would have a one to many relation. That is basically what I would like to know. Also, Do you have any good book to suggest in order to create a real world app, in VB2008, Emphasizing in data-binding and connecting controls with underlying DB, one to many forms, searching etc.
there is a database, containing a table with personnel. in the personnel table there are names and ID'sthere is a second table departemens, containing the names of departements and their ID's.in the third table it says which departement ID and which personnel ID are to be linked,
example the employee called ruben has an ID 5 the employee called kevin has an ID 10
I am developing a small windows application(vb.net).In that i want to have parent child relations in a gridview control. There are lots of examples available on this, but they are using two gridviews for that, but in my case i want the relation to be displayed in a single gridview control itself. When they click the + sign immediate row should populate child rows with it's own header(ie child rows has it's own header which is different from parent header). In my case parent row has 2 columns and child row has 4 columns.
in VS 2008, is there a way to design a ContextMenuStrip in a designer without a relation to a specific Form or UserControl class? For example,if you need the same ContextMenuStrip in Form1, Form2 and Form3, in which of them am I to design the ContextMenuStrip? Do I have to add a "pseudo-Form" to the project that contains my shared ContextMenuStrips and create only one instance of that Form, or is there another way? I consider this a programmatic hack, that's why my question is whether the IDE offers something better.
