Having same interface as you have created, use the DataGridView's
CellEndEdit Event. Whenever any value is given you will be notified. So the
logical can be,
private void DataGridView1_CellEndEdit(object sender,
System.Windows.Forms.DataGridViewCellEventArgs e)
{
object c1value = null;
object c2value = null;
// we know which column has been edited so this will be the row
// from Table1 and we know which row has been edited so this
// will be the row from table2
c1value = table1.Rows(e.ColumnIndex - 1)("id1");
c2value = table2.Rows(e.RowIndex)("id1");
DataRow[] rows = null;
DataRow r = default(DataRow);
// ok now we are checking whether the value has already been entered
// in our Table3 or NOT
rows = table3.Select("id1=" + c1value + " AND id2=" + c2value);
// if this row is NOT entered yet
if (rows == null) {
r = table3.NewRow();
r("id1") = c1value;
r("id2") = c2value;
}
else {
r = rows(0);
}
r("value") = DataGridView1(e.ColumnIndex, e.RowIndex).Value;
}
So just send the Table3 to the DataAdapter/TableAdapter which will update
the Physical Database
On Sun, Oct 12, 2008 at 5:57 AM, I~N~S~I <[EMAIL PROTECTED]> wrote:
>
> 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>
-~----------~----~----~----~------~----~------~--~---
