|
Dear all,
I'm just starting out in .NET and creating a simple application to store the personel information on staff, e.g. name, address, age etc etc.
My question is which would be the best storage for this type of information. I'm considering XML or a database. The application will be run on a single machine so it just needs to be something simple. It would be nice to be able to load the information into Excel too...
Any pointers would be a real help so I start down the right path.
Many thanks
Tom
|
|
|
|
|
I found SQLite to be a very good and simple storage media for small databases.
There's a ready-to-use DLL provided by Mono, but it also works fine with normal .NET applications
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Thats great, thanks for the pointer...
|
|
|
|
|
i have a problem with the old projects , they are do not open in my new installation of visual studio.net IDE. How do i open that old project in newly;P installed IDE and debug.
thanks............
|
|
|
|
|
File/Open?? Just opening the solution or porject file should launch the conversion wizard which will upgrade the project files to the current version supported by the IDE, IF the conversion is supported.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I'm looking to do something seemingly obvious:
Hashtable h = new Hashtable();
foreach ( key in h.Keys )
h[key] = //something;
but I take it the assignment h[key] kills the enumerator of the foreach. Is there an elegant way to implement the intent of the above code?
Thx.
|
|
|
|
|
You can't change the key of a node in a hash table, as the entire table is arranged according to the hash codes of the keys. You have to remove the node from the table and re-add the object in the node using the new key.
---
b { font-weight: normal; }
|
|
|
|
|
okay, but my intent is not to change the key. I'm trying to express
H[key] = //something;
That is, I'm setting my DictionaryEntry value to //something. Is there a way to use the foreach statement and assign values to existing DictionaryEntry's ?
|
|
|
|
|
Once a hashtable record is created, you don't want to change the key. Changing the value is fine though. Sometimes whan I need a quick and easy list of objects, I'll create a hashtable and just use hash.count as the key. Here is an example of how you could deal with changing values from a hashtable:
Hashtable hash = new Hashtable() ;
for (int i = 0; i <=10; i++)
{
hash.Add(i,"something") ;
}
//we now have 11 objects in the hashtable
int counter = 0 ;
//we do this, because hashtables don't guarantee that you'll
//get object out in the same order you put them in
for (int i = 0; i <= 10; i ++)
{
hash[i] = "new object" ;
//this will modify the VALUE, not the KEY
}
//if you don't care about the order you're getting objects out of the hashtable
//you can enumerate them like this:
IDictionaryEnumerator enumr = hash.GetEnumerator() ;
while (enumr.MoveNext())
{
object theKey = enumr.Key ;
object theValue = enumr.Value ;
//you could change the value here
enumr.Value = "new value" ;
}
-- modified at 9:35 Friday 21st April, 2006
|
|
|
|
|
The obvious: make a clone of the keys:
ArrayList keys = new ArrayList(h.Keys);
foreach (Key key in keys) {
h[key] = bla;
}
Wout
|
|
|
|
|
okay, so I have* to make a copy of the keys to use the foreach when assigning values to existing DE's. Thanks.
|
|
|
|
|
Just as some further info: Whenever you loop over some sort of collection with foreach you are not allowed to change it within the loop. That's no speciality of the HashTable class but affects about all collection classes.
|
|
|
|
|
I encode picture by binary byte and put it into database,now i want to get it back and put it into Grid(i use Xtragrid). I decoded it into Picture, but i dont know how to show it into grid
Please help me
Thanhs a lot.
superdragon
|
|
|
|
|
|
Hello,
is there any way using WMI on how to copy files from local computer to the remote computer on the specified path/location[C#] ?
thank you in advance
|
|
|
|
|
Sure, Win32_Directory[^]. But why would you want to??? This is kind of the Rube Goldberg method of copying files. It has limited functionality, such as it won't over-write the destination file if it already exists.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
we are using microsoft Office 9.0 Library & COM namespace is OWC
TextBox1.Text = xlsheet.ActiveSheet.Cells[i,1];
While writting this code it is not converting to object to string but in reverse case it is working properly uploading to spreadsheet.
//This is the Error
Error: Cannot convert Object to String
So pls convey this & let me know the solution for the above problem.
I m using asp.net with c# coding.
Thanking u,
Naren.
please help me
|
|
|
|
|
Try this:
TextBox1.Text = (string) xlsheet.ActiveSheet.Cells[i,1];
Best regards, Alexey.
|
|
|
|
|
TextBox1.Text = xlsheet.ActiveSheet.Cells[i,1].ToString();
Every object in .NET has a .ToString() method
-- modified at 7:45 Friday 21st April, 2006
|
|
|
|
|
Hi
Thanks for sending Reply.
TextBox1.Text = xlsheet.ActiveSheet.Cells[i,1].ToString();
& also
TextBox1.Text = (string)xlsheet.ActiveSheet.Cells[i,1];
But i used this, its not working.
Pls give any idea.
Once again Thanking u,
Naren
please help me
|
|
|
|
|
All solutions are incorrect.
Correct code:
<br />
Excel.Range cell = (Excel.Range)m_workSheet.Cells[x + 2, y + 1];<br />
string st = cell.Text.ToString();<br />
Best regards, Alexey.
|
|
|
|
|
Hi Alexey
Thanks a lot for immediate reply.
Its giving an exception as "Specified Cast is not valid".
Now i m getting this problem.
Thanking u,
Naren
please help me
|
|
|
|
|
I hardly ever do Office Interop, but the Cell[,] returns a Cell, which has, IIRC, a Value property, soooo...
TextBox1.Text = xlsheet.ActiveSheet.Cells[i,1].Value.ToString();
might be what you're looking for, or something very close to it.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hello all,
Does anyone know of any way of calling functions in a VB6 exe, from code in C#? Is this even possble? I don't know much (if anything!) about VB6 so I'm a bit confused. I've managed to call functions in a VB6 dll, but is the same thing possible with exe's too?
As always, any help at all would be greatly appreciated!
Thanks
Shehzad
|
|
|
|
|
Nope. VB6 .EXE's don't support export functions, so you there's really nothing to call. .DLL's on the other hand, you've already found out.
The only exception to this would be if the VB6 .EXE is an ActiveX Server, which has all kinds of exports, just like any other COM-based assembly. Just add a COM reference to your .EXE and you're just about all set.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
