Re: How to delete row in datagrid/datatable with a delete button - C# Discussion Boards

Re: How to delete row in datagrid/datatable with a delete button

4-Aug-05 0:30

Hi!

I can't seem to make it work. I select a row in a datagrid and press a delete button. That row is then deleted. But if i add/delete many rows, then close and reopen my dialog and try to delete a row again, the row with index 0 is deleted instead of the one i have selected. I have tried to use currency manager to delete and everything, but I can't make it work properly.

This is how I delete a row:

<br />
if(_currencyManager.Current.GetType() != typeof(DataRowView)) return;<br />
				<br />
DataRowView dr = (DataRowView)_currencyManager.Current;			<br />
dr.Delete();   <br />
_currencyManager.EndCurrentEdit();<br />
_currencyManager.Refresh(); <br />
_dtPplan.AcceptChanges();<br />

I set the currency manager like this:

<br />
_currencyManager = (CurrencyManager)this.BindingContext[dgPplan.DataSource, dgPplan.DataMember];

And fill the table with data like this each time i open the dialog. Just so i'm sure it got the latest data:

<br />
_dtPplan.Rows.Clear();<br />
foreach(PPlan pPlan in valueObject.PPlan) <br />
{				<br />
 DataRow dr = _dtPplan.NewRow();<br />
 dr[NetworkKeywords._cCriteria] = pPlan.Criteria;<br />
 dr[NetworkKeywords._cParameter] = pPlan.Parameter;<br />
 dr[NetworkKeywords._cValue] = pPlan.Value;<br />
 dr[NetworkKeywords._cUnit] = pPlan.Unit;<br />
 _dtPplan.Rows.Add(dr);<br />
}<br />
_dtPplan.AcceptChanges();<br />
<br />
_currencyManager = (CurrencyManager)this.BindingContext[dgPplan.DataSource, dgPplan.DataMember];     <br />

I really need help on this. This datagrid/datatable is driving me crazy.

Thanks in andvance

Atle

deep74-Aug-05 0:48

Re: How to delete row in datagrid/datatable with a delete button

4-Aug-05 0:48

I would suggest you that,instead of having a delete button, u keep a contextmenu for the datagrid, and in the delete menu click event,u delete the selected row..sumthin like this..

int rowIndex = dataGrid1.CurrentRowIndex;
dataTable.Rows[dataGrid1.CurrentRowIndex ].Delete();
//then call the function to delete the row
and u retrieve the data correctly
try it..datagrids n datatables ain't so bad Smile | :)

Atlemann4-Aug-05 3:06

Re: How to delete row in datagrid/datatable with a delete button

4-Aug-05 3:06

I also have an "Add" and "Delete All" button that I need. The way you are mentioning her will work with a button too won't it? Just use your code inside the buttons aciton?

What happens when I sort the datagrid? Then the row indexes in the datagrid won't correspond to the row indexes in the datatable will they? Only the datagrid's rows are sorted, or? Then I will need the currency manager to keep track of that?

- Atle

Alomgir Miah4-Aug-05 4:26

Alomgir Miah

4-Aug-05 4:26

I agree with deep7.
You can have a context menu with the following items

Delete,
Delete All

You can add a new row on mouse click on the white region.

private void OnGridMouseUp(object sender, MouseEventArgs e)
{
//Get Current Point
this.hitTestGridInfo = this.dataGridAllocation.HitTest(new Point(e.X, e.Y));
//Capture Grid Body Event
if (this.hitTestGridInfo.Type == DataGridEx.HitTestType.None &&
e.Button == MouseButtons.Left )
{
newDataRow = this.dataTable.NewRow();
this.dataTable.Rows.Add(newDataRow);
}
}

As far as sort order is concerned, you can use,

private DataRow GetDataRowAt(int index)
{
DataRow dataRow = null;
CurrencyManager currencyManager = null;

currencyManager = (CurrencyManager)this.BindingContext[this.dataTable];

if ( currencyManager != null )
{
dataRow = ((DataRowView)currencyManager.List[index]).Row;
}
return dataRow;
}

Live Life King Size
Alomgir Miah

Re: How to delete row in datagrid/datatable with a delete button

Atlemann4-Aug-05 20:33

Re: How to delete row in datagrid/datatable with a delete button

4-Aug-05 20:33

Looks like the datagrid is messed up after refilling the datatable or something. You see how i fill it with data in my first post. Is there another way to do it? I need to fill in some data from an arraylist. I refill the datagrid according to what I select in a combobox.

It seems my problem is that after clearing and refilling the datatable with data a couple of times (selecting differend things in the combobox), the datagrid returns selected row index = 0 for each and every row i press. Then suddenly it can return index out of bounds exception when I press a row??

- Atle

Atlemann4-Aug-05 20:50

How to shedule Tasks using C# ?

