|
Hi everyone,
I've got a dialog box with checkboxes, comboboxes and textboxes for filling in. I have it saving perfectly into my access database. On this dialog I have Load button, which opens a new dialog. This has a search textbox, a datagridview and a few buttons. The datagridview displays the contents of the database.
I would like to be able to get the information in the selected row of the datagridview and load that into the original dialog. I have tried to figure it out myself, but my C# knowledge is limited.
I don't really have any code for loading, but If i write anything i'll get it posted.
Any direction in this would be greatly appreciated.
Many thanks
Martin
|
|
|
|
|
Hi Martin,
Take a look at 'DataGridViewRow'.
That should get you started.
If you cannot get it working, post back with an example of what you have tried, and I will try to help.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Thanks.
I've had a play with that previously, couldn't really figure out out to implement it though, I'll just keep going.
|
|
|
|
|
Hi Martin,
The DataGridView has a property called SelectedRows, which is a collection of the rows currently selected. There is also an event called OnRowEnter. Both of these give you access to the DataGridViewRow selected by your user. What is needed is a way to track that row and make it available to your calling form when the dialog closes. So:
1. add a private field to your dialog.
private DataGridViewRow selectedRow;
2. add a public property so that it can be accessed from outside the dialog
public DataGridViewRow SelectedRow
{
get
{
return this.selectedRow;
}
}
3. If you elect to use OnRowEnter, for example, you can store the row in the private field. In the event handler:
this.selectedRow = this.dataGridView1.Rows[e.rowIndex];
then every time a new row is entered that row is stored in your field.
4. In your calling form:
if (datagridDialog.ShowDialog() == DialogResult.OK)
{
this.FillData(datagridDialog.SelectedRow);
}
private void FillData(DataGridViewRow loadedRow)
{
this.usernameTextBox.Text = loadedRow.Cells["UserName"].Value.ToString();
etc.
}
Hope this gives you some idea.
It has just occurred to me that your calling forms controls might be databound, if so this won't work, please let me know.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Thanks alot for that.
I've found a simpler way to get the cell value. I'm just getting the value from the datagridview with:
class1.UserID = dtaSearchID.SelectedRows[0].Cells[0].Value.ToString();
I do that for all the cells in the selected row.
The problem I have now is that I'm not asure how to automatically fill those details into the first dialog. I am able to do it when i manually trigger an event, ie. click another button. But I can't figure out how to do it on the click of the load button in my Search from.
Any help greatly appreciated.
Martin
|
|
|
|
|
One solution to this is not to handle the button-click event in the search form, but in your first dialogue.
This is one reason that I suggested the public DataGridViewRow SelectedRow property in my previous post.
In your Search dialogue:
public event EventHandler LoadButtonClick
{
add
{
this.loadButton.Click += value;
}
remove
{
this.loadButton.Click -= value;
}
}
doing it this way keeps to OOP principles. Of course if you want to 'cheat' just change the Modifier property for the button, in the properties window, to public.
You will have to declare a reference to the Search dialogue as a field of the first dialogue:
public class FirstDialog : Form
{
private SearchDialog sd = null;
........
........
........
........
Then in the first dialogue, where you create the search dialogue, something like:
using (sd = new SearchDialog())
{
sd.LoadButtonClick += MyLoadButtonClickHandler;
if (sd.ShowDialog() == DialogResult.OK)
{
sd.LoadButtonClick -= MyLoadButtonClickHandler;
}
else
{
sd.LoadButtonClick -= MyLoadButtonClickHandler;
}
}
The click handler can then do
private void MyLoadButtonClickHandler(object sender, EventArgs e)
{
this.UserNameTextBox.Text = sd.SelectedRow.Cells["UserName"].Value.ToString();
etc.
}
Hope this gives you some ideas.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Thanks so much, that works beautifully.
Not entirely sure exactly how it works, but I'll work it out hehe.
Many thanks
Martin
|
|
|
|
|
Hi Guys,
I am working on a Windows Form where I have placed a Button control (Button text: Exit). In the Button1_Click event Handler, I have added this code:
//Code begins here
private void button1_Click(object sender, EventArgs e)
{
MessageBox.Show("Are you sure to exit the application! Selct Ok to Exit now or Cancel to stay in the current form", "Sample App", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);
if (MessageBox.Show("Are you sure to exit the application! Selct Ok to Exit now or Cancel to stay in the current form", "Sample App", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation) == DialogResult.OK)
{
Close();
}
else
{
return;
}
}
//Code ends here
However, when I debug the solution and click on the Exit button, the Message Box is displayed asking for confirmation. Then, when I click on the Ok button, instead of closing the application, the same Message Box pops up again! Then, again I have to click on Ok and this time the Click Event executtes and the application closes. Similar is the case with the Cancel Button. Why does the MessageBox display the same message twice? Help me Please....
Your help will be appreciated. Thanx....
|
|
|
|
|
youve now posted te same question again a mere 10 minutes later.
READ THE CODE. STEP THROUGH THE CODE. IT IS OBVIOUS WHY YOU GET TWO MESSAGE BOXES.
I thought you might be hard-of-reading so i shouted that in the typical englishman manner of just talking louder and slower to foreigners in english.
|
|
|
|
|
|
Kwagga wrote: Newby and Hoemwork
Newbie and Homework   
"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)
|
|
|
|
|
Hello there,
Plz dont shout at me! I am only a newbie here. If I'm finding something difficult to understand, then its your sole responsibility to help me out. I know that there's some mistake with the code, but am unable to mark it out..... Please give me a hint.
Your help will be appreciated...
thanx 
|
|
|
|
|
Rajdeep.NET wrote: Please give me a hint.
You're kidding, right? You've had so many hints already that if you cant work it out now its time to hand back your textbooks, cancel your account with your college computer centre, and go get a job flipping burgers.
|
|
|
|
|
J4amieC wrote: and go get a job flipping burgerscow patties.
Fixed that for you. 
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots.
-- Robert Royall
|
|
|
|
|
Rajdeep.NET wrote: its your sole responsibility to help me out
It will be Jamie's responsibility to help you out when you pay him for it.
|
|
|
|
|
Vikram A Punathambekar wrote: Carpe Diem.
When it comes to threads like this I really am thinking more along the lines of Carpe Jugulum
|
|
|
|
|
Rajdeep.NET wrote: then its your sole responsibility to help me out.
What ????? What do you think we are ? Your mother,your parents ? Why is my f**king sole responsibility to answer to your questions ?
Get real asap and decide to start studying more than talking.
|
|
|
|
|
I think, as with many posts on here, that certain phrases get lost in translation.
Obviously the guy is a beginner coder, possibly a beginner in English too 
|
|
|
|
|
By the way its quite obvious moron. Read your (???) code 
|
|
|
|
|
Clearly, you didn't do a very good job of it. You should have separated the letters with spaces l i k e t h i s to mimic the effect of talking slower.
|
|
|
|
|
You're right. very good point.
|
|
|
|
|
Raj check the answer which is already given....
BTW why did you delete the previous post and re-posted the same content here...????
Have a Happy Coding.....
|
|
|
|
|
Sorry for deleting the previous post,
there was a mistake in it. Instead of writing
Button1_Click, I wrote Button3_Click. It wouldn't have affected the
program too much, but I did so, to make u people understand the code better such that it doesn't affect the main motive of the program.
plz help 
|
|
|
|
|
Rajdeep.NET wrote: there was a mistake in it. Instead of writing
Button1_Click, I wrote Button3_Click
That made me really chuckle.
|
|
|
|
|
You seem to read every message except the ones that give you the solution. Did you even try what 8kelvin suggested below?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
