C# Discussion Boards - CodeProject

Muammar©1-May-07 23:52

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)
(><)

Re: Filtering datasets

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.

Re: Filtering datasets

Muammar©2-May-07 0:15

Muammar©

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)
(><)

Re: Filtering datasets

Mazdak2-May-07 0:26

Mazdak

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."

Re: Filtering datasets

Muammar©2-May-07 0:45

Muammar©

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)
(><)

Re: Filtering datasets

Mazdak2-May-07 1:00

Mazdak

2-May-07 1:00

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

Mazy

"This chancy chancy chancy world."

Re: Filtering datasets

Mazdak2-May-07 1:02

Mazdak

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."

Re: Filtering datasets

Muammar©2-May-07 1:16

Muammar©

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)
(><)

Re: Filtering datasets

Mazdak2-May-07 1:22

Mazdak

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."

Re: Filtering datasets

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

Muammar©2-May-07 0:12

Muammar©

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)
(><)

Re: Function Keys

Giorgi Dalakishvili2-May-07 1:01

Giorgi Dalakishvili

2-May-07 1:01

In that case you need to use hooks

Re: Function Keys

Stefan Troschuetz2-May-07 1:09

Stefan Troschuetz

2-May-07 1:09

Search the article for "hooks".

Re: Function Keys

Muammar©

2-May-07 1:18

hooks

thanx!

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

display solid square program

Missy Glory1-May-07 22:33

Missy Glory

1-May-07 22:33

hi...
how to display a solid square composed of a character input.

for example:
square size = 4
fill character = #

result:
####
####
####
####

Re: display solid square program

Vikram.....1-May-07 23:07

Vikram.....

1-May-07 23:07

use 2 for loops ... simple program..

Vikram
I Code...

Re: display solid square program

Colin Angus Mackay1-May-07 23:15

Colin Angus Mackay

1-May-07 23:15

It can be done in one loop, if you use new string('#', squareSize) to output a row.

Upcoming events:
* Glasgow: Introduction to AJAX (2nd May), SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services...

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Re: display solid square program

Keshav V. Kamat1-May-07 23:18

Keshav V. Kamat

1-May-07 23:18

ya. use a couple of loops. something like this. since you have asked for 4 hashes on 4 lines, use something like this.

for(int i = 0; i < 4; i++)
{  
   for(int j = 0; j < 4; j++)
  {    
      Console.Write("#");
  }  
  Console.WriteLine();
}

Keshav Kamat Smile | :)

India

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.