|
Hi,
I'm developing an application which requires storing a list of MemberID numbers selected from a checkedlistbox into an Access db.
There could potentially be say 100 numbers (or more) in the db that I will need to extract, get their related names and display the names in a listbox.
Short of creating rows for each MemberID, I am thinking of one row with the MemberID values seperated by a space, comma or similar.
Can someone share their experiences with this design and make suggestions as to any better alternatives.
Thanks,
Glen Harvy
|
|
|
|
|
Hello
Modern Dbs are usually Relational in design. Your MemberID must have a relation to something else -Member Name, Group, etc...-, so putting them in one row won't make you able to get these relations. Putting them in cells each in a row all in a table -as long as there are other cells in each row-, won't makea downgrade would it?? If you are storing only numbers in a row, why not using an array rather than a DataTable??
Regards ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
Don't store the values in a single field. You lose the entire advantage of having a database at all.
If you store each id in a separate record, you can join the tables when you fetch the data, so that you can fetch all the names with a single query. If you store all the id:s in a single field, you first have to get the id:s, then you have to make a query to fetch the name for every id. That means that you have to run 101 queries against the database instead of a single one, and it gets worse the more id:s you have.
---
b { font-weight: normal; }
|
|
|
|
|
Does anyone have an ico or png or whatever of the exit icon (the white x on red background) that is in almost every computer program! I can't find one anywhere!
Glen Harvy
|
|
|
|
|
You could press print screen and make one, I was looking for some Icon software today and found icofx quite good, or try this code 
<br />
using(Bitmap bmp = new Bitmap(16,16))<br />
{<br />
using(Graphics g = Graphics.FromImage(bmp))<br />
{<br />
VisualStyleRenderer r = new VisualStyleRenderer(VisualStyleElement.Window.CloseButton.Normal);<br />
r.DrawBackground(g,new Rectangle(0,0,16,16));<br />
bmp.Save("close.png",ImageFormat.Png);<br />
}<br />
}<br />
|
|
|
|
|
Thanks,
Your code worked like a charm.
I'll check the icofx site out as well later.
Cheers,
Glen Harvy
|
|
|
|
|
I havn't had a lot of time to test anything so maybe the awnser is simple. How can i move a file to attach it to an ADS. I wan't to hide all the files in a directory behind a 0 text file.
for ex.
Move c:\myVidio\movie.avi to C:\myVidio\haha.txt:movie.avi
Move c:\myVidio\movie2.avi to C:\myVidio\haha.txt:movie2.avi
I'm looking to write a utility that can take directories and do this.
Ronald Hahn, CNT - Computer Engineering Technologist
New Technologies Analyst
HahnTech Affiliated With Code Constructors
Edmonton, Alberta, Canada
Email: rhahn82@telus.net
|
|
|
|
|
I am to remove the caption bar from a C# form (VS2005). I've set control box to false and removed the Text Field. The caption is gone but the problem is I can't put i title in the Taskbar. Does anyone know how to do this?
|
|
|
|
|
Set the 'ControlBox' property to false,
Set the 'FormBorderStyle' property to None and
Set the title in 'Text' property.
Regards,
Bhupi Bhai.
|
|
|
|
|
The problem with that is the form is then not resizable, in my current task I need it to be resizable, do you know how to get past this?
Regards,
Chris McGrath
|
|
|
|
|
i have a folder in my documents named skins i want to read the all files name in this folder how can do it
fatma
|
|
|
|
|
Take a look at the Directory and DirectoryInfo class.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
string[] files=Directory.GetFiles(skinsFolder);
As a note, you will have the full path. If you only want the file name, just get a substring of the last index of '\'.
Aaron
|
|
|
|
|
as Aaron said,
assign the retrived file array to a fileinfo object and use the properties to get the filename or extension.
FileInfo fileinfo = new FileInfo(files[0]);
long sFileSize = fileinfo.Length;(gives u the file size)
fileinfo.Directory etc.......
|
|
|
|
|
I'm working to an aplication that uses a database of 7000 records (MS Acccess database). When I load my aplication, it takes a lot of time (to much anyway).I think that I can load my database faster, but I don't know how.Can someone help me? Thank you.
|
|
|
|
|
Nicostancila wrote: Can someone help me?
It's almost impossible without knowing what you're doing currently. So provide the code of question or at least some more details what you're doing when you load your application.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
Access isn't the best database for a lot of things. It is hard to answer without knowing exactly what you are trying to do, but some suggestions....
If you have a 2 tier application where multiple users connect to the database, Access does not support connection pooling, so you have a lot of connections open to the same database/table. This will slow down Access quite a bit.
If the relationships in the database are complex and you are (or are not in some circumstances) forcing the restraints/relations to be upheld in the program, that will drain Access.
Are you filling a datatable with a dataadapter? If so, how many times are you doing it? (Check to make sure your sequence of events doesnt load the data twice). If using commands and a datatable, set BeginLoadData=true before reading the data to the datatable, and =false when done. This temporarily keeps restraints from being enforced.
If none of that helps, more info is needed.
Aaron
|
|
|
|
|
Hi Aaron,
So, which kind of database do you recommmend for applications that require several connections at the same time? For example, a server containing just one database and multiple clients loading from it.
Thanks
Kurtz
|
|
|
|
|
try loading your data selectively. or filter only the data that you need.  ![Badger | [badger,badger,badger,badger...]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/badger.gif)
|
|
|
|
|
i have image file on hard disk (jpg,gif or png)
i want to insert this image file as binary in field in database
this field has varbinary data type
and when i select this field i show the binary data in picturebox
please help me
thanks
MD_NADA
|
|
|
|
|
Hello
1- Write your image so a stream of bytes using Image.Save(Stream, ImageFormat) method.
2- Write that array of bytes to your database.
3- When reading the image from the file reverse the process and use Image.FromStream(Stream) to read the stream into the image object.
4- Use the PictureBox.Image property to display your image.
Regards ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
This question has been asked and answered many, many times. I suggest you search the forum.
|
|
|
|
|
Hi,
I have a web site with:
A MasterPageDefault and
Page1 and Page2, which both referes to MasterPageDefault.
On MasterPageDefault I have put a delete button. Now in the codebehind file, I want to delete two diferent things which depends on what page I stand on. Therefore I need to know, which page I stand on.
Is there anyone, who can help me, to find some code, which kan determe on which page I stand on?
Kind regards,
simsen
|
|
|
|
|
What framework variable do I use to access the path to My Documents?
|
|
|
|
|
My Documents is a "special folder" and is accessed using the Shell. So however the framework exposes the Shell that is how you get the solution.
"Alot of the people on this forum are incredibly stupid, thinking that the internet is real"
Score: 1.0 in the Soap Box
led mike
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
