|
I created a method that makes use of the .Select() method so that to check in a datatable if the value is already in the data table. For 1/4 of the recordss its working but at certain point it prompts out the fllowing error
Min (14) must be less than or equal to max (-1) in a Range object.
I am getting the data from MS Access. I have changed the databases so that to check if it was only with one version but It still showed me the error. only the number 14 changed. I have checked the records of the ids that the program was stopping all and they are all good values. Can some one help on that please. it is very urgent. THAnks alot for your time and help.
|
|
|
|
|
jonhbt wrote: it is very urgent
Of course it is, all questions here are urgent to the poster. But this is a free site so... (hint don't post that again)
As to your problem can you provide the code that does the select (so your method) and some of the values where the code gives that error on?
|
|
|
|
|
Sry for that I didn't want to cause any problems the code that I am using is this
DataTable dtAllEmps = new DataTable();<br />
dtAllEmps = cetData.GetALLEmployessByDate(conString, sensors);<br />
<br />
<br />
foreach (DataRow dataRow in dtAllEmps.Rows)<br />
{<br />
if(dtCSV.Rows.Count == 0)<br />
{<br />
DataRow newRow = dtCSV.NewRow();<br />
newRow["UserID"] = dataRow["USERID"];<br />
newRow["Department"] = dataRow["DEPTNAME"];<br />
newRow["Date"] = dataRow["CHECKTIME"];<br />
newRow["Name"] = dataRow["NAME"];<br />
newRow["CheckType"] = dataRow["CHECKTYPE"];<br />
dtCSV.Rows.Add(newRow);<br />
}<br />
else<br />
{<br />
Console.WriteLine("User ID " + dataRow["USERID"].ToString());<br />
if (dataRow["USERID"].ToString() != "")<br />
{<br />
string strExpr = "UserID = " + dataRow["USERID"].ToString();<br />
Console.WriteLine("Expression " + strExpr);<br />
DataRow[] filteredRows = dtCSV.Select(strExpr);<br />
<br />
<br />
if (filteredRows.Count() == 1)<br />
{<br />
Console.WriteLine("Number of Rows " + filteredRows.Count().ToString());<br />
DataRow csvRow = filteredRows[0];<br />
DateTime csvDate = Convert.ToDateTime(csvRow["Date"]);<br />
DateTime tableDate = Convert.ToDateTime(dataRow["CHECKTIME"]);<br />
Console.WriteLine("csvDate" + csvRow["Date"].ToString());<br />
Console.WriteLine("tableDate" + dataRow["CHECKTIME"].ToString());<br />
if (csvDate < tableDate)<br />
{<br />
filteredRows[0]["Date"] = tableDate.ToString();<br />
filteredRows[0]["CheckType"] = dataRow["CHECKTYPE"].ToString();<br />
filteredRows[0]["Department"] = dataRow["DEPTNAME"].ToString();<br />
}<br />
|
|
|
|
|
I am writing the console calls so that to know what is the last value that the program is having. It is crashing in this part. The values when the program throws the exception differ.
<br />
string strExpr = "UserID = " + dataRow["USERID"].ToString();<br />
Console.WriteLine("Expression " + strExpr);<br />
DataRow[] filteredRows = dtCSV.Select(strExpr);<br />
|
|
|
|
|
Don't worry you didn't cause problems, was just a hint.
Another hint:
When posting code use the 'code block' tags, makes it easier to read the code.
As to your problem.
At what userid does the error occur?
My guess would be that since you do a 'tostring' your userid is of the type string (varchar).
If so your filter expression should be:
"UserID = '" + datarow["USERID"].ToString() + "'";
|
|
|
|
|
thanks for the advices. Regarding to the problem the values are Numbers in the database. There wasn't only one value since i tried different values. One of them was 279 which was giving problems. the strange thing is that this process runs for most of the values but at a certain point in time it stops. that is why i am confused, since all the values that are being passed are numbers.
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
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 )
|
|
|
|
|
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
|
|
|
|
|
try:
DataColumn Column4 = new DataColumn("UserID",typeof(int));
|
|
|
|
|
I think that solved the problem. I stil have to takle the performance issue, but THANKS alot for your help
|
|
|
|
|
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.
|
|
|
|
|
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."}
|
|
|
|
|
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 ?
|
|
|
|
|
hi,
i'm not sure but in C++ you can catch windows messages
try to catch the mouse click event
|
|
|
|
|
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
|
|
|
|
|
It might that border less forms not listen to min/max events
workaround is maybe to hide/show the form
|
|
|
|
|
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.”
|
|
|
|
|
Hi,
This helped much... BTW 0x0313 is the Hexa code for mouse right click, what is the code for mouse left click ?
Thanks
|
|
|
|
|
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.
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.”
|
|
|
|
|
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
|
|
|
|
|
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 2 insert date and time both in one field??
data type of field is date
|
|
|
|
|
Use datetime ?
Which platform are you using?
|
|
|
|