Re: Filtering datasets - C# Discussion Boards

1-May-07 23:52

MyAdapter.Fill(MyDataset.MyTable.Select("Why the hell is it not accepting my select statement here??"));

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Pete O'Hanlon1-May-07 23:58

Pete O'Hanlon

1-May-07 23:58

Because that's not a valid select statement. Big Grin | :-D

Seriously, show us what you put in to the select so we can have a look.

Deja View - the feeling that you've seen this post before.

Muammar©2-May-07 0:15

2-May-07 0:15

Pete O`Hanlon wrote:
Because that's not a valid select statement

.. thank you Pete, I had a great laugh on that Smile | :)

okay, the statement is fine, i made sure of this by pasting it in oracle sql window and it's retriving me my test record..

this.iNV_MICROPROJECTSTableAdapter.Fill(this.dataSet1.INV_MICROPROJECTS.Select("SELECT ID,NAME,PLAN_YEAR FROM INV_MICROPROJECTS WHERE PLAN_YEAR=2001));

Thank you Pete Rose | [Rose]

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Mazdak2-May-07 0:26

2-May-07 0:26

Just put PLAN_YEAR=2001 as your parameter:

this.iNV_MICROPROJECTSTableAdapter.Fill(this.dataSet1.INV_MICROPROJECTS.Select("PLAN_YEAR=2001"));

Mazy

"This chancy chancy chancy world."

Muammar©2-May-07 0:45

2-May-07 0:45

thanx but...

Error 2 The best overloaded method match for 'Sayoon.DataSet1TableAdapters.INV_MICROPROJECTSTableAdapter.Fill(Sayoon.DataSet1.INV_MICROPROJECTSDataTable)' has some invalid arguments E:\My Documents\Visual Studio 2005\Projects\Sayoon\Sayoon\Inv_Microprojects.cs 99 13 District MIS

Error 3 Argument '1': cannot convert from 'System.Data.DataRow[]' to 'Sayoon.DataSet1.INV_MICROPROJECTSDataTable' E:\My Documents\Visual Studio 2005\Projects\Sayoon\Sayoon\Inv_Microprojects.cs 99 53 District MIS

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Mazdak2-May-07 1:00

2-May-07 1:00

The Select() method returns DataRow[] and Fill() method needs another argument.

Mazy

"This chancy chancy chancy world."

Mazdak2-May-07 1:02

2-May-07 1:02

Fill() method needs DataTable , you should use a loop to add your DataRow[] into a DataTable.

Mazy

"This chancy chancy chancy world."

Muammar©2-May-07 1:16

2-May-07 1:16

Call me stupid but tell me how to do it..

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Mazdak2-May-07 1:22

2-May-07 1:22

I guess you have wrong approach, why do you want to put filtered rows in a dataadapter? First tell me what do you want to do exactly?

Mazy

"This chancy chancy chancy world."

szukuro2-May-07 1:51

szukuro

2-May-07 1:51

The method DataAdapter.Fill as the name suggests fills the DataSet or the DataTable that get's passed as an argument. So passing a filtered DataSet doesn't really achieve anything. Perhaps if you were to enlighten us what exactly you are trying to do.

DataRowDeleting

vladinir1-May-07 23:50

vladinir

1-May-07 23:50

How to cancel deleting rows Frown | :(

if i have some condtion? e.Action property is read-only !!!!

private void RowDeleting(object sender, RowChangeEvent e)
{
if (e.Row.ID =20)
{

}
}

nevlad

Re: DataRowDeleting

Bijesh2-May-07 2:11

Bijesh

2-May-07 2:11

You get the DataRow object in the RowChangeEvent. Can't you do a RejectChanges on it to cancel the delete?

Bijesh

--------------------------------------------------

TCP/IP & UDP

Prakash A 19801-May-07 22:59

Prakash A 1980

1-May-07 22:59

HOW TO FIND WHERE THE DATA IS SENT WHETHER TO TCP/IP OR UDP

Prakash

Re: TCP/IP & UDP

Jeeva Jose1-May-07 23:52

Jeeva Jose

1-May-07 23:52

All data is going through port.Are u using winxp go to command window type netstat -a get the list of the port.

Continue...

Function Keys [modified]

mark_w_1-May-07 22:50

mark_w_

1-May-07 22:50

I have a form and I want to do something if the user presses F2. I have tried using the on key press, but the user will be entering info in text boxes and so it does not fire that form event.

And even better if there was a way to make it so if the user pressed F2 anywhere in the app it would fire a bit of code.

Any ideas?

TIA

-- modified at 5:06 Wednesday 2nd May, 2007

Re: Function Keys

Stefan Troschuetz1-May-07 23:27

Stefan Troschuetz

1-May-07 23:27

By setting the Form.KeyPreview property to true, your form gets informed about keyboard events before they are passed to the control that has focus.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Re: Function Keys

mark_w_1-May-07 23:44

mark_w_

1-May-07 23:44

works a treat, thanks

Re: Function Keys