How do I pass datagridview multiple rows to a second form datagridview without getter accessor

Question

1.00/5 (1 vote)

See more:

I want to send datagridview multiple cell values from one form to another form with datagridview when both forms are open. The get set works for only one string/ value.
In other words I want to go through the datagridview in form 1 and pick a cell value based on the conditions and pass it to another open form 2.

What I have tried:

I've tried to use the set accesor only but get an error data cannot be used in this context because it lacks the get accessor.

Public string Data
{
Set
{
foreach (DatagridviewRow row in datagridview2.Rows)
row.cells["scale"].Value = value;
}
}

Posted 27-Jan-19 20:21pm

Robert S4r

Updated 27-Jan-19 20:51pm

Add a Solution

2 solutions

Solution 2

See example here: Passing data between two Forms in WinForms[^]

You might also be interested in data binding, which is the recommend way, see the part about filtering for a second form in this excellent article: A Detailed Data Binding Tutorial[^]

Posted 27-Jan-19 20:52pm

RickZeeland

Updated 27-Jan-19 21:15pm

v2

Comments

Robert S4r 28-Jan-19 3:18am

For this case, its as if form 2 has no datagridview.

RickZeeland 28-Jan-19 3:39am

Are you referring to the data binding example ?
See Griffs solution on how to create a suitable property.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2019-01-27T20:50:00

Solution 1

Getter and setter methods don't "work for only one string/value" - they work for one instance of the class type for which the property is declared.
So a string property gets and sets a single string:

C#

public string MyStringProperty
   {
   get { return myString; }
   set { myString = value; }
   }

and an integer property works with a single integer:

C#

public int MyIntegerProperty
   {
   get { return myInt; }
   set { myInt = value; }
   }

But the type can be anything! A custom class:

C#

public MyClass MyClassProperty
   {
   get { return myClass; }
   set { myClass = value; }
   }

A DataTable:

C#

public DataTable MyDataTableProperty
   {
   get { return myDataGridView.DataSource; }
   set { myDataGridView.DataSource = value; }
   }

A List of strings:

C#

public List<string> MyStringListProperty
   {
   get { return myStringList; }
   set { myStringList = value; }
   }

If you want to pass multiple values, just package them in an appropriate collection, and create a property that gets and sets that collection...

Posted 27-Jan-19 20:50pm

OriginalGriff

Updated 27-Jan-19 20:51pm

v2

Comments

Robert S4r 28-Jan-19 4:17am

I'm finding hard time packaging and setting the collection. DataTable seems to be the best option, but it throws an error
Cannot implicitly convert type object to system. Data.DataTable. an explicit conversion exists....

{
get {return datagridview1. DataSource;}
set {datagridview1.DataSource = value;}
}

Any help please!

OriginalGriff 28-Jan-19 4:27am

What did you declare the property type as?

Robert S4r 28-Jan-19 4:41am

public DataTable dataTableF

OriginalGriff 28-Jan-19 4:49am

Ah. Try this:
get {return datagridview1. DataSource as DataTable;}

Robert S4r 28-Jan-19 5:10am

This is an extract of what I've tried.(No results yet)

SOURCE DATAGRIDVIEW - FORM 2
--------------------------------------------------
public partial class Form2 : Form{
MySqlDataAdapter daStoreC = new MySqlDataAdapter(); DataSet dsStoreC = new DataSet();
public Form2()
{InitializeComponent();}

private void Form2_Load(object sender, EventArgs e)
{LOAD_STORE_CONSUMPTION();}
public DataTable MyDataTableProperty
{get { return dataGridView2.DataSource as DataTable; }set
{ dataGridView2.DataSource = value; }}

public event EventHandler DataAvailable;
protected virtual void OnDataAvailable(EventArgs e)
{EventHandler eh = DataAvailable;
if (eh != null)
{ eh(this, e); }}

private void button1_Click(object sender, EventArgs e)
{OnDataAvailable(null);}

private void LOAD_STORE_CONSUMPTION()
{Connectionss.S_DB();
string sqlStoreC = "SELECT * FROM store_stock";
try{
MySqlConnection ConnStoreC = new MySqlConnection(Connectionss.cnString);
ConnStoreC.Open();
MySqlDataAdapter daStoreC = new MySqlDataAdapter(sqlStoreC, ConnStoreC);
daStoreC.Fill(dsStoreC, "store_stock");
dataGridView2.DataSource = dsStoreC;
dataGridView2.DataMember = "store_stock";
ConnStoreC.Close();
ConnStoreC.Dispose();
}catch (Exception ex){MessageBox.Show(ex.Message);}
}}
//===========================
DESTINATION DGV - FORM 1

