I understand the logic you gave to add the edited data to table3 is
clear, but the problem is how can i load existing data in table3 to my
grid view.
The method i can think of is looping through the rows in table3 and
put the data into the data grid view. (this method is very slow)
Yes i agree, the Data binding option is not very user friendly.
Especially when there is about 100 records in each table. users gonna
have a hard time finding the value he needs.
Is there a method i can use to bind the data in table3 to the Data
grid view?
Thanks.
On Oct 13, 1:53 pm, sallushan <[EMAIL PROTECTED]> wrote:
> There is another way to do the same thing (using Data Binding only).
> But then the interface will NOT be that much friendly. For example,
> you can bind the DataGridView control with Table3. Which will create 3
> columns then change the first 2 columns to ComboBox Column and bind
> them with Table1 and Table2 Respectively.
>
> The way you are doing is correct, since user will be seeing a Cross-
> Tab View. But this will make your work a little complex. Which I
> already have discussed in my previous post.
>
> You will NOT bind your DataGridView control to Table3. Instead you
> will use DataGridView's CellEndEdit event. You should also make your
> 1st Column of DataGridView control Read Only (since we don't want to
> change the Labels). The Logic is simple,
>
> 1) Whenever a Cell is edited, we know in which column and row the user
> is
> 2) So we will get the Row from Table1 (using Column Index) and
> 3) Will get the Row from Table2 (using Row Index).
> 4) Then we will check whether the value is already entered in Table3
> or NOT
> 5) If Yes then just change the "value" in Table3
> 6) Else add the row in Table3 with the given "value".
>
> On Oct 13, 1:14 pm, "I~N~S~I" <[EMAIL PROTECTED]> wrote:
>
> > Thanks for the input . will try this, but i have another question.
> > i have to show the ID values of table1 as column captions and ID
> > values of table2 as the 1st column of the data grid view.
> > I have already done this by bring data from the server of table1 and
> > table2 and the looping through the two table and adding columns and
> > rows to the grid view. like below
>
> > foreach (DataRow currow in table1.Rows)
> > {
>
> > datagridview1.Columns.Add(currow["ID"].ToString(),currow["ID"].ToString());
>
> > }
>
> > foreach (DataRow currow in table2.Rows)
> > {
> > datagridview1.Rows.Add(currow["ID"].ToString());
>
> > }
>
> > But how can i put the data in table3 in the to the data grid view to
> > show it in the correct place. i can't just bind the data grid view to
> > the table3, then i lose my column and row data.
>
> > Is the method i'm using to add the columns and rows correct? Is there
> > a better method to do this?
>
> > On Oct 13, 9:07 am, sallushan <[EMAIL PROTECTED]> wrote:
>
> > > 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 -- 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>
-~----------~----~----~----~------~----~------~--~---
