Visual Basic

Automatically scrolling a table upon keypress

3-Aug-07 11:14

If you only have 2 forms, why don't you either:

A, Put the data in tabs, or,
B, Just use one form either with or without logins.

Will either of those work for what you're needing?

list box control

sixecho3-Aug-07 7:16

sixecho

3-Aug-07 7:16

i used this line to select items in a row in a list box
''''''ListBox1.SelectedIndex = ListBox1.SelectedIndex + 1''''''

but when i get to the last item an error occures

ERROR Cry | :((

(argument out of range exception was unhandled)))

can any one give a solution

'''''VB.NET 2005'''''

Re: list box control

mr_lasseter3-Aug-07 7:32

mr_lasseter

3-Aug-07 7:32

You are getting the error becuase there is no item after the last item in the list. I am not sure what you are trying to accomplish, but you should check to see if you are currently selecting the last item in the list (use ListBox.Items.Count) and either don't move change the selectedIndex or you could set the selectedIndex to 0, to go back to the first item in the list.

Mike Lasseter

'Drew3-Aug-07 5:31

Re: Automatically scrolling a table upon keypress

3-Aug-07 5:31

I need something that will help me do the following:
tbxScrollTo will scroll through a somewhat large table (> 3000 entries) when you press a key in said textbox. For example, I type 6 and it will go to the closest entry to '6' (which turns out to be '63,' but I don't want it to go that far. Maybe + or - 10), and if I add '00' then I want it to go to Id '600.' However, if there is no '600' entry, I want it go to the closest one, '603.' I'd really like to do this without buttons, but it's a backup plan. Does anyone have any ideas to help me get started?

---------------------------------------------------
If it ain't broke, you're not doing your job!

Luc Pattyn3-Aug-07 6:14

Luc Pattyn

3-Aug-07 6:14

Hi,

first a preliminary remark: if your data is line oriented, it makes no sense to
me to show it in a TextBox; I would use a ListBox every time, it does not have
the overhead of concatenating all the lines, then the pain to find the line
beginnings and endings when you need to do something.

A listbox contains Items, that can be instances of your own class; or it might
just be strings. You can make it "OwnerDrawn", hence you can paint the items
any way you like. No sweat.

second: what is the problem? you seem to know which line you want to scroll to,
so just do it. Of course, a ListBox knows to do that quite easily, with its
TopIndex property.

Good luck!

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: Automatically scrolling a table upon keypress

'Drew3-Aug-07 6:29

Server side feature to manage bounce back email

3-Aug-07 6:29

The first table is 5 columns wide (table 1) and assembled in a hierarchy. I used Janus GridEx 2 (if that matters to anyone). There is another table that is 40,000 lines long (table 2) then another one that is a whimpy 40 lines (table 3). Table 1 is connected to table 2 which is connected to table 3 to form the hierarchy. I use a textbox (actually, Janus EditBox 2) because each individual number that I will be searching is unique. I was figuring that maybe this is possible, but I have found another way to do this. Thanks for the help!

If this matters to anyone, I used the filter on the GridEX itself.

Thanks again!

Tmikucybage3-Aug-07 5:04

Tmikucybage

3-Aug-07 5:04

i need to check the email bounce back and log all the mails information also.
i need to do it in vb.net a windows application.

help me out.

database location change

progalx3-Aug-07 4:31

3-Aug-07 4:31

I have this problem :I have developped a application in vb.net.This application use a microsoft Access database.I have used data wizard to create the connection , dataset , etc.But now there is a problem in our company : There are several Access Databases on some network computers and we want to work with these databases on my application.All the databases are identical . Now how can modify my application to make possible for users to choose one of this databases and to work with it.
I don't knoth if is possible to change the connection string ?
Or there is another way ?

Thank you in advance !

Paul Conrad3-Aug-07 4:38

Paul Conrad

3-Aug-07 4:38

You should be able to have multiple connection strings in the app.config file, if you are going that route.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Tom Deketelaere3-Aug-07 4:39

Tom Deketelaere

3-Aug-07 4:39

store the connectionstring in the settings file (property's of project -- settings)

then you can access this setting like my.settings.'what you provided for name'

you can add multiple connectionstrings if you want

you can create a form on wich the user select the db and you then create the connectionstring and store it to the settings

...

progalx3-Aug-07 4:47

3-Aug-07 4:47

Thank you
The databases are on different computers , later we can add new databases on other computers , the location of databases may change so is not possible to create multiple connectionstrings.

I like the idea to create a form where user to select the database and then to create the connection string.
But , how to create and store the connection string in the settings file ? Can you give me some code to do this ?

Thank you !

Tom Deketelaere3-Aug-07 5:20

Tom Deketelaere

3-Aug-07 5:20

to create a connection string in the settings file:

go to project -- property's -- settings tab there you can add a string (call it connectionstring (or somthing else)) or a connectionstring type value (I sugest a string since you want to easily alter it)

to save the connection string:

my.settings.connectionstring (or something else Poke tongue | ;-P

) = "a connectionstring"
my.settings.save ' normally not needed but just to be on the save side

then use the connnectionstring :

dim s as string = my.settings.connectionstring
make sure that you set the connectionstring setting before you use it (otherwise you'll get a nice error and crash Poke tongue | ;-P

)

this should do it

progalx3-Aug-07 6:19

3-Aug-07 6:19

i get an error : Property is readonly

Tom Deketelaere3-Aug-07 9:04

Tom Deketelaere

3-Aug-07 9:04

strange
try setting scope to application and not user (if not already like that)

progalx3-Aug-07 13:57

3-Aug-07 13:57

The same message "ConnectionString propert is readonly"

Mycroft Holmes3-Aug-07 14:39

Mycroft Holmes

3-Aug-07 14:39

The setting may be marked as an application setting, set it to a user setting. This should allow you to change the setting from your code.

progalx3-Aug-07 15:02

3-Aug-07 15:02

Same problem :

My.Settings.MyConnectionString = str
My.Settings.Save()

Error "Property MyconnectionString is readonly"

VB.Net & Crystal Reportrs DLLs

Mycroft Holmes4-Aug-07 17:06

Mycroft Holmes

4-Aug-07 17:06

In Visual Studio
Open the solution explorer pane
under your project name you will see "My Project"
Double click
in the main pane select the settings tab
identify the conection string setting and check the scope - this should be user and NOT application.

Central_IT3-Aug-07 3:49

Central_IT

3-Aug-07 3:49

I wonder if anyone can help me or had a similair problem.

At the moment I developed a system using VB.Net 2003 using Crystal Reports 8.5. We have now move to Crystal Reports 10. When I load up my project and then try running it, references CRAXDRT.DLL and CRVIEWERLib.DLL are not regonised. I have tried to remove and then install again. I have tried to re-register but with no luck. If I go back to 8.5, no problems.

Any ideas?

Re: VB.Net & Crystal Reportrs DLLs

'Drew3-Aug-07 10:18