daSeaInvInfo.SelectCommand = New SqlCommand
daSeaInvInfo.SelectCommand.Connection = conSea
'daSeaInvInfo.TableMappings.Add("Table", "InvoiceHeader")
daSeaInvInfo.SelectCommand.CommandText = "select
number,companyname,issudate from invoiceheader "
daSeaInvInfo.Fill(dsSeaInvInfo, "invoiceheader")
daSeaInvInfo.SelectCommand.CommandText = "select
number,item,unitprice,noofunit frominvoicedetail"
daSeaInvInfo.Fill(dsSeaInvInfo, "invoicedetail")
.................

now, I only want to update "invoiceheader"
I process daSeaInvInfo.update(dsSeaInvInfo,"invoiceheader")
It gots error , it said it can't find the column "item" in the table
"invoiceheader" ???!!
i only want to update the "invoiceheader" only , but not the whole tables..
:
Please help !!!!

Hi,

Maybe this will help.

http://msdn.microsoft.com/library/de...andbuilder.asp

Ken
--------------------
"Agnes" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
daSeaInvInfo.SelectCommand = New SqlCommand
daSeaInvInfo.SelectCommand.Connection = conSea
'daSeaInvInfo.TableMappings.Add("Table", "InvoiceHeader")
daSeaInvInfo.SelectCommand.CommandText = "select
number,companyname,issudate from invoiceheader "
daSeaInvInfo.Fill(dsSeaInvInfo, "invoiceheader")
daSeaInvInfo.SelectCommand.CommandText = "select
number,item,unitprice,noofunit frominvoicedetail"
daSeaInvInfo.Fill(dsSeaInvInfo, "invoicedetail")
.................

now, I only want to update "invoiceheader"
I process daSeaInvInfo.update(dsSeaInvInfo,"invoiceheader")
It gots error , it said it can't find the column "item" in the table
"invoiceheader" ???!!
i only want to update the "invoiceheader" only , but not the whole tables..
:
Please help !!!!

Thanks MVP
"Ken Tucker [MVP]" <(E-Mail Removed)> ¦b¶l¥ó
news:(E-Mail Removed) ¤¤¼¶¼g...
> Hi,
>
> Maybe this will help.
>
>
http://msdn.microsoft.com/library/de...andbuilder.asp
>
> Ken
> --------------------
> "Agnes" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> daSeaInvInfo.SelectCommand = New SqlCommand
> daSeaInvInfo.SelectCommand.Connection = conSea
> 'daSeaInvInfo.TableMappings.Add("Table", "InvoiceHeader")
> daSeaInvInfo.SelectCommand.CommandText = "select
> number,companyname,issudate from invoiceheader "
> daSeaInvInfo.Fill(dsSeaInvInfo, "invoiceheader")
> daSeaInvInfo.SelectCommand.CommandText = "select
> number,item,unitprice,noofunit frominvoicedetail"
> daSeaInvInfo.Fill(dsSeaInvInfo, "invoicedetail")
> ................
>
> now, I only want to update "invoiceheader"
> I process daSeaInvInfo.update(dsSeaInvInfo,"invoiceheader")
> It gots error , it said it can't find the column "item" in the table
> "invoiceheader" ???!!
> i only want to update the "invoiceheader" only , but not the whole
tables..
> :
> Please help !!!!
>
>
>