How to delete record by selecting data repeater row c# winforms

Question

0.00/5 (No votes)

See more:

Hello I need help in being able to select a row in a data repeater and be able to pass its value so I can delete that record. I have scoured the internet and cannot figure this out.

Thanks,

Korrowan

Posted 29-Mar-11 8:08am

korrowna

Add a Solution

1 solution

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)

Henry Minute · Accepted Answer · 2011-03-29T11:39:00

Solution 1

What DataRepeater?

Where did the code come from for the DataRepeater?

Posted 29-Mar-11 11:39am

Henry Minute

Comments

korrowna 29-Mar-11 22:35pm

The VB powerpack DataRepeater that is available in VS 2008 SP1+

Henry Minute 30-Mar-11 7:36am

The currently selected item can be accessed with the CurrentItem property or you can use the CurrentItemIndex also. Once selected I suspect, although I haven't tried it, that Ctl-Del will delete that item.

There are a series of 'HowTo' articles on MSDN -->http://msdn.microsoft.com/en-us/library/cc488279.aspx. You may be able to get enough information by reading/working through them.

korrowna 30-Mar-11 8:22am

Thank you Henry. I will read through that and see if I can figure this out. Out of curiosity Ctl-Del will delete the row but not the record correct?

Henry Minute 30-Mar-11 8:32am

Ctl-Del is the 'standard' method for grid like controls and whether it will delete record depends on how the databinding is set up. If it works for the DataRepeater at all, it should delete the row from the in-memory datastore if you use one.

korrowna 30-Mar-11 9:15am

Well here is what I did and it functions... not sure if its the best solution just thought I would share.

One thing I thought that was odd is when I attempted to use datarepeater1.endresetitemtemplate() it actually flashed the record off and then back onto the screen but without it it works. Either way it seems to function as intended!

private void cmdDeleteDoc_Click(object sender, EventArgs e)
{
//check to see if currentitem is 0
if (this.dataRepeater1.CurrentItemIndex == 0)
{

//begin reset
this.dataRepeater1.BeginResetItemTemplate();
// Delete Row Here

DataClasses1DataContext db = new DataClasses1DataContext();

System.Data.DataRowView SelectedRowView;
newCityCollectionDataSet.DocumentsRow SelectedRow;

SelectedRowView = (System.Data.DataRowView)documentsBindingSource.Current;
SelectedRow = (newCityCollectionDataSet.DocumentsRow)SelectedRowView.Row;

var matchedDocument = (from c in db.GetTable<document>()
where c.DocIDKey == SelectedRow.DocIDKey
select c).SingleOrDefault();

db.Documents.DeleteOnSubmit(matchedDocument);
db.SubmitChanges();

LoadCaseNumberKey(matchedDocument.CaseNumberKey, false, "docuements");

}
}

Henry Minute 30-Mar-11 9:23am

Thanks for sharing.