I am not particular with the database approach of Foreign Key a manner wherein a data related to another data. Table1 > Relations > Table2 How to make a foreign key and how to use that in coding ?
View 9 Replies
How to insert multiple data into mssql without using loop?i'm developing a clinic management system, while doctor may give few medicines to patient,therefore i hope inside my database,the data will look like [code]
View 2 RepliesI have a header table and a related details table with a one-to-many relationship from master to details.I understand that I will have problems saving details if the master data isn't already there, and I've been working around this. (VS 2008, SQL Express 2008, app is running on XP)
I've been getting around this by checking if there's any detail data on the save click event and warning the user that they need to save the master first before adding details.So the user then removes the detail, clicks save, and then adds the details and clicks save again. Although not good, that's been working OK, but now I need to make the details mandatory. So at the moment they can add a new record, save it and no details.What I would really like to do is to save everything at once. I saw a related post that said I needed to use a transaction, Is that the best approach? Or is there a way to save the master first then the related details all when the save button is pressed?
How do I fetch the loginID and display the student data on the textbox?E.g. I login with loginID of 18 but it only display the data of 12
Private Sub frmLibrary_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'LibraryDataSet.Student' table. You can move, or remove it, as needed.
Me.StudentTableAdapter.Fill(Me.LibraryDataSet.Student)
End Sub
I have master detail form with two datagrids. customer and order detail.I have relationship between customer and order detail on customerid.How do i delete record from order detail when i click delete button to delete record from customer datagrid.Here is the code so far.
Private Sub btndelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btndelete.Click
'Me.CustomerTableAdapter.Fill(Me.CustomerDataSet.Customer)
[code]......
i wanted to ask that how to make a downlad coding because that i have sucessfully make a upload coding but i want to download the file from my localhost, it is possible?
View 10 RepliesI am building a program that will calculate the minutes work times the hourly pay rate and will display weekly pay check amount. This what I got but it won't calculate????
rivate
Sub
btnWeeklyPay_Click(ByVal
[code].....
I have completed a VB.NET project and I want make a installer for this project by coding.so I don't know how coding !
View 3 RepliesI am using vs2002.Can we make any changes in coding, while break mode like vb6.0?My editor doesnot allow me to make any changes in coding in break mode.
View 13 Repliesim trying to build a form+attachment that needs to be send to email.Im using a VB background code (attachementemail.aspx.vb)and my front (b-16.aspx) I want the page to check that the user entered a email, name, phonenumber and attachment. what command do I put in the axp.vb and what on the .aspx tried just about anything.
View 2 RepliesCoding a button so when press it i will make something appear in the label in response what was in my textbox. [Code] I cant figure out how to code it so when i click the score button it will put correct in the label in response whether the right answer was put in the textbox. Example the right answer for the textbox is Food. so when clicked to score i should show correct in the label. I feel like I missed a big part in my code to figure this out.
View 4 RepliesFirst I say tx to Dream.In.Code, ex. CharlieMay, who have solved all my problem. Now this is not problem to me. only I dont know, how focus to next currentrow without go to down first! because of this , my coding must include SendKeys {UP} else it go to down
CODE:
How to make SendKeys or corectly my coding, for not show in display like this?
Attached image(s)
give me a suggestion to do the simple coding ofnon random data.....
View 1 RepliesI am still having trouble moving data between sql and ms access databases.
View 6 RepliesPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
connetionString = ("server=192.9.200.82;database=eKalyan;user id=invite;password=invite")
MessageBox.Show("connection established")
[code]....
I've just finished my first vb.net application and have a question about setting up data sets and data adapters.It seems like I do a lot of repetition in coding and I'm wondering if there's a better way to set them up.Below is the coding I use to set up a data adapter (daAddSpeaker) and a data set (dsAddSpeaker).The purpose of this coding is for the user to add a speaker name to an Access table thru a windows form.The coding works as intended but I'm wondering why I have to repeat "SELECT * FROM tlkpSpeaker" and refer to "tlkpSpeaker" so often.[code]
View 3 RepliesI have spent hours trying to fix this problem I have, basically I want to only display column 1 from my text file in my rich text box. Each column is seperated by a space (" ") When I run the following coding it shows all columns.
[code]...
tier coding in retrieving data from database and display it in label.
I got the code for data access layer but im not sure if it's right:
Public Function getFeedbackQ(ByVal Question1 As String, ByVal Question2 As String, ByVal Question3 As String) As System.Data.DataSet
[code].....
i have connected my SQL SERVER 2005 database to vb.net and program is capable to show the database in the data grid view. but what i want is when i change the data in the data grid view and click onto update button,changes i made should be saved in database so when i execute the application again i should be able to see the updated database in the data grid view.
View 1 RepliesI did this Imports System.Data Imports System.Data.OleDb Public Class Form1 Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]...
i want to know that how can we add two cells of a datagrid view.I have 5 cells, quantity,rate,discount,tax and Total amount.I want to show the total amount in "Total Amount" cell.
View 3 Repliesi have encountered this error Variable 'dsNewRow' is used before it has been assigned a value. A null reference exception could result at runtime when i click on the button to insert data into my ms access database.
[Code]...
Say we have a DataGridView on the main form. I can chose to establish its properties by code or by selecting them in the Properties panel. Is there a difference between these two techniques, a loading time penalty in any of the cases especially?
View 5 RepliesIs it possible to have a Foreign Key as the Primary Key?
<Key()>
Public Property AssignmentID() As Integer
<ForeignKey("AssignmentID")>
Public Overridable Property Assignment As Assignment
Public Overridable Property User As User
For the code above I get an error:One or more validation errors were detected during model generation:System.Data.Edm.EdmAssociationEnd: : Multiplicity is not valid in Role 'AssignmentLocks_Assignment_Source' in relationship 'AssignmentLocks_Assignment'. Because the Dependent Role refers to the key properties, the upper bound of the multiplicity of the Dependent Role must be �1�.
I'm trying to create a table which has one (or none) record per assignment.
The general problem is that I can't get the foreign key in one of my child tables to populate the primary key from the parent table. I have a parent table named "ISSUES" and a child table named "ISSDESC". The primary key for ISSUES is ISS_ID which is an autonumber. The foreign key is ISS_ID in the ISSDESC table which is just a number. I'm using MS Access and an OLEDBConnection as the method. I've created the relationship in MS Access and also created the datarelation in the VB.NET code.
[Code]...
I have a pretty standard MySQL-query in my winform application like this:SELECT * FROM tblTable WHERE tblTable.tableID = " & variable..One of the fields is a foreign key. And when I try to add a record to my datagridview I get the error:Cannot add or update a child row: a foreign key constraint fails..Can't MySQLCommandBuilder make INSERT-commands with tables containing foreign keys?
View 2 RepliesI have a parent table called users which stores all the user info with a prime key field called ID. Now in the child table which has a seperate foreign key associated with the ID field in the parent table.
What I would like to do is be able to populate the foreign key once once the user uploads data into the child table with the user ID it has.
So far I have created the associated foreign key with ID field in the user table and also programmly through data-relation related the table but now sure on how to get the value from the relation.
The foreign key in the child table is called 'U_ID' as shown in the snipet velow.
[code]...
I have 2 tables:
Locations
location_refnbr (pk)
location_name
office_refnbr (fk)
[code]....
I'm developing an app in VB.Net (Visual Studio Express 2008, on Windows Vista) that connects to an Access relational database. The database has 3 related tables (TextSections, LineItems, Cycles) that I'm loading into my dataset. I've set up two foreign key constraints and want all changes to cascade through the related records in the child tables. I cannot get the cascades to reflect through.
For example, when I delete the parent record, the children records remain (in the database - they are removed from the dataset). Also, when I modify the parent record (change the Description field for example), the change is not reflected in the dataset datatable that holds the children records - unless I go through and ReLoad all of the data from the database and re-Set the constraints. I have set the .AcceptChanges, .UpdateRule, and .DeleteRule to cascade, and have also set EnforceConstraints on the dataset. Why aren't the changes cascading through the children?
Below I've pasted (1) the Load Routines for my datatables TextSections (parent), LineItems (child), and Cycles (child of LineItems); (2) the method that creates the constraints in the dataset, and (3) The Save routine for TextSections.
Friend Sub LoadTSTable()
Dim key(1) As DataColumn
Dim newCol As New DataColumn
[code].....
I'm using a dataset class written by others who have defined the foreign key relationships between tables using the tools in the schema diagram. I'm binding the dataclass to a windows form. I'm running into an issue where I have an existing header record and I'm trying to insert data into a child table via a grid programmatically. The child table contains all keys for data. As the grid is bound to a binding source, I'm simply adding rows directly to the grid programmatically.
When I attempt to save the data, I get the error ForeignKeyConstraint FX_Activity_UserRoleActivity Requires Child Key Values (4) to exist in the parent table. The value (4) is one of the foreign key values and it does exist in the parent table. The error occurs when I tell the bindingsource associated to the child table on the form to EndEdit. Looking at the XSD file for the dataset, both foreign keys are set up for 'Both Foreign and Key Constraint' with Cascade set for both update rule and delete rule. Accept/Reject rule is set to none.
Running a SQL trace, I confirmed that SQL Server is not generating the error, so it is occurring on the client application somewhere. First what does the error actually mean? Second, does the configuration of the foreign key relationship in the dataset's XSD file have anything to do with it? If so how should the foreign keys be set up between the tables? If it isn't how would you go about troubleshooting this issue as stepping through the code ends with the .EndEdit call to the binding source.