4-Aug-05 20:50

Hmm....seems like it likes

	<br />
foreach(DataRow row in _dtPplan.Rows) <br />
{<br />
row.Delete();<br />
}<br />
_dtPplan.AcceptChanges();<br />

for deleting all rows than

<br />
_dtPplan.Rows.Clear()<br />

I have to test it a little more, but it seems like the index problem is gone now. It works with the add and delete buttons in the form by the way. Thanks for your help.

- Atle

pubududilena4-Aug-05 0:26

pubududilena

4-Aug-05 0:26

hi all,
I need to shedule a Task in windows 2000.I can easily do it using Control Panel--->Sheduled Task ..

But How am I shedule a task using a C# Application..?

Can any one please help me.?

thanks in advance..

Re: How to shedule Tasks using C# ?

Sean Michael Murphy4-Aug-05 3:38

Sean Michael Murphy

4-Aug-05 3:38

http://www.codeproject.com/csharp/tsnewlib.asp[^]

bizarre datetime parse error ...

spazzman3-Aug-05 22:32

spazzman

3-Aug-05 22:32

I'm using

System.IO.Directory.GetCreationTime(folderName)

to get the creation date of a folder, but it throws an ArgumentOutOfRangeException with the message

"Specified argument was out of the range of valid values.
Parameter name: Not a valid Win32 FileTime."

The folder in question is on a CDR that was burnt on a PC with a different datetime locale. Why is it that Windows Explorer can display the datetime of the folder without any problems, but the .net framework chokes on it? Does System.IO.Directory require some sort of CultureInfo to parse dates? If so, where do I specify this?

Thanks in advance

Web service requests

WayneScott3-Aug-05 22:24

WayneScott

3-Aug-05 22:24

I am trying to limit the amount of time an ASP.NET Web Service can spend processing a client’s request.

Currently if the client sets it’s timeout to Infinite the server will allow the request to complete; however I want to stop the request and send a custom response back to the client after a specified time limit.

What is the best way of achieving this?

Hard Disk

ahmad hosny3-Aug-05 21:49

ahmad hosny

3-Aug-05 21:49

How can i get the hard disk Id or the motherboard ID programatically?

hosny

Re: Hard Disk

Mohamad Al Husseiny3-Aug-05 22:09

3-Aug-05 22:09

salam alikom ahmed
look at WMI i think they have waht you search for
For HardDisk[^]
MotherBoard[^]
and CodeProject Host Article about HardDisk Serial Number
How to retrieve REAL Hard Drive Serial Number
[^]

populating combobox

deep73-Aug-05 21:04

3-Aug-05 21:04

hi all,
in my code i'm populating a combobox which is one of the columns in th datagrid.
i want the combobox to be populated with data from two tables from the database.
like for example the 'name' and the 'Description'.
At present i'm getting only the 'name in the combobox.
how to get its description also ??

Mohamad Al Husseiny3-Aug-05 21:19

3-Aug-05 21:19

did you mean by using data binding or by the code
if you mean data binding i think you can not
bind combo box to two fields
in the code get the data and loop for each recored add the two fields value

deep73-Aug-05 21:34

3-Aug-05 21:34

i'm getting only the names in the combobox, but i also want the description to be next to the name separated by space.

m doing it as below...
newColumnStyle.MappingName = "New";
newColumnStyle.HeaderText= "New";
newColumnStyle.Width = 101;
newColumnStyle.MyComboBox.Items.Clear();

for(int i = 0; i < getData.Length; i++)
newColumnStyle.MyComboBox.Items.Add(getData[i].name );//here how to add in the combobox the 'getData[i].description'

tableStyle.GridColumnStyles.Add(newColumnStyle);

any help appreciated

Mohamad Al Husseiny3-Aug-05 21:40

3-Aug-05 21:40

try somthing like this
newColumnStyle.MyComboBox.Items.Add(getData[i].name + " " + getData[i].description)

deep73-Aug-05 22:53

3-Aug-05 22:53

thanx...silly me dinn think of concating...
but my problem ain't solved yet.
when i select one of the names, and then i fill in other columns other details, and click on 'save' button, only the name should be saved and not the description...

in save button click,
for each row,
for (int i = 0; i < dataTable.Rows.Count ;i++)
{
testData.name = Convert.ToString(dataGrid1[i ,2]).Trim();
//other details from the datagrid
//then i call a function to add the details from the datagrid in the database
addDetails(testData);
}
thanx for helping Smile | :)

Mohamad Al Husseiny3-Aug-05 23:20

3-Aug-05 23:20

you need to extract name only
some thing like the following will extract it
//text that contain both name and description
//" " the sperator replace it with your own

<br />
string name=text.Substring(1,text.IndexOf(" ")+1);

then testData.name=name

deep74-Aug-05 0:20