I little thing I missed,
// if this row is NOT entered yet
if (rows == null) {
r = table3.NewRow();
r("id1") = c1value;
r("id2") = c2value;
table3.Rows.Add(r); // ************ ADD THIS LINE
********************
}
else {
r = rows(0);
}
On Oct 13, 9:01 am, "Arsalan Tamiz" <[EMAIL PROTECTED]> wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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>
-~----------~----~----~----~------~----~------~--~---
