|
Either read the data in a OleDbDataReader or a OleDbDataAdapter. EG
string jetConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\tracker.mdb";
accessConn = new OleDbConnection(jetConn);
string query = "SELECT * FROM TABLE WHERE etc etc";
OleDbCommand myCommand = new OleDbCommand(query, accessConn);
OleDbDataReader myReader = myCommand.ExecuteReader();
while(myReader.Read())
{
string datain = myReader.GetString(0);
}
DataTable dt = new DataTable();
OleDbDataAdapter sda = new OleDbDataAdapter(query, accessConn);
sda.Fill(dt);
Hope this helps
|
|
|
|
|
Thank you
This method can work properly.
I'm amumu, and you?
|
|
|
|
|
Hello once again my fellow CPains!
I have one quick question I would like to ask, what would be the best way to determine the amount of items in an array which would allow me to store that amount into an integer?
|
|
|
|
|
brian1415 wrote:
my fellow CPains!
I don't think you will get an answer if you are that rude to the people.
brian1415 wrote:
what would be the best way to determine the amount of items in an array which would allow me to store that amount into an integer?
Now that is really confusing question
I have never wasted time worrying about such insignificant things. Keep your eye upon the donut and NOT upon the hole. - Bill Sergio about posting in the right forum. The Lounge - June 23, 2002
|
|
|
|
|
I am sorry that was a very foolish question and I promptly figured out how I would do it. Sorry for wasting you time.
|
|
|
|
|
So what was the question and what is the answer?
I have never wasted time worrying about such insignificant things. Keep your eye upon the donut and NOT upon the hole. - Bill Sergio about posting in the right forum. The Lounge - June 23, 2002
|
|
|
|
|
2 replies and not even a single attempt to answer the guy.
BAD DOG, DOWN BOY
depending if u have an array or a collection, the 'Length' or 'Count' property will have the answer u looking for.
|
|
|
|
|
Use the Length property of the array; all arrays are derived from the System.Array class; so that should be your reference for any array questions (such as dealing with multi-dimension arrays).
James
"Java is free - and worth every penny." - Christian Graus
|
|
|
|
|
Sorry everyone, What I was attempting to do was add items of an array to a listbox. My first thought was to use a for statement to add each item to the listbox and for that I would have needed the number of items in an array. After doing some looking I found listBox.Items.AddRange() which automaticly adds each item of the array to the listbox. Thank you for your reply Tom, and sorry Ricku for confusing you.
|
|
|
|
|
http://www.codeproject.com/cs/miscctrl/cutebutton.asp
I want to implement the angle variable for the control.
The angle variable is responsible for the shadow angle painted on the button.
The LinearGradientBrush requires a float as angle.
The property page of the control at design time expects a Single.
Thusly...
public int angle
{
get{return (int)m_angle;}
set{m_angle = (float)angle; Invalidate();}
}
...
Brush b = new System.Drawing.Drawing2D.LinearGradientBrush(ClientRectangle,
c1, c2, m_angle);
...
No effect. Changing the angle at design time will revert the angle back to it's original zero, instantly after loss of focus.
How would you implement the angle variable for this control?
Help please!!!
Coding is a family business
|
|
|
|
|
Hi
Orlanda Ramos wrote:
...
Brush b = new System.Drawing.Drawing2D.LinearGradientBrush(ClientRectangle,
c1, c2, m_angle);
...
Are u sure the above code is in your OnPaint method and you are drawing it?
And that it does not get overridden by another Draw method?
|
|
|
|
|
Hey guys I have a small problem.
I would like to do virtual pair programming (Some call it remote). But.. my connection is laggy and slow. This make remote desktop, terminal services, net meeting, and vnc, totaly useless.
I am looking for a visual studio addin that would do realtime source updates (Syncronize the source on two computer.)
Can anyone post a link to such an addin?
If not can someone show me how to develope such an addin?
Thanx
|
|
|
|
|
An unhandled exception of type 'System.OutOfMemoryException' occurred in system.drawing.dll
what the hell is wrong with this crap?
Ok ok, I can se that i'm out of memory but why.... i't now a heavy program, and I don't see any big changes in the memory state of my computer....
So what is going wrong?
And more importantly, how do I deal with it?
|
|
|
|
|
|
i get the same sh*t
i have a program running in the background/tray that does some connection-things each 5 minutes. each time something changes in the state of the program, some icons are changed. not much drawing i thought...
the memory error (and even stranger internal gdi+-errors) occur from time to time, when my program runs for a very long time (5 hours and more).
shutting it down and restarting it solves the "internal gdi+" errors - but that "out of mem-thing" crashed my win2k-machine so hard, it rebooted without me touching anything...
it seems there are problems with gdi+ and memory-usage - maybe the garbage-collector doesn't recognize unreferenced gdi+-objects or something like that - maybe it's my fault because i don't .Close() anything - but to be honest, i don't know what!
:wq
|
|
|
|
|
Make sure you call Dispose() on any Graphics objects you create. A great way to make sure of this is to use a using{} statement:
using(Control.CreateGraphics())
{
...
}
|
|
|
|
|
First of all thanks for your replies...
Well I found the source of my problem.
I just wasn't thinking strait....
It actullay din't have anything to do with the program running out of (free) memory, instead it the problem was, that (due to a programming error) it tried to read memory which I hadn't allocated....
|
|
|
|
|
which (kind of) functions actually create graphics objects?
any font/brush/rect created with new?
:wq
|
|
|
|
|
I'm not really sure waht you mean when you say graphics objects...
Of course a font and brush etc., are graphics objects, but they are (I think) only tools. The graphics object (the actual one, which does the drawing and stuff) can be obtained from the OnPaintArg's
Graphics gr = new e.graphics (though still i'm not sure, if this is all correct)
|
|
|
|
|
exactly my problem - i thought the garbage collection is doing things for me.
hmm. i will search my code for 'possible' real graphics objects i need to dispose...
:wq
|
|
|
|
|
I meet the same problem when I want to write a ownerdraw menuitem, I find the steps to cause "Out of memory":
1.Override the "OnDrawItem", you can write nothing but "base.OnDrawItem(e)" clause;
2.Set a break point at the clause;
3.Start to run with debug (F5);
4.When the program runs to the break point, just wait for a moment (1~3minutes)to go to next step;
5.Now you can try to open a desktop's popmenu by right-clicking mouse, maybe you will see nothing because the system has no memory to draw it, when you move mouse to the place you think the popmenu will display, the system will try to draw it.
The classic phenomenon of gdi resource insufficient now appears.
6.Try the above steps for several times, "Out of memory" will occur
But I have nothing to do in "OnDrawItem"!!!!!
I'm amumu, and you?
|
|
|
|
|
Greetings!!!
I was thinking, isn't it possible to change the coordinate system of the form, like in vb, so that (0,0) is in the bottom left corner???
|
|
|
|
|
I doubt it, but it would be a trivial thing to do on your own.
What do you want to do this for anyway?
Cheers,
Simon
"Every good work of software starts by scratching a developer's personal itch.", Eric S. Raymond
|
|
|
|
|
Sounds like your making a graph. Well, whatever it is, you could easily write a translation function. I don't know what the properties and function names are, but the following pseudo-code should give you the idea
Point TranslatePoint(Point p)
{
Point q;
q.x = p.x;
q.y = Window.Height - p.y;
return q;
}
|
|
|
|
|
Look at Graphics.Transform property. This will help you specify a tranformation matrix that you can use.
I have never wasted time worrying about such insignificant things. Keep your eye upon the donut and NOT upon the hole. - Bill Sergio about posting in the right forum. The Lounge - June 23, 2002
|
|
|
|