|
|
|
I create a DataGrid1, the data from a database table.
A column it is called ID, the data type is integer =1,2,3,4,5,6 ….
Now I just want to convert the integer to a string.
Select id
Case 1
DataGrid1.Item(i)=”aaaaa”
Case 2
DataGrid1.Item(i)=”bbbbb”
Case 3
DataGrid1.Item(i)=”ccccc”
Case 4
DataGrid1.Item(i)=”ddddd”
Case 5
DataGrid1.Item(i)=”eeeee”
.
.
.
End select
The error message is “cannot be converted to type 'String'”
Email me:xuweiying@yahoo.com or wxu@stantec.com
Wayne Xu
|
|
|
|
|
I need a file dialog that I can set to browse files on a remote machine. How can I limit (or set the root folder) what the users sees so that it only displays the remote machines info?
I'm looking for functionality similar to sql server ent mgr create db dialog. When you specify the sql server db mdf/ldf file paths it restricts you to the folders on the remote sql server machine.
How can i do this?
Thanks
Glenn
|
|
|
|
|
isgrom wrote: I need a file dialog that I can set to browse files on a remote machine. How can I limit (or set the root folder) what the users sees so that it only displays the remote machines info?
Try to read an article relate to Open File dialogbox[^] check the properties of IntialDirectory and set it it in the run time code to point to any remote machine that you prefer (Exp: \\RemoteHost\ )
|
|
|
|
|
Yes I can set the initial directory but how to I set its root also to that location so the user is restricted to directories on the remote machine (do I don't see my current machines dir info) Figure that one out. I can't.
Thanks
Glenn
|
|
|
|
|
isgrom wrote: Yes I can set the initial directory but how to I set its root also to that location so the user is restricted to directories on the remote machine (do I don't see my current machines dir info) Figure that one out. I can't
You have to know the share name of the folder that share resource to you. Without the appropriate share name your user will see a list of share in the remote machine that he is access too. If possible, you should define a policies of creating a share name convention which point to only the specific resource. But if you want to make it dynamic based on the requirement of your user, i suggest you to prompt the user with inputbox function to allow the user to enter the specific naming convention to the share resource that he or she need to access to.
|
|
|
|
|
Hi
I have a combobox which should show folders+files when user types (like Run in windows) I use SHAutoComplete API to give it this ability.
The problem is that in most occasions (!!) when I complie the program (written in vb6) the AutoComplete window (which is shown as user types in the combobox) only shows folders while I set the flag to 0x0 which should show Folders and files. The strange part is that in some occasions this works perfect!
I am totally mixed up!
I'd be glad if someone could help me.
|
|
|
|
|
Try to read this article[^], it might give you some idea relate to your issue.
|
|
|
|
|
Hi guys,
i am working on making a image manipulation program, in that most of the
effects i have managed to achieve using ColorMatrix class & Lockbits method of .NET. Now
i am stucked on getting one effect which is very vital
& thats "1 Dot Half Tone Pattern" (this is what the effect in Photoshop under Filter->Sketch->Halftone Pattern. Please help me achieving this or
explaining about this particular pattern.
Any path to proceed will be highly helpful.,
u can mail me too on rachitonline@gmail.com/rachitkohli@gmail.com
Rachit
|
|
|
|
|
What does it do ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi everybody,
We have been having database replication problems the last few months so now I have to do my own database replication program.
We have a database saved state for all clients. We want to write a program which will look at both states, database and client, and just take the columns and values of the things that changed. so when I look at one table and compare it to the client I can see that on row x only the value of column y has changed. We want to put in a meschanism which works with bits, meaning when a column value changes it gets a bit of 1, if not it is equal 0.
My problem is I know I have 59 columns on 1 table, so for this table I need 59 bits which are 7 "Full" Bytes(pls correct me if I am wrong 1 Byte = 8 Bits) + 1 byte where only the first three bits are to be filled with and the rest null. How can I fill my Bytes with ones and zeros and how can I write them to the text file.
I have not had any experience working with bits and bytes till now and I really don't understand it....
Thank you in advance,
/Peace2u my friend
|
|
|
|
|
<code>
'To set bit number 3's value (0-based):
Dim bit3 as Boolean
Dim Value as ... 'This is the value to save columns data for each table
Value = iif ( bit3isTrue , 1, 0 ) And (2 ^ 3)'i.e. 0...0100
'Repeat it for each of 59 columns
'------------------
'To get bit number 3's value
bit3isTrue = Value And ( 2 ^ 3 )
'To Save data you only need to save Value
</code></
|
|
|
|
|
Have a look at the System.Collections.BitArray class.
---
b { font-weight: normal; }
|
|
|
|
|
Hi,
I had a look at it, but didn't find a way to put the bitarray values into a byte.
Visual Studio said it can't convert a bitarray to a byte. Did I oversee something?
Do you have an example?
Thank you,
/Peace2u my friends
|
|
|
|
|
Example:
Bitarray a = new BitArray(59);
byte[] b = new byte[8];
a.CopyTo(b, 0);
---
b { font-weight: normal; }
|
|
|
|
|
Hi Guffa,
Ok now I use
<br />
Dim MyBitArray As BitArray = New BitArray(MyBitLength)<br />
Dim MyBytes(BitsinByte) As Byte<br />
x = 0<br />
Do Until x = MyTable.Rows.Count - 1<br />
i = 0<br />
Line1a = ""<br />
Line1b = ""<br />
Do Until i = MyBitLength<br />
MyBitArray.Set(i, True)<br />
ColumnNames(i) = MyColumns.Rows(i).Item("name")<br />
i += 1<br />
Loop<br />
MyBitArray.CopyTo(MyBytes, 0)<br />
For j = 0 To MyBytes.Length - 1<br />
Line1a &= MyBytes(j)<br />
Next<br />
x += 1 <br />
Loop<br />
When I look at the values in MyByte it gives me 255, is that right?
Thank you in Advance,
/Peace2u my friends
|
|
|
|
|
Yes, a byte where all bits are set to one has the value of 255.
---
b { font-weight: normal; }
|
|
|
|
|
Hi,
Thank you. Do you know how I can write the byte value to a text file as byte or do I have to write it as text 255?
Thanks,
/Peace2u my friend
-- modified at 7:03 Friday 16th June, 2006
|
|
|
|
|
You can use the Convert.ToBase64String to encode the bytes into a reasonably compact format. Use Convert.FromBase64String to decode it.
Base 64 stores 6 bits in each character while still only using readable characters.
---
b { font-weight: normal; }
|
|
|
|
|
Hi. I use the Enum statement regularly, and I'm wondering if there's a similar statement where I can change the member's values? Because the Enum's members get declared as constants.. Please help me
----
Dim Sleepy as Boolean = True
If Me.Sleepy = True Then
Goto Sleep
End If
----
|
|
|
|
|
Nah - how about a Generics.Dictionary(Of String, Integer) ?
'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd
|
|
|
|
|
Or you could just make your own class with public variables and a public enum.
|
|
|
|
|
I want to learn crystal reports I mean how to show the table contents of database through crystal reports.Can u plz send me the steps to do that.
|
|
|
|
|