|
I am checking whether a column can allow null values or not. In my sql table i have disallowed null values and when i am checking it by using
Debug.WriteLine(ds.Tables(0).Columns(0).AllowDBNull)
it is showing true and same for other columns whether null is allowed or not. how can i check whether a column allows null values or not
|
|
|
|
|
I make a form in vb.net. I set its window state property to "Maximized". Means my form will open in "FULL SCREEN".
I also set property "Form Border style " to fixed, so that my form cannot be moved or resized.
But after applying properties, my form still be resized and movable. How can i restrict my form, so that it cannot be moved or resized.
Kindly reply me soon
Eshban
EsHbAn BaHaDuR
EsHbAn BaHaDuR
|
|
|
|
|
Set the border style to FixedDialog.
|
|
|
|
|
If you set the FormBorderStyle to FixedSingle the form cannot be resized.
There is no property to set the movable state of the Form. Not in VB.Net, only on VB6.
|
|
|
|
|
Fixed single prevents resizing but it does not enforce the maximized form state which is the objective as I understand the post. You could disable the maximize button. In which case you might as well use FixedDialog.
|
|
|
|
|
but it does not enforce the maximized form state which is the objective
Doesn't enforce? What do you mean by that?
You can set the WindowState Property to Maximied and the form will start maximized on FormBorderStyle = Fixed Single or on FixedDialog.
|
|
|
|
|
Start a form up with FixedSingle, Window State maximized. Then click the Maximize button in the form's control box. You'll figure it out. 
|
|
|
|
|
hi.. i've used outlook automation to extract e-mails from our exchange server.. my problem is i can't think of any control that can hold the e-mails.. when i use a listbox, it takes like 10 mins to download the contents of my e-mail.. what control can u suggest so it will load faster? thanks..
here's my code:
Dim ol As Outlook.Application
Dim olns As Outlook.NameSpace
Dim myRecipient, myfolder, numitems, myitems
Dim i As Integer
ol = New Outlook.Application
olns = ol.GetNamespace("MAPI")
myRecipient = olns.CreateRecipient("ITMC L2 DSS-ALERT HUB")
myRecipient.Resolve()
myfolder = olns.GetSharedDefaultFolder _
(myRecipient, Outlook.OlDefaultFolders.olFolderInbox)
MsgBox("You have " & myfolder.items.count & " message", vbInformation)
numitems = myfolder.Items.Count
myitems = myfolder.Items
For i = 1 To numitems
ListBox1.Items.Add(myitems(i).subject)
Next
|
|
|
|
|
This doesn't answer your question, but check Outlook Redemption[^] [www.dimastr.com] if you're working with Outlook.
I used this to remove those annoying warning dialog when accessing user data.
Edbert
|
|
|
|
|
That depends on what part of the code is taking so long and how many items your adding to the ListBox.
If it's the part that's adding items to the ListBox, I noticed that you'r not preventing the control from redrawing itself every time you add an item to the control. You might want to scrap iterating through the items yourself and just use the .AddRange(Object()) method of the Items property.
I think something like this should work:
ListBox1.DisplayMember = "Subject"
ListBox1.Items.AddRange( myItems )
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi, recently I had a problem with the IDE environment of VB.Net. I was using VB.net to design forms and it was working a few days ago. But yesterday, when I double click on a VB form, I got the following message box appearing:
There is no editor available for 'c:\projects\form1.vb'. Make sure the application for the file type (.vb) is installed"
What is wrong. I tried uninstalling VB.Net and reinstalling it and even tried to use the Repair function to repair but this message still comes out. The project files can be viewed in other VS.Net machines, so I do not think its a problem with the project files.
Please provide me a solution. I do not want to reinstall Windows XP professional just because of this.
Thanks.
|
|
|
|
|
dinoang wrote:
Please provide me a solution.
Why don't you start searching the web for yourself? Start digging here[^]. Only you can supply any missing details to troubleshoot the problem.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Can you open VB.NET IDE first and open the file from there? If so, then look under "file association" in XP Help and it will tell you how to associate the file with the IDE.
|
|
|
|
|
Hello
I am using a Active X that can only run in an Windows.Form(The Active X is a map engine), but i want to use it in my web application. Is there any way I can "implement" an instance off the form project in my Web project?
If this is not possible I was thinking of using a PictureBox to view the picture, but found out that this is also a form property. Is there any way I can use a system.form.picturebox or system.form.label in a web project...?
Spaz
|
|
|
|
|
Spaz80 wrote:
Is there any way I can "implement" an instance off the form project in my Web project?
No.
Spaz80 wrote:
If this is not possible I was thinking of using a PictureBox to view the picture, but found out that this is also a form property. Is there any way I can use a system.form.picturebox or system.form.label in a web project...?
You can add an image to a web form. Just save it to disc with a unique name and then generate an IMG tag.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
Most ActiveX controls do not really care, and usually do not even know that much about the container they are hosted in.
A few special types called "windowless" controls require the container to draw the control, rather than the control to draw itself.
I seriously doubt your control fits in that category.
If your control can only be hosted in a Windows form, my guess would be that it has code in it that checks to see what kind of container it's host is, and disables itself if the container is Internet Explorer. In that case it is for licensing purposes. I would check the license agreement that came with your control. It probably specifies that the control is NOT licensed for web use. In the past I've seen map controls that were licensed only for application use and not for web use.
Robert
|
|
|
|
|
Well i'll try this again;
I have created an array containing 7 randomly generated numbers. I want these numbers to be mutually exclusive i.e. same value only occur once.
I have tried to in VB.net programming develop a set of nested if..then statements to test each drawn number against each element in the array.
This process is fraught with difficulty and more often than not does not guarantee a list of exclusive numbers and duplicates do occur. Plus it takes 50 lines of code. Resource intensive!
Is there a more efficient code in VB.net that will validate the content of my array and ensure it is mutually exclusive.
Thank you for the help so far
J.Gallagher
Western Connect
J.Gallagher
Western Connect
|
|
|
|
|
Use a collection instead of an array. Collection keys are required to be unique.
Generate random numbers in a loop until the collection count = 7.
Add the items to the collection using the number.ToString as the key and trap the error that occurs if the item already exists and ignore it and continue the loop.
i.e.
Do While colNumbers.Count < 7
intNew = GetYourRandomNumber()
Try
colNumbers.Add(intNew, intNew.ToString)
Catch
End Try
Loop
Crude but simple.
Robert
|
|
|
|
|
Damn... beat me to it...
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
Jörgen Sigvardsson wrote:
If the physicists find a universal theory describing the laws of universe, I'm sure the a**hole constant will be an integral part of that theory.
My Blog[^]
|
|
|
|
|
Just to keep it easy...
- Run a while loop that tracks the number of entries in a hashtable. Stop looping when you have 7 entries in thre hashtable
- Create a random number.
- Try to add that number to the hashtable as a key.
- If the key you add already has an entry then you catch the exception and go back for another number.
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
Jörgen Sigvardsson wrote:
If the physicists find a universal theory describing the laws of universe, I'm sure the a**hole constant will be an integral part of that theory.
My Blog[^]
|
|
|
|
|
jarlath wrote:
This process is fraught with difficulty and more often than not does not guarantee a list of exclusive numbers and duplicates do occur. Plus it takes 50 lines of code. Resource intensive!
How did you manage to write 50 lines of code just to generate 7 unique random numbers ? That's gotta be some sort of record.
The easiest way to do it is to use a set, if .NET supports them. Then you just keep adding until the count = 7.
According to this:
http://www.codeproject.com/csharp/sets.asp[^]
sets are not supported. The althernative is to create an object, and use it with a map ( hashtable ), using your numbers as keys. Then check for the keys collection to be equal to 7.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
I made a notepad with vb.net and I added a fontdialog in it. When i save a text file with some different font types, when I open that file the font will come again courior (default font). The extension is .txt! Why is this??  (
Adrian De Battista
|
|
|
|
|
How are you saving the file?
Just because you add a font dialog and select fonts does not mean that you are preserving that data when you save the file.
What control are you using as the text area on the form? If it is hust a text box then you are not going to get what you want.
Take a look at the rich textbox control.
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
Jörgen Sigvardsson wrote:
If the physicists find a universal theory describing the laws of universe, I'm sure the a**hole constant will be an integral part of that theory.
|
|
|
|
|
I am using the Rich Textbox. But it doesn't open it as I save it!
|
|
|
|
|
How are you saving the file?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
