C# Discussion Boards - CodeProject

Tom Deketelaere23-Jul-09 4:03

Tom Deketelaere

23-Jul-09 4:03

Is your userid column in the datatable numeric?

If so remove the tostring (not needed here)

If not try the code I gave (but I don't think that's the problem)

jonhbt wrote:
the strange thing is that this process runs for most of the values but at a certain point in time it stops

Does it always stop at the same value? or is random?

Are you using multi - threading?

jonhbt23-Jul-09 4:20

23-Jul-09 4:20

no im not useing multi threading. The value is the same only for the set of values chosen. WHen i change the set of values by a filter from the select command in the database, the value is different.

Tom Deketelaere23-Jul-09 4:29

Tom Deketelaere

23-Jul-09 4:29

When you debug and stop at the select line try doing a 'quick watch' (right mouse click)

Then run the select (dtscv.select("Userid=" + newrow["userid"]) ).

Does that work?
Is the value present or not?

Can you post your declaration of the dtscv datatable? (specifically the column declarations )

jonhbt23-Jul-09 4:43

23-Jul-09 4:43

This is my declaration of te DataTable

DataColumn Column1 = new DataColumn("Name");
               DataColumn Column2 = new DataColumn("Department");
               DataColumn Column3 = new DataColumn("Date");
               DataColumn Column4 = new DataColumn("UserID");
               DataColumn Column5 = new DataColumn("CheckType");

               dtCSV.Columns.Add(Column1);
               dtCSV.Columns.Add(Column2);
               dtCSV.Columns.Add(Column3);
               dtCSV.Columns.Add(Column4);
               dtCSV.Columns.Add(Column5);

Ill try what you suggested

Tom Deketelaere23-Jul-09 5:01

Tom Deketelaere

23-Jul-09 5:01

try:

DataColumn Column4 = new DataColumn("UserID",typeof(int));

jonhbt23-Jul-09 5:27

23-Jul-09 5:27

I think that solved the problem. I stil have to takle the performance issue, but THANKS alot for your help

MumbleB23-Jul-09 3:36

MumbleB

23-Jul-09 3:36

Can you put a Try Catch in there and post the error message from the catch? Put the whole block of code from the foreach in a try block and then a catch at the end. This should give you better idea of what the error is.

Excellence is doing ordinary things extraordinarily well.

jonhbt23-Jul-09 3:43

Border Less Window Mouse Left click

23-Jul-09 3:43

I have a try catch but, only error prompting is System.argument Exception{"Min (14) must be less than or equal to max (-1) in a Range object."}

satsumatable23-Jul-09 2:45

satsumatable

23-Jul-09 2:45

Hi,

I've Border less window hence there is no min/max buttons. I've managed to place the buttons to min/max, i want to get the minimize and maximizing the when i do mouse click on the task bar. How can i get this done ?

shlomtzi23-Jul-09 2:52

shlomtzi

23-Jul-09 2:52

hi,
i'm not sure but in C++ you can catch windows messages
try to catch the mouse click event

satsumatable23-Jul-09 2:57

satsumatable

23-Jul-09 2:57

Even here it is possible

private const int WMTaskbarLClick = 0x0210;
       bool b = true;

       protected override void WndProc(ref Message wndMessage)
       {


           switch (wndMessage.Msg)
           {
               case WMTaskbarLClick:
                   {
                       if (this.WindowState != FormWindowState.Minimized)
                           this.WindowState = FormWindowState.Minimized;
                       else
                           this.WindowState = FormWindowState.Normal  ;
                       break;
                   }
               default:
                   {
                       base.WndProc(ref wndMessage);
                       break;
                   }
           }
       }

But it is not working for border less forms....any thoughts

shlomtzi23-Jul-09 3:04

shlomtzi

23-Jul-09 3:04

It might that border less forms not listen to min/max events

workaround is maybe to hide/show the form

Henry Minute23-Jul-09 3:25

Henry Minute

23-Jul-09 3:25

This[^] thread might help, or at least give you some ideas.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

satsumatable23-Jul-09 5:13

satsumatable

23-Jul-09 5:13

Hi,

This helped much... BTW 0x0313 is the Hexa code for mouse right click, what is the code for mouse left click ?

Thanks

need suggestion how to move object on screen in run time

Henry Minute23-Jul-09 6:08

Henry Minute

23-Jul-09 6:08

satsumatable wrote:
BTW 0x0313 is the Hexa code for mouse right click

Where did you get this information from?
I have googled and found no reference to it.
The only reference to 0x0313 that I can find, for 0x0313 and mouse, is to the WParam of a, seemingly, undocumented Win32 message, whose LParam contains the mouse coordinates.

shlomtzi23-Jul-09 2:39

shlomtzi

23-Jul-09 2:39

when using drag and drop you donlt actually move the object ,you just move the cursor then drop it.

i want to use drag and drop but to see the object moving on the scrren.

thanks in advanced

Re: need suggestion how to move object on screen in run time

musefan23-Jul-09 2:42

musefan

23-Jul-09 2:42

This[^] is an example of how to have a ghost image when dragging in a treeview, you should be able to use that logic for your needs

Life goes very fast. Tomorrow, today is already yesterday.

how to insert..

mjawadkhatri23-Jul-09 1:59

23-Jul-09 1:59

how 2 insert date and time both in one field??
data type of field is date

Tamer Oz23-Jul-09 2:04

Tamer Oz

23-Jul-09 2:04

Use datetime ?
Which platform are you using?

mjawadkhatri23-Jul-09 2:07

23-Jul-09 2:07

i get date and time in label in this format
23-JUL-2009 18:06 PM
now i want to add this time or date in database.

Tamer Oz23-Jul-09 2:10

Tamer Oz

23-Jul-09 2:10

first use the code below to convert text to datetime

DateTime d=Convert.ToDateTime(lblFoo.Text);

then send d value to database.

mjawadkhatri23-Jul-09 2:12

23-Jul-09 2:12

okay thanks.

musefan23-Jul-09 2:14

musefan

23-Jul-09 2:14

With the limited information you have provided, a musefan search returned too many results to display. Please refine your query.

mjawadkhatri wrote:
how 2 insert date and time both in one field??

do you want to insert 2 instances of the date and just 1 time or is it 2 instances of a date AND a time?

mjawadkhatri wrote:
data type of field is date

I didn't know fields had a 'date' type, I thought it was either 'Cow' or 'Sheep' or some other animal... oh, maybe your mean like a field in a table or something? It's hard to tell with such limited information

So, to sum up...

Are you referring to a field in a database? If so, what kind of database is it?
What format is the date and time data that you are trying to input? How is it stored?

P.S. the beauty of written messages is that people can re-read if they don't understand, so there is no need to shout if you fear they may not hear you the first time.

Just incase...

the beauty of written messages is that people can re-read if they don't understand, so there is no need to shout if you fear they may not hear you the first time.

I look forward to your lack of response Wink | ;)

Life goes very fast. Tomorrow, today is already yesterday.

Muhammad Mazhar23-Jul-09 2:17

Muhammad Mazhar

23-Jul-09 2:17

well if the column is of type data you can't place time along with it. I suggested backup your db or better first create some test data base create a column with type date, populate some entries and then change column type to date time and see results. I think changing column type form date to date time won't heart your existing changes because date time can accommodate more information so there would be no information loss in this way your change would be backward compatible.

Share your experience with others
Check my Blog...

mjawadkhatri23-Jul-09 2:33