public partial class Form1 : Form{

public Form1() {InitializeComponent();}

private void Form1_Load(object sender, EventArgs e)
{LOAD_STORE_CONSUMPTION();}
void Form2_DataAvailable(object sender, EventArgs e)
{
Form2 form2 = sender as Form2;
if (form2 != null){
for (int i = 0; i <= dataGridView1.Rows.Count - 1; i++)
{dataGridView1.Rows[i].Cells[2].Value = form2.MyDataTableProperty;
}}
}

private void LOAD_STORE_CONSUMPTION()
{........................}

private void button1_Click(object sender, EventArgs e){
Form2 form = new Form2();
form.DataAvailable += new
EventHandler(Form2_DataAvailable);
form.Show();
}}

(BOTH FORMS ARE OPEN)

OriginalGriff 28-Jan-19 5:16am

Read your code. What do you think that does?
Specifically, what do you think this does:

for (int i = 0; i <= dataGridView1.Rows.Count - 1; i++)
{dataGridView1.Rows[i].Cells[2].Value = form2.MyDataTableProperty;
}

Robert S4r 28-Jan-19 5:48am

It was working fine for
currentRow.Cells[2].value.ToString();

Actually what I'm trying to achieve is:-
Look for any cell [2] value in form2 datagridview 2, compare it with any cell [2] value in form1 datagridview 1. If they correspond, then update cell[3] in datagridview 1. (When both forms are open)

OriginalGriff 28-Jan-19 6:05am

Then write a method pair in Form2;
GetXY(int x, int y) which returns the value at column x, row y
SetXY(int x, int y) which sets the value at column x, row y
Call that in your loop and compare ...
You don't necessarily want the whole lot, if you do, get the DataTable outside the loop and compare it's X, Y values.

Robert S4r 28-Jan-19 6:37am

Any example about it?

OriginalGriff 28-Jan-19 6:52am

You are kidding, right? You already use the code...

Robert S4r 28-Jan-19 9:42am

Is there any reason of kidding? I'm here to seek for assistance.

OriginalGriff 28-Jan-19 9:53am

Because the code you showed me has the code to access the cell value from an X and Y address, so one of three things is going on:

1) You don't understand your own code.
2) You aren't thinking about what you are trying to do and expect us to do the thinking bit for you.
Or
3) You are kidding.

I'd prefer to believe the latter because I'm charitable like that...

Robert S4r 28-Jan-19 11:26am

What seems obvious to one person may not necessarily be obvious to another. Fortunately you may take one of the first two reasons but there's plenty of reasons for consulting anyway. Kidding doesn't suit being a reason for people who have plenty of work to do!
So if you can, I request for the assistance, after all I wouldn't ask if I had the answers to everything.
Naturally, some people understand the complex but fail the obvious.

Honestly, nothing is moving on with the project coz of this. There's success for current row.cell property but failure for this case.
Thanks in advance.

OriginalGriff 28-Jan-19 11:33am

OK: what are X and Y in this line:

dataGridView1.Rows[i].Cells[2].Value = ...

Hint: they are in square brackets.

Robert S4r 28-Jan-19 12:34pm

I think x==i any row and y==2 ["third column"]

Actually. I've been using VB.net where most of these properties are not needed. But for some reasons, not long ago, I had to switch to c#

OriginalGriff 28-Jan-19 13:59pm

X is a column reference by tradition and Y is a row, so it's the other way round.

And if you know that, what is stopping you writing a method that returns a value for a specific X and Y coordinate?

Robert S4r 28-Jan-19 14:35pm

The problem is how to apply it to the get{return.....} property.

OriginalGriff 28-Jan-19 15:19pm

Let's go back 9 hours, shall we?
"Then write a method pair in Form2;
GetXY(int x, int y) which returns the value at column x, row y"

Does that mention a property?
Property Getters do not have parameters: you cannot pass an X,Y coordinate to them ...

Robert S4r 28-Jan-19 16:06pm

Maybe you haven't got my problem clearly!

