regarding storing the key windows registry in vb.net - Visual Basic Discussion Boards

Hi all, i want to ask a question about datareader. I have a user control its inherits ListView. And I have a table has 500000 records. For performance fill the listview, when form_load i fill first 20 records. When user click scroll down add to 21 record. Every click add to next record. How can i do this with DataReader. And how can i hand event to scroll click. Please help me. My code below;

User Control ;
Dim x As Integer
Dim dbConn As New SqlConnection("server=" + _ServerName + ";database=" + _DatabaseName + ";uid=" + _UserName + ";pwd=" + _PassWord)
Dim strQuery As String = "SELECT * FROM ListeKontrol"
dbConn.Open()
Dim myCommand As New SqlCommand(strQuery, dbConn)
Dim myReader As SqlDataReader = myCommand.ExecuteReader()
While myReader.Read And x < 20
MyBase.Items.Add("")
MyBase.Items(x).SubItems(0).Text = x.ToString
MyBase.Items(x).SubItems.Add("ListeAck")
MyBase.Items(x).SubItems.Add("Alan1")
MyBase.Items(x).SubItems.Add("Alan2")
x = x + 1
End While

S.A.A

cmpe orko wrote:
"SELECT * FROM ListeKontrol"

This is the wrong way to go about it. If you have 500 thousand records, you need to think about it a little more than this. Your best bet is to write a stored proc that takes a page number and a number of records per page, and request the page you need every time. A dataset that you bind to makes more sense than using a loop and a datareader.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Thanks my friend, but i don't understand clearly. How get page number or some range of records with stored proc. Can I get some row index with sql.

S.A.A

Yes, you can get a row index, if you have an identity column and you don't delete records, you can use that.

http://blogs.x2line.com/al/archive/2004/05/29/325.aspx[^] was my first google hit

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Thank you my friend.

S.A.A

I have created a form and i have added a label,the label is supposed to be template in which 99 new labels would be generated,at the moment i can only generate one label clone of the label template.here is the code

Private Sub frmBackTrack_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
obj = New Labels2
'instantiate new checkbox class
Dim MyLabel As New Labels
'assigning the properties of the new object
With MyLabel
.Text = ("Label2")
.Left = Label1.Left
.Top = Label1.Top + Label1.Height
.Size = Label1.Size
'.BackColor = Color.Azure
End With
'adding checkbox control to the form
Me.FlowLayoutPanel1.Controls.Add(MyLabel)

End Sub
please assist me to generate the other labels

I'm not sure what you need here, except to suggest you look into for loops. You really should buy a beginners book and work through it, the concetp of a loop is pretty starting level.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

hai friends

to store a key in windows rwgistry

that too in "HKEY_CURRENT_USER"

i used the following code.....

Application.UserAppDataRegistry.CreateSubKey("Software\Microsoft\Keyname")

oke its working..

but the key is storing along my application details..

say my application name:appxyz
company name: compxyz
Version :1.0.0.0
first it is creating a key with company name
and within company name... the sub key is ...version

then with in version .... it is creating .... software\microsoft\keyname..

i dont want to happen this....
by any one can find out the key...
bcoz they know my company name...
they will search for it in registry
and looks for the data...

my requirement is like this ...
i want to create a key(s) in "Hkey_Current_User"
but in differnet places...

plz help me...

thanks in advance
bye

vijay
devulapally_vijay@yahoo.co.in

What you want to do is nasty, you should put the keys where people can find them, but I get why you'd want to hide stuff, for security, etc. Get rid of the Application. stuff and use the raw APIs that allow you to access the registry where-ever you like. There's tons of articles here and on google.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Use the Registry classes instead of the Application shortcuts. This will give you much greater control over what you need to do.

Documentation on the Registry class[^] on MSDN.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

I have a table with long columns header .
I must show columns in 2 or more lines .
please help me how I can set the janus GridEx column Header wordwrap true .
en.Mahdi

Did it occur to you to ask here[^] ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

it is better that you answer me .
i know you can not answer to me .
jam kon kazo koozato .

is how you replied to me via email. I am replying here so you don't get my email address.

No, I don't know. Nor does anyone else. We don't use this grid. That's why I suggested you ask people who DO use it.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

I'd like to allow my users to write code statements in array format, for instance

c = a + b

where a and b are really a() and b() arrays.

Any ideas how I could do this? I've checked math code parsers, but none of them seem to do arrays.

Thanks!

In what context, are you writing a library ? What are the rules for adding two arrays ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Well the math is array math, as in c++.

OK, I clearly need to be more specific.

I'd really like to create an intellisense-capable editor that would allow my users to write and see their errors in vb.net code. However, for a few functions, I'd like add c++ type capabilities, such as:

c = a + b

where c a and b are actually arrays.

other relevant array operators are < > = - / *

Maybe the first question should be how to implement the intellisense editor.

Thanks again.

Hi,

you want to define your own type (class or struct) and use operator overloading.
Look for some articles here at CodeProject on such things as complex numbers, or big integers;
that will show you the principles.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

This month's tips:
- 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 PRE tags to preserve formatting when showing multi-line code snippets.

Thanks Luc. I didn't know about operator overloading -- that's exactly what I need.

What about applying vb.net intellisense in a user editor?

Any ideas on that?!

cstrader232 wrote:
vb.net intellisense in a user editor?

Not sure I understand the question.

Inside Visual Studio Intellisense is at your service; it parses your project files and adds
class information to the system's .NET information and presents it while editing.

In a separate editor, you can do similar things; I have no idea some Intellisense component
from VS would be available to assist you in that. I trust big editors have it on their own,
you may (or may not!) want to have a look at Eclipse, the Java IDE started long ago by IBM.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

This month's tips:
- 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 PRE tags to preserve formatting when showing multi-line code snippets.

Thanks Luc... very helpful.

i've problem in running the application using vb, i'm using visual studio 2008, then after complete my application i'm trying to run it on other computer using window xp, but the problem occur, anyone can help me why this happen and how to solve it..

What does 'the problem occur' mean ? What goes wrong ? Are you installing the .NET framework on the other machine ? Did you try to google your error message ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

so, it required NET framework to running?
thanks a lot for your superb helping.

shee_dee86 wrote:
o, it required NET framework to running?

Yes, I recommend you do some reading so you have a basic idea of what the framework you're using does, and how it works.

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )