|
ds.Tables[0]
is where the exception is happening - ds has a an array of tables called Tables.
The exception is being caused by the array being empty. Why it's empty I can't know, this line:
ds = bl.Totall(f,t);
is the closest anyone can get. Setting aside the mis-spelling of "Totall" which you might want to fix, the bl.Totall(...) method isn't returning an array with anything in it - so that method is your problem. As you haven't provided the code for that method, we can't tell why it's returning an empty array. If you want further help, you'll need to post the code for that method and anything else associated with it that is relevant.
|
|
|
|
|
A was looking at now of the projects which describing how to simulate mouse movement and clicking on a certain coordinates.
I wrote this code based on what I learned from that project, it's actually the same..
but it's not working..
if this code is not correct
is there any way of doing that ? and how to implement that..
this the code
[DllImport("User32.dll")]
public static extern void mouse_event(MouseEventType dwFlags, int dx, int dy, int cButtons, int dwExtraInfo);
[DllImport("User32.dll")]
public static extern int SetCursorPos(int x, int y);
public enum MouseEventType : int
{
LeftDown = 0x02 , LeftUp= 0x04, RightDown= 0x08, RightUp= 0x10
}
and here is event handler, so when I click the button the mouse supposed to move to the coordinates..
private void button1_Click(object sender, EventArgs e)
{
SetCursorPos(300, 200);
mouse_event(MouseEventType.LeftDown, Cursor.Position.X, Cursor.Position.Y, 20, 20);
mouse_event(MouseEventType.LeftUp, Cursor.Position.X, Cursor.Position.Y, 20, 20);
}
any help in this,,
thanks 
|
|
|
|
|
"but it's not working.."
That's not helpful.
What is it doing that you didn't expect, or not doing that you did?
Remember that we can't see your screen, access your HDD, or read your mind - we only get what you tell us to work with!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I only need to move the mouse to any coordinate after clicking on a button, only that is it!
I have a form application contains only a button, when I click the button (as you can see from the handler) I just need the mouse to be moved to any coordinate..
I know It may not difficult, but I couldn't do it till now..
I'm using VS 2012 ultimate..
thanks
|
|
|
|
|
And? What is happening when you run your code?
I really can't see your screen! 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
if you mean the code which I written, nothing happens, it's not working at all. when I click the button nothing happens!!
if you mean what I need to get, it's only moving the mouse without touching any thing!!
|
|
|
|
|
|
Well, you could start by using .NET cursor movement:
Point current = Cursor.Position;
Cursor.Position = new Point(current.X + 50, current.Y + 10);
And then this works for me:
[DllImport("user32.dll", CharSet = CharSet.Auto, CallingConvention = CallingConvention.StdCall)]
public static extern void mouse_event(uint dwFlags, int dx, int dy, int cButtons, int dwExtraInfo);
private const uint MOUSEEVENTF_LEFTDOWN = 0x02;
private const uint MOUSEEVENTF_LEFTUP = 0x04;
private const uint MOUSEEVENTF_RIGHTDOWN = 0x08;
private const uint MOUSEEVENTF_RIGHTUP = 0x10;
private void butClickMe_Click(object sender, EventArgs e)
{
Point current = Cursor.Position;
Cursor.Position = new Point(current.X + 50, current.Y + 10);
mouse_event(MOUSEEVENTF_LEFTDOWN | MOUSEEVENTF_LEFTUP, Cursor.Position.X, Cursor.Position.Y, 0, 0);
}By putting a second button on the form, slightly right and down from the first, it gets clicked every time...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Thanks OriginalGriff
the code is working ,,
but I have one more question
if I need for example to first LEFTDOWN and then move the cursor somewhere and then LEFTUP.
can we do that ?
As I know, MOVE mouse event is like
private const uint MOUSEEVENTF_MOVE = 0x0001
it's not working, and when I comment it the mouse events work fine..
how can we implement this ?
thanks,
|
|
|
|
|
The chances are that you can't do it quite like that: the way windows handles messages is probably why - they get queued, not executed immediately, so it's very unlikely that
Left down
Move mouse
left up will be executed in that sequence.
It's possible (I haven't tried) that this would work:
mouse_event(MOUSEEVENTF_LEFTDOWN, Cursor.Position.X, Cursor.Position.Y, 0, 0);
mouse_event(MOUSEEVENTF_LEFTUP, Cursor.Position.X + 100, Cursor.Position.Y + 100, 0, 0); It probably should.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I tried this one many times before
mouse_event(MOUSEEVENTF_LEFTUP, Cursor.Position.X + 100, Cursor.Position.Y + 100, 0, 0);
But the cursor not moves andy stay in the same position
and when I use this one
mouse_event(MOUSEEVENTF_MOVE, Cursor.Position.X, Cursor.Position.Y ,0, 0);
it also not moves the mouse
I tried to add some numbers to the coordinates but it's not working also,,
|
|
|
|
|
No, mouse_event won't move the mouse - it just signals that a mouse event occurred at the location, even if the mouse wasn't (and isn't) anywhere near it.
If you want the mouse to move, the operation to happen, and the mouse to move again, then you are going to have to use timers to move it, then issue a command, then wait for the next timer tick before doing the next event.
Just what are you trying to write here - I'm interested?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
So why don't you call SetCursorPos as that function does exctly what you want. It sets the mouse cursor to the specified location.
What you are doing is creating a mouse event. If nothing at that position you specified is able to respond to that event, then you'll see absolutely nothing.
Oh, but wait you would see something if you were looking at it. Everytime you klick somewhere on the screen or raise an event to that effect, the idle timer is reset to 0.
Cheers!
P.S. I just checked and it seems you can also raise mouse moved events read all about it here: mouse_event function[^], but you should know that the SendInput[^]function should be called instead.
"I had the right to remain silent, but I didn't have the ability!"
Ron White, Comedian
|
|
|
|
|
I want convert code C# 2008 to code C# 2005, I did not understand the command C# 2008 to switch to C# 2005, see below is the error code can solve the error command do ? run the code in C# 2008 very good
[code]
private void textBox1_TextChanged(object sender, EventArgs e)
{
string str = textBox1.Text.Trim();
if (!string.IsNullOrEmpty(str))
{
// Error in here
Expression<func<customdata, bool="">> expr = n => GetCondition(n, str);
this.gridControl1.DataSource = this.lstCustomData.Where<customdata>(expr.Compile()).ToList();
}
else
this.gridControl1.DataSource = this.lstCustomData;
this.gridControl1.RefreshDataSource();
}
public class CustomData
{
// Error in here
public int col1 { get; set; }
public string col2 { get; set; }
public string col3 { get; set; }
public int col4 { get; set; }
}
[/code]
|
|
|
|
|
Member 2458467 wrote: this.gridControl1.DataSource = this.lstCustomData.Where<customdata>(expr.Compile()).ToList();
Dot net framework 2.0 doesn't include all of the LINQ / lambda and expression tree functionality. This came in with dot net 3.0
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
You can't just convert it: C# 2008 was V3.0 of the .NET framework, and supported features that the previous version just didn't know about at all - such as Linq and Lambdas.
Since you code contains lambda expressions and Linq methods, you will have to rewrite that complete section without either.
What's the problem? You wrote the code, so you should understand exactly what it does. So producing an "earlier version" shouldn't be a major challenge for you.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
you say is true, It's using lambda expressions and LINQ which isn't supported in 2005 ... I was to learn write code how LINKQ and code no LINKQ but I do not know how to write without LINKQ (no LINKQ)
|
|
|
|
|
Member 2458467 wrote: do not know how to write without LINKQ
Sorry? You do - they certainly don't start any coding course with Linq / Lambdas! They start with the basics: loops and suchlike, then slowly build up to the more-complex-to-use code.
If you wrote the Linq stuff, you already know what to do to convert it back to "standard" code!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I have not written linkq, I am learn 2 type writing linkq and style of writing standards
|
|
|
|
|
Hello,
I am creating an application that allows to recover data in a database and display them in a datagridview .
Then I would like to insert the data recovered from the datagridview to another database that has the same structure .
Is what you have ideas to insert data into datagridview my new base.
Thank you for your help
|
|
|
|
|
Ibrahim.elh wrote: Is what you have ideas to insert data into datagridview my new base.
I'd recommend "insert" queries.
Saving data into a database is a fairly common task that is well documented. What have you tried and where did you get stuck?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I Have try this:
con_local = new OdbcConnection();
con_local.ConnectionString = lc.Connexion_locale;
con_local.Open();
for(int i=0; i< dataGridView1.Rows.Count-1;i++)
{
adap_local = new OdbcDataAdapter("insert into thisdet2 values(" + dataGridView1.Rows[i].Cells[1].Value + "," + dataGridView1.Rows[i].Cells[2].Value + "," + dataGridView1.Rows[i].Cells[3].Value + "," + dataGridView1.Rows[i].Cells[4].Value + "," + dataGridView1.Rows[i].Cells[5].Value + "," + dataGridView1.Rows[i].Cells[6].Value + "," + dataGridView1.Rows[i].Cells[7].Value + "," + dataGridView1.Rows[i].Cells[8].Value + "," + dataGridView1.Rows[i].Cells[9].Value + "," + dataGridView1.Rows[i].Cells[10].Value + "," + dataGridView1.Rows[i].Cells[11].Value + "," + +")"+",", con_local);
}
ds_local = new System.Data.DataSet();
adap_local.Fill(ds_local);
i have an error :
The exception was not handled System.ArgumentOutOfRangeException
HResult = -2146233086
Message = Index was out of range. It must not be negative and must be less than the size of the collection .
Parameter name: index
Source = mscorlib
ParamName index =
|
|
|
|
|
Your code is vulnerable to SQL Injection[^].
NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.
The ArgumentOutOfRangeException suggests that your rows don't contain 12 cells. (You're ignoring the first cell.) Did you actually mean to take the values from 11 cells, starting at index 0?
You're creating a new OdbcDataAdapter for each row in the grid, and then throwing away all but the last one.
You're specifying an INSERT command as the SelectCommand property of the data adapter.
Assuming you just want to insert the rows into the table, try something like this:
using (var connection = new OdbcConnection(lc.Connexion_locale))
using (var command = new OdbcCommand("insert into thisdet2 values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", connection))
{
var p0 = command.Parameters.Add("@p0", OdbcType.NVarChar);
var p1 = command.Parameters.Add("@p1", OdbcType.NVarChar);
var p2 = command.Parameters.Add("@p2", OdbcType.NVarChar);
var p3 = command.Parameters.Add("@p3", OdbcType.NVarChar);
var p4 = command.Parameters.Add("@p4", OdbcType.NVarChar);
var p5 = command.Parameters.Add("@p5", OdbcType.NVarChar);
var p6 = command.Parameters.Add("@p6", OdbcType.NVarChar);
var p7 = command.Parameters.Add("@p7", OdbcType.NVarChar);
var p8 = command.Parameters.Add("@p8", OdbcType.NVarChar);
var p9 = command.Parameters.Add("@p9", OdbcType.NVarChar);
var p10 = command.Parameters.Add("@p10", OdbcType.NVarChar);
var p11 = command.Parameters.Add("@p11", OdbcType.NVarChar);
connection.Open();
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
var row = dataGridView1.Rows[i];
p0.Value = row.Cells[0].Value;
p1.Value = row.Cells[1].Value;
p2.Value = row.Cells[2].Value;
p3.Value = row.Cells[3].Value;
p4.Value = row.Cells[4].Value;
p5.Value = row.Cells[5].Value;
p6.Value = row.Cells[6].Value;
p7.Value = row.Cells[7].Value;
p8.Value = row.Cells[8].Value;
p9.Value = row.Cells[9].Value;
p10.Value = row.Cells[10].Value;
p11.Value = row.Cells[11].Value;
command.ExecuteNonQuery();
}
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
modified 25-Feb-15 10:54am.
|
|
|
|
|
Thank you !
I tried your code but does not include visual studio .cells []
|
|
|
|
|
Ibrahim.elh wrote: does not include visual studio .cells []
Sorry, I don't understand that comment. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
