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

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

mark_w_1-May-07 23:44

mark_w_

1-May-07 23:44

works a treat, thanks

2-May-07 0:12

Hello Stefan, you seem to know much about keys Smile | :)

.. do you know how to capture key strokes without activating my form.. that is, on windows desktop or another windows, like when you want one key to function the same way "ie. launching an application" when pressed anywhere, anytime.. Thank you Stef Rose | [Rose]

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

Giorgi Dalakishvili2-May-07 1:01

Giorgi Dalakishvili

2-May-07 1:01

In that case you need to use hooks

Stefan Troschuetz2-May-07 1:09

Stefan Troschuetz

2-May-07 1:09

Search the article for "hooks".