Hi all,
I have this problem, i need to know is there a way i cn use the data
adapter's update method in this scenario.
i have 3 tables as below
create table table1{
id1 int identity(1,1)
Constraint pk_table1 Primary Key,
title varchar(20) not null,
}
create table table2{
id2 int identity(1,1)
Constraint pk_table1 Primary Key,
title varchar(20) not null,
}
create table table3{
id1 int not null
Constraint fk_table3_1 Foreign Key References
table1(id1),
id2 int not null
Constraint fk_table3_2 Foreign Key References
table2(id2),
value int default 0,
Constraint pk_table3 Primary Key (id1,id2),
}
In my application i have a Datagrid view, which has all the records
of
table1 as the columns of the datagrid view and records of table2 as
the rows of the data grid. and i have table 3 to store the values i
enter in Datagrid view.
I was wondering can i use the data adapter to fetch data of table3
using Fill method and use da update method of data adapter to add
values to table3.
I have no leads on how to start, thats why my 1st have the concern
whether i can do it using the Data adapter.
The only method i cn think of is loop through each cell im my
datagrid
view and manually run the insert or update SQL commands. But that
will
make my application very slow. specially when there is abt 40 records
in table1 and 100 records in table2... :-(
Can anyone giv me any leads.....
P.S: Im using C# and SQL server 2000 / 2005
Thank you,
Insira.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/DotNetDevelopment
You may subscribe to group Feeds using a RSS Feed Reader to stay upto date
using following url
<a href="http://feeds.feedburner.com/DotNetDevelopment";>
http://feeds.feedburner.com/DotNetDevelopment</a>
-~----------~----~----~----~------~----~------~--~---
