|
You really should consider not using an ArrayList to temporarily hold the values just to display them later. If you're going to do that, use a DataAdapter instead to fill a DataSet, which is basically a list of tables which contain a list of rows which a lot more information than what you're storing. The beauty of a DataReader is, though, fast forward-only access to data. The best approach is to enumerate the data as you read it, not store it and read it later.
Also, DO NOT construct SQL expressions using string concatenation. I grow tired of saying this but will again because is one of the most common ways to get hacked. All I need to do is pass "Table1; DELETE FROM Table1; --" (where Table1 is some table I can select) and your data is gone. Got customer information? I could select it and you get sued for privacy violations.
Construct SQL expressions using the IDbCommand implementations, like SqlCommand for SQL Server and OleDbCommand for OLE DB connections including Access. There's others as well. This also encodes values for you. See the SqlParameter class and SqlCommand.Parameters property documentation in the .NET Framework SDK for more details.
To answer your question, though, you need to loops because you're adding an ArrayList to an ArrayList:
foreach (ArrayList list in array)
{
foreach (object obj in arr)
Console.Write("{0}, ", obj);
Console.WriteLine();
}Again, though, if you must store the data use a DataSet, which allows you to define tables, columns, store tracking information to later update the database is necessary, easily bind it to controls (even using the designer to easily bind them to controls like the DataGrid) and more.
Be sure to read Accessing Data with ADO.NET[^] for more information.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Could u show me how to use SqlParameter
|
|
|
|
|
Read the documentation[^] for the SqlParameter class, as well as the documentation[^] for the SqlCommand.Parameters property as I said in my first reply.
The documentation is there to help you learn. Forums like this exist to help explain what you don't understand or help in cases where the solution isn't so obvious unlike your problem.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
I have an array of doubles that I wish to pass to a method declared in a COM ActiveX control. The documentation for the ActiveX control says the method is declared as:
<br />
AddParametricCPP(BSTR Name, double Start, double Step, double* Y, long Size)<br />
where Y is the parameter I'm having issues with, and is documented as:
"Pointer to an array of doubles, holding the y-values of the curve."
When the VS.NET IDE imported this OCX it declared the method signature as:
<br />
AddParametricCpp ( System.String Name , System.Double Start , System.Double Step , System.Double Y , System.Int32 Size )<br />
where Y is a reference parameter.
What is the proper method of passing an array of doubles to this method through the Y parameter? I have tried all sorts of different things, but I keep getting a nullreferenceexception. I am sure the other parameters are correct so it must be in the way I am passing the array. Any suggestions on the proper way to accomplish this task?
|
|
|
|
|
There should be an out or ref for parameter Y. Please provide the exact signature if you haven't.
If there is no such keyword, then you'll have to declare that interface yourself, making sure to attribute the interface with the correct GuidAttribute value and the appropriate InterfaceTypeAttribute, as well as declaring the methods in the correct order for IUnknown and dual interfaces, or the correct DispIdAttribute values for IDispatch or dual interfaces. If you must define the method yourself, then declare it as double[]. Also add MarshalAs(UnmanagedType.LPArray) to the parameter declaration to marshal it as a pointer to a double, setting the MarshalAsAttribute.SizeParamIndex to 4 to indicate that the Size parameter contains the number of elements for the native array (since native code knows no bounds for native arrays).
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Hi every one ..
i use C#.NET 2003 , I developed program which contains reports generated with crystal report 9.0 ..
when i run that program after .Net framework 1.1 setup on any other machine , reports generate an exception say
"Missing or invalid Keycodev2.dll", but i verified that file and find it on "Crystal Decision Folder"
.. If Any Can Find a solution to that problem please contact me on
shadyaly2003@gmail.com or
shadyaly2003@yahoo.com
thank you .....
|
|
|
|
|
Read Deploying Crystal Reports in .NET Applications[^]. It contains important information about required steps to package and distrubute Crystal Reports for .NET, like including the Crystal_regwiz2003.msm merge module and setting the LicenseKey property from the PropertyGrid. This key is the key you registered when first using Crystal Reports on your developer box. You can also get it from the About->Help dialog.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Hi,
I'm just exploring socked programming. I've written a small app that will load the headers of newsgroup messages and am struggling to get decent performance. I've stripped everything down so that the code simlpy readlns each response from the server and I've used a profiler demo and it would seem to indicate that a lot of the time of the code is spend in OSSOCK::recv, understandably. What I cannot work out is why it is taking so long. The connection to the server is fast enough and running other apps (e.g. newsreaders) confirms that it should not be taking so long. What can be done to improve the writer.WriteLine, Flush, readline() cycle
As an indication, the app will connect to a newsserver, download the headers for the last 100 messages. This takes over 20 seconds of which is way over the top.
Any pointers greatly appreciated.
Cheers,
Ian
|
|
|
|
|
Hey
I am developing a Server - Client.
Im using Async connection
and using
AsyncCallback recieveData = new AsyncCallback(OnRecievedData);
server.BeginReceive(m_byBuffer,0,0,SocketFlags.None,recieveData, server);
the size of mbyBuffer is 256.
But i am not realy using it, instead i am using
ForumPack.Command cmd = (ForumPack.Command)formatter.Deserialize(NStream);
to deserialize the command obje and a diffren one to deserialize the ombject that is comming after the command obj.
This is working fine, but when i disconnect and the connect again i get the error on
server.BeginReceive(m_byBuffer,0,0,SocketFlags.None,recieveData, server);
Connection lost becourse keeping-alive activity have notice an error.
What could be the error ?
When i am reconnecting i am setting connection object to null, and then i set it to a new object. Maby i have to clean up the old connection object better ?
//SnowJim
|
|
|
|
|
How to edit a data in Listview. It's Like click in column on listview and it can type and change data inside.
|
|
|
|
|
Use ListViewItem.BeginEdit. This only works if ListView.LabelEdit is true. The default value is false, so you'll need to set it. Using the ListView control defined in the BCL (base class library) you cannot edit other columns. If you search for "List View" on this site for the .NET and C# categories you should find several articles that describe how you can accomplish that.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Hi,
I'm laying out the ideas for my complete revamp of the Quake 3 AI system, and to get there i need to test out pathfinding algorithms... and to get there i need to improve my programming.
Since i'm pretty new to all this, can someone please point me in the right direction?
This is want i want to be able to do:
Draw a basic 2d "map" that i can chuck all the results from the pathfinding simulation on.
The map includes:
--> Starting and ending point
--> waypoints
--> numbers, colors etc
--> basic lines, pictures
I take it those are just diffrent objects? i'm not quite sure how the objects work either...
Thanks in advance...
Serrix
The Multidisoctinal Metalobilist...
... Those are random words... don't google em 
|
|
|
|
|
You can start by reading the documentation[^] for the Graphics class, as well as Drawing and Editing Images[^] in the .NET Framework SDK. There are also many, many articles about owner-drawn controls (like drawing charts on a control).
A good design would be object-oriented, where your objects draw themselves (using the PaintEventArgs.Graphics object passed to their container's OnPaint override), contain connection points, etc.
The best place to start for such a task is to search this site using the text box at the top of every page below the logo, and click "Search comments" directly above this message board to search this forum. We've discussed many times a good OO design for drawing.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Cool, thanks alot i'll do that...
hehe, it was kinda a newb question.
Serrix
The Multidisoctinal Metalobilist...
|
|
|
|
|
I have the name of a form in a string variable.
I want to load the form my making use of this variable.
kevin
|
|
|
|
|
I have a similar problem in the sense that i have a menu which i have created
Once i click a menu item i want to open another windows form.
suggest a way to do that plss!!
Sukanya
|
|
|
|
|
Try to create an EventHandler by doubleclick the menuItem.
private void miFile_Click(object sender, System.EventArgs e)
{
Form1 frm = new Form1();
frm.Show();
}
|
|
|
|
|
thnx a lot 
Sukanya
|
|
|
|
|
Hi
Does anyone knows how to send a hot key to a Computer on the network?
I think I have to approach the keyboard. But how?
I've read something about keyboard Hooks.. But I don't know wether it's what I'm searching for..
Regards from Germany
|
|
|
|
|
You can't hook a remote keyboard. You can send commands to a remote service on that machine to send keyboard events (you don't want to hook them to send keyboard events, only to handle them - and you cannot handle Ctrl+Alt+Delete).
For managed apps you can use the SendKeys class, but it's rather limited. For cases that you can't solve with SendKeys P/Invoke SendInput and create what native structs and constants you need.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Hi all, I am a c# programmer, have a problem nagging me... i was working with my vs.net fine till last day .. but all of a sudden when i try to open a new project in visual c#, i am getting a message "operation could not be completed".. i think im experiencing this only when i try opening new c# projects and project is creating for vd.net applications...i am trying to solve it out.. if anyone familiar with this could you help me out of this nightmare...
Regds
Robins
thomasrobins
|
|
|
|
|
Maybe you're lacking some necessary file system rights.
Once I've got a similar message whenever I tried to create a new code file. It even happens when I tried to create the file on my data partition where all users have write rights. It turned up that Visual Studio wanted to create the file on my c: partition first (my user had no write or change rights there) and then move it to the specified location.
To find out, if you maybe have a similar problem, you can use the freeware tool FileMon[^].
www.troschuetz.de
|
|
|
|
|
I figured it out, i was actually being really silly. Thought I would post here in case somebody else was having the same problem and looks in the archives.
Anyways, when you receive the object from the MSG it is not said in the XML what type of class it is. You need to specify this explicitly before you cast the object back to whatever type you want. ^^
Hope this helps some person in the days of yore,
Jim
|
|
|
|
|
Hallo,
I create objects of the same! class in two ways:
1) by .Net Remoting
2) in the usual way (without .Net Remoting)
I want to find out (in the class itself), if the object was created remotely by a foreign host?
Does anybody have an idea?
Thanks,
Björn
|
|
|
|
|
Will
if(obj is RealProxy) do the trick?
(Not tested, just a theory.)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
