Master and Detail Problem in VB.NET

Question

0.00/5 (No votes)

See more:

Hi all visitors
i have 2 tables. Table SaleHeader is a master table and Table SaleDetail is a detail table.In master table, there is a primary key(SaleCode) and it is a foreign key in detail table.In detail table, there is a primary key(SaleDetailCode). So in detail table, there are one foreign key(SaleCode) and primary key(SaleDetailCode).
when i save, i want to save all data in master table to Table(SaleHeader) and all detail data(use DataGridView to show all data) to SaleDetail table.
in my source code is:

MSIL

Me.SaleHeaderBS.EndEdit()
Me.SaleHeaderTA.Update(Me.VinaSaleDS.SalesHeader)
Me.SaleDetailBS.Current("Salecode") = Me.txtDocnum.Text.Trim
Me.SaleDetailBS.EndEdit()
Me.SaleDetailTA.Update(Me.VinaSaleDS.SalesDetail)

but it error and show me the message that "SaleDetailCode couldn't null".
Note:
for SaleCode in Master Table, i use text box to input Sale Code.
for SaleDetailCode i hide in DataGrid, but i want it automatically increase coz SaleDetailCode autonumber in table.

Please help me about how i can save data from master and detail to tables.

Best Regards,
TONY

Posted 18-May-11 22:41pm

soeun tony

Add a Solution

Comments

Karwa_Vivek 19-May-11 5:29am

hi TONY
is your problem solved
by the solution what is provided by Mr S Mewara.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2011-05-18T22:47:00

for SaleDetailCode i hide in DataGrid, but i want it automatically increase coz SaleDetailCode autonumber in table.
This has to do with table design and not via code.

Make it an Identity column[^] with a defined increment step.

It would be something like:
1. Go to 'Design Table'
2. Select the column of 'SaleDetailCode'
3. See at the properties of the column below.
4. There is an option of making it if 'Identity' column - mark it yes
5. You can also define the increment to any number. By default it is 1.

Karwa_Vivek · Answer 2 · 2011-05-18T23:50:00

With Addition To
the process what is Told by S Mewara
that means
after marking the SaleDetailCode as An Identity Increament To One
You can use The max Function
to Increase the SaleDetailCode as Follows
and Call this function after you Click Your Save button
or Whenever you load the Form..

Public Sub Max_Id()
        Dim sd As New SqlDataAdapter("Select max(SaleDetailCode) from SaleDetail", myCon.con())
        Dim dt As New DataTable
        sd.Fill(dt)
        If (dt.Rows(0)(0).ToString() <> Nothing) Then
            txtEid.Text = Convert.ToInt32(dt.Rows(0)(0).ToString()) + 1
        Else
            txtEid.Text = "1"

        End If
    End Sub

Also I will Suggest You to use a Textbox in
Place Of datagrid to Input the SaleDetailCode
and then hide The Textbox
here I have Provided the same Taking a TextBox named txtEid and myCon is the connection Class What i am using.
use the Connection what you have Taken

Master and Detail Problem in VB.NET

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0