|
i'm using vb.net, and i need to know how to get the names of all the fields(columns), a mdb table contains, and display them in a listbox.
hope someone can help....
|
|
|
|
|
while this is a C# forum so your lucky to get a reply...
if you are using OleDbConnection and OleDbDataReader you can run a select all query ("SELECT * FROM table1") and then loop each field in the reader and call the GetName method of the reader by speciying the field index. example...
string[] columns = new string[reader.FieldCount];
for(int i = 0; i < reader.FieldCount; i++)
{
columns[i] = reader.GetName(i);
}
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Hi all,
Sorry if this is not the right place to post.
Can you please let me know how to change the following XML so that i have HOME and SERVICES as parent node.At the moment HOME Contains SERVICES as a Sub Node.
What i want is When i click on Home the Service Link shouldnt be hidden.
<?xml version="1.0" encoding="utf-8" ?>
<siteMap>
<siteMapNode title="Home" >
<siteMapNode title="Services" >
<siteMapNode title="Training" url="~/Training.aspx"/>
</siteMapNode>
</siteMapNode>
</siteMap>
Thank you In advance.
|
|
|
|
|
surely...
<?xml version="1.0" encoding="utf-8" ?>
<siteMap>
<siteMapNode title="Home" >
<siteMapNode title="Training" url="~/Training.aspx"/>
</siteMapNode>
<siteMapNode title="Services" >
</siteMapNode>
</siteMap>
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Many thanks for your reply.Its Much appreciated.
I have tried it before and got an error saying:
Exactly one <siteMapNode> element is required directly inside the <siteMap> element.
Could you please advice?
thanks
|
|
|
|
|
What gave you the error? This works fine for me:
<?xml version="1.0" encoding="utf-8" ?>
<siteMap>
<siteMapNode title="Home" />
<siteMapNode title="Services" >
<siteMapNode title="Training" url="~/Training.aspx"/>
</siteMapNode>
</siteMap>
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia) Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Thank you once again.
<siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
<siteMapNode title="SMS_PUSH" url="~/secured/main.aspx">
<siteMapNode title="Total Message By Month" url="~/main.aspx" />
<siteMapNode title="Postive Respondant By day" url="~/Messagetracker.aspx" />
<siteMapNode title="AUTOMATED_ADULT_SMS" url="~/autosmspush.aspx" />
</siteMapNode>
<siteMapNode title="SMS_PRS" url="~/main1.aspx">
<siteMapNode title="AUTOMATED_SMS_PRS" url="~/autoSmspush_PRS.aspx" />
<siteMapNode title="EDIT_PRSMESSAGE" url="~/editPRSmessage.aspx" />
</siteMapNode>
<siteMapNode title="SMS_ORANGE" url="~/main2.aspx">
<siteMapNode title="AUTOMATED_SMS_ORANGE" url="~/autosmsPush_orange.aspx" />
<siteMapNode title="EDIT_ORANGEMESSAGE" url="~/editOrangemessage.aspx" />
</siteMapNode>
<siteMapNode title="SMS_IRISH" url="~/main3.aspx">
<siteMapNode title="AUTOMATED_SMS_IRISH" url="~/autosmsPush_Irish.aspx" />
<siteMapNode title="EDIT_IrishMESSAGE" url="~/editIrishmessage.aspx" />
</siteMapNode>
<siteMapNode title="ALL_Message" url="~/main4.aspx">
<siteMapNode title="ALL_PRS_Message" url="~/allPRSmessage.aspx" />
<siteMapNode title="ALL_Orange_Message" url="~/allOrangeMessage.aspx" />
<siteMapNode title="ALL_Irish_Message" url="~/alladultMessage1.aspx" />
<siteMapNode title="Insert To Stop" url="~/DeliveryReceipts.aspx" />
</siteMapNode>
</siteMap>
|
|
|
|
|
Any Luck?
Thank you for your time.
|
|
|
|
|
Hi Dave,
Are you there?
Many thanks
|
|
|
|
|
Hi There,
Can any one give an answer to my query?
Thanks
|
|
|
|
|
Hi,
I've installed one version of software written in C# at my client place some time back, not i want to upgrade it into next version. What is the best way to upgrade software with out uninstalling the existing version may be kind of patch.
please advise me.
Thanks
|
|
|
|
|
Look at the RemovePreviousVersions flag in msi properties: here[^] a guide.
|
|
|
|
|
|
I am still facing a problem of Tab Form.
I have Tab form of two pages i want to blink cursor / focus of cursor in first text box of first page of tab form.
(Cursor should blink user can use it on load form)
I try some code but not archive target and trying still beside other tasks.
Tell me what should i do for ........
|
|
|
|
|
have you tried setting the focus of the control you want in the load event of the form?
or simply set you tab indexes correctly and it should automatically be the first control that gets focus
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
-> You can easily set the TabIndex property of Textbox to 0 for focusing.
-> At Form OnLoad event, set textbox.focus().
|
|
|
|
|
I am asking about Tab for not for only the text box on simple form.
|
|
|
|
|
tabControl1.SelectedIndex = 0;
textBox.Focus();
|
|
|
|
|
Hi All,
I have a question that I can't answer, I hope you guys will help me =)
I have a program in which user selects a source directory and a target directory and the files in the source directory are processed and copied into the target directory. All is fine until this:
I created directories manually (for test purposes), I mean not inside the code but Right Click-->New-->New Folder =)
When the process is done, files are OK. This means they can be deleted, moved, renamed. But the directories stay locked. I cannot rename, move, delete the directories.
So, why does this happen and how can I correct it?
Thanks
Edit: Oh, by the way I forgot to mention I used DirectoryInfo and FileInfo.
|
|
|
|
|
If you want the solution, post the code for your project here.
|
|
|
|
|
Well, I guess you're right. My bad, my bad.
DirectoryInfo dir = new DirectoryInfo(srcDirectory);
foreach (FileInfo fil in dir.GetFiles("*.jpg"))
{
imagesJPEG.Add(Bitmap.FromFile(fil.FullName));
fileNames.Add(fil.Name);
imageCount++;
}
foreach (FileInfo fil in dir.GetFiles("*.tiff"))
{
imagesTIFF.Add(Bitmap.FromFile(fil.FullName));
fileNames.Add(fil.Name);
imageCount++;
}
foreach (FileInfo fil in dir.GetFiles("*.png"))
{
imagesPNG.Add(Bitmap.FromFile(fil.FullName));
fileNames.Add(fil.Name);
imageCount++;
}
This is the only code which has direct access to directories. All other functions just use a string for the destination folder and doesn't have anything to do with folders =)
|
|
|
|
|
If you are working with images, don't forget to dispose them. Otherwise they will stay locked.
|
|
|
|
|
Thanks for the reply
They are disposed right after they are processed but I will take a look at that just to make sure.
But, as I said, files which are copied into the target directory are not locked. Only the target directory stays locked.
|
|
|
|
|
Hi,
use Image.FromStream() instead of Image.FromFile(); that way they don't get locked at all.
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets
|
|
|
|
|
So, you say this can keep only the folder locked, while the files created are not.
I'll give it a try and let you know.
Thanks =)
|
|
|
|