|
|
A.E.K wrote: why people there dont inform me via e-mail?
The article looks good to me. Don't worry, unedited means unedited. If they had looked at it to bother to email you, they would have edited it, I would presume.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Background: I have a datagridview that I am adding rows to manually. In design mode, I have specified the column header text on all columns to sans sherif, 14, bold (I have done this specifically to each column and also specified the font settings as the default header cell style). Various other formatting changes were made like making the highlighted rows yellow etc.
1. When I start the app, the column header text reverts back to the default header text sytle (Arial 8). What causes this to occur?
*EDIT* - in regards to #1, I found that if I reset the AutoSizeMode, the column header text switches back to one line. But what is the root cause of the grid losing the formatting at runtime?
I also found some posts on other sites that forcing a sort on the grid may at times clear the formatting. In this case, I'm not doing any sorts that would cause this condition. Any ideas on why this occurs?
Any suggestions, ideas, or 'constructive criticism' are always welcome.
modified on Thursday, August 21, 2008 8:47 AM
|
|
|
|
|
I need to create a routine that queries a database whenever an event is fired. the thing is that I have to wait a specific amount of time before I execute that query. I am already able to run the sql query but I am not sure how to go about waiting the specified amount of time. Also each time the event is fired, it could require a different wait time, which could be up to 24 hours.
Right now I use a background worker to process the database query but can I (should I) use a wait inside the background worker?
Thanks in advance
|
|
|
|
|
Yes (and yes). There are two ways that come to mind if you need this kind of a wait. If you will not ever need to cancel the wait, you can just use Thread.Sleep, but if you may need to cancel (eg: to shut the thread down immediately), you can use an AutoResetEvent (or one of the other similar System.Threading classes).
As far as the variable wait time, just encapsulate the DoWork event handler in a class with the wait time as a field or property.
Here's a simple console app sample to demonstrate the two ways. Uncomment the lines and comment the Thread.Sleep line to use the AutoResetEvent instead.
Dim waitTime As Integer
Dim handle As New System.Threading.AutoResetEvent(False)
Sub Main()
Dim rand As New System.Random
waitTime = rand.Next(10, 20)
Dim bw As New System.ComponentModel.BackgroundWorker
AddHandler bw.DoWork, AddressOf WorkerRoutine
Console.WriteLine("Wait time will be {0} seconds", waitTime)
bw.RunWorkerAsync()
'Console.WriteLine("Press any key to interrupt the worker.")
'Console.ReadKey()
'handle.Set()
Console.WriteLine("Program complete...")
Console.ReadKey()
End Sub
Private Sub WorkerRoutine(ByVal sender As Object, ByVal e As System.ComponentModel.DoWorkEventArgs)
Console.WriteLine("Beginning work")
System.Threading.Thread.Sleep(waitTime * 1000) 'gives a non-interruptable sleep
'handle.WaitOne(waitTime * 1000, False) 'gives an interruptable "sleep" period
Console.WriteLine("Ending work")
End Sub
|
|
|
|
|
Is there a good way to connect to a password protected Access databse usig VB.Net?
I tried some of those but it is still giving me errors!!
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;"
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd="
|
|
|
|
|
I use an OLEDB connection with this connection string:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;
If you are looking for more connection string options this [^]is a great site.
Hope this helps.
|
|
|
|
|
may be work with
Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=PWD;Data Source=C:\mydatabase.mdb;Persist Security Info=False
Emimmortal
|
|
|
|
|
Thank you all for replying. It was a great help to try diffrent methods.
John,
|
|
|
|
|
i need help on something i have this
Dim SQLIinsert As String = "UPDATE httpuser SET credits= " + -1 + "' WHERE username='" + My.Settings.Username + "'"
what i need is to decrease the column credits by 1 but it this i get -1 in the database.
can someone explain whats wrong? ive searched but im almost ready to quit.
thanks in advance
|
|
|
|
|
You are telling the database 'SET credits=-1', so that is what it's doing. I believe you can say 'SET credits=credits-1' to get the effect you want.
|
|
|
|
|
thanks that does the job very well.
|
|
|
|
|
Hi,
I work with vb6
i need to write a function which will get
an array of bytes, count how many bytes are
there and run a loop in that size...
i managed to get the length of an array with "x = LenB(y)"
but that function somtimes recieve a single byte (not an array)
and then the size i get for it is 4 instead of 1
how can i determin if what i get in is a byte or an array of bytes
also i dont know what to write in the declaration of the function
("Function myfunc(???)")
thanks in advance.
|
|
|
|
|
It would be easier to help if you post your code and show us where the problem is.
|
|
|
|
|
O.k its quite simple , im not at home so ill write what i remember.
Function CS(a) 'is the decleration ok ?
dim n as int 'Define counter
dim temp as byte 'temp for storing CS
temp = 0
dim b(LenB(a)) as byte '(if a is 7 bytes long i get a new aray of 8 bytes here)
for n = 0 To LenB(a)-1
b(n) = a(n)
temp = temp Xor a(n)
next
.
.
.
b(n+1) = temp '(i dont remeber if its n or n+1 depends if it got increased by the for)
a = b
End Function
if i send an array to this function all goes well
lets say i have an array of bytes named try1(7)
the LenB(a) will return the currect size of it
but when i send it a single byte (not an array) it returns 4.
i need to find a way to get the size of "a"
so if its 1 ill skip the "for n=0..." and do somthing else.
Thanxs again.
|
|
|
|
|
Hi All,
Can you please correct if I am wrong I have declared a function that returns array of object as below, pls. rectify me if I am wrong
Public Function convertInToObject(ByVal dsParameterValues As DataSet) As Object()
Thanks a Lot,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
|
I think it should be this when you return an array.
Public Function convertInToObject(ByVal dsParameterValues As DataSet) As Array
|
|
|
|
|
Just out out of curiousity would any of 2 of you who gave me a 1 vote explain your reason since the answer I gave is correct. As Object will work because of late binding but As Array is preferable.
|
|
|
|
|
|
Don't worry I didn't think it was you. I must have pissed someone off recently since someone has been giving me a bunch of 1 votes but I was wondering why I got the second 1 votes.
|
|
|
|
|
sounds like you not only have attracted a univoter but a copycat univoter - you should feel priveledged.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
Hi I'm trying to convert this C# code in to VB.net
public event EventChannelMessage EventChannelMessage
{
add { m_EventChannelDataReceived += value; }
remove { m_EventChannelDataReceived -= value; }
}
Here is the converted code i got from one of the code converters but it cannot compile in VB.
Public Custom Event EventChannelMessage As EventChannelMessage
AddHandler(ByVal value As EventChannelMessage)
m_EventChannelDataReceived += value
End AddHandler
RemoveHandler(ByVal value As EventChannelMessage)
m_EventChannelDataReceived -= value
End RemoveHandler
End Event
Anyone who understand both VB and C# please help me as this needed ASAP.
Thanks in Advance.
|
|
|
|
|
Try one of the free online C# to VB.NET convertors like this one[^].
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|