How and where do I apply
>>>>>GetXY(int x, int y)<<<<<
in the above code???

OriginalGriff 29-Jan-19 3:42am

Oh, come on!

valueFromForm2 = form2.GetXY(2, i);
valueFromForm1 = dataGridView1.Rows[i].Cells[2].Value;
if (valueFromForm1 == valueFromForm2)
{
// update cell 3 in form1 ...
}

Robert S4r 29-Jan-19 8:04am

valueFromForm2 ????????

OriginalGriff 29-Jan-19 8:20am

It's a variable name, intended to give you an idea what it holds...

Robert S4r 29-Jan-19 8:59am

I hope you'll excuse me! As I stated earlier, I'm well conversant with VB.net where most of these codes are not needed. I'm trying to convert my project to c# - a requirement.
Thus some things may look too obvious but as you know c# and VB.net are extremely different.
And what I want to achieve seems unavailable on the internet coz I researched for two good weeks.
That's why I look for live examples to make conversions.

Thanks! Though I still have errors with the variables!!!! most probably positioning. The previous code is making wonders for current row but the part of multiple rows is failing everything yet it applys to 7+ sections.

OriginalGriff 29-Jan-19 9:07am

Pardon? They are almost the same, to the point where there are a number of online converters that can swap between them.
And besides, to change a project to a new language you normally start by learning the new language (which if you know VB and thus the .NET framework well will take an experienced dev an afternoon)

Robert S4r 29-Jan-19 9:41am

What I mean is: just this code in VB was enough to accomplish the task, which is not the case for c# as it generates no response when converted.

Private Sub TSMItemUpdateL_Click(sender As Object, e As EventArgs) Handles TSMItemUpdateL.Click
LOAD_ALL()
End Sub

Sub LOAD_ALL()
Dim allrows1 As Integer = Me.DataGridView1.Rows.Count - 1
Dim allrows2 As Integer = Me.LowerDataGridView.Rows.Count - 1
If allrows1 > 0 Then
Dim i, j As Integer
For i = 0 To allrows1
For j = 0 To allrows2
If IsDBNull(DataGridView1.Item("Y_", i).Value) Then
ElseIf IsDBNull(DataGridView1.Item("T", i).Value) Then
ElseIf IsDBNull(DataGridView1.Item("C_", i).Value) Then
ElseIf IsDBNull(DataGridView1.Item("S_", i).Value) Then
ElseIf IsDBNull(DataGridView1.Item("s", i).Value) Then

ElseIf Not IsDBNull(DataGridView1.Item("Y_", i).Value) = Not IsDBNull(LowerDataGridView.Item("Y_", j).Value) And
Not IsDBNull(DataGridView1.Item("T", i).Value) = Not IsDBNull(LowerDataGridView.Item("T", j).Value) And
Not IsDBNull(DataGridView1.Item("C_", i).Value) = Not IsDBNull(LowerDataGridView.Item("C_", j).Value) And
Not IsDBNull(DataGridView1.Item("S_", i).Value) = Not IsDBNull(LowerDataGridView.Item("S_", j).Value) Then

If DataGridView1.Item("Y_", i).Value = LowerDataGridView.Item("Y_", j).Value Then

If DataGridView1.Item("T", i).Value = LowerDataGridView.Item("T", j).Value Then
If DataGridView1.Item("C_", i).Value = LowerDataGridView.Item("C_", j).Value Then
If DataGridView1.Item("S_", i).Value = LowerDataGridView.Item("S_", j).Value Then

If DataGridView1.Item("s", i).Value = "EN" Then
LowerDataGridView.Item("ENI", j).Value = DataGridView1.Item("INI_1", i).Value

ElseIf IsDBNull(LowerDataGridView.Item("S_8", j).Value) Then
ElseIf DataGridView1.Item("s", i).Value = "COM"
Then
If LowerDataGridView.Item("S_8", j).Value = DataGridView1.Item("s", i).Value Then
LowerDataGridView.Item("S8I", j).Value = DataGridView1.Item("INIT_1", i).Value
End If
End If

End If

End If
End If
End If
End If
Next
Next
End If
End Sub

I've tried plenty of converters both online and offline including (instant c#) and all convert well but no result when executed.
Sorry! I've just extructed it from the platform.

Hope you understand me. I know a percentage of c# but you can't know everything unless!