Visual Basic Discussion Boards

Re: The Scope of the Adapter in the Following code

Dave Kreskowiak31-Jul-07 7:13

31-Jul-07 7:13

The scope as you've written the code, is the life of the Form_Load sub. Anything you Dim in the Sub is destroyed when execution leaves the Sub.

Vuyiswamb wrote:
1) how can i declare the adapter and the connection objects to be on the same scope when you drag and drop them on the form?

You can't. Their code is created in different places.

Vuyiswamb wrote:
2)And from my search, am searching from a Field that has (## ## ## ## ##) numbers in a string Field, and i have to rearch by retrieving the first four,i can do that in SQL by using substring, tell me how can i achieve this and display the data in the datagrid.?

I think you're asking about what the SQL SELECT would look like??

SELECT columns FROM table WHERE someColumn LIKE @Pattern

In your code, you'd add a SqlParameter object, with the parameters name @Pattern to the SqlCommand object this SQL is in and set it's value to something like "39 49 20 10 %". THe percent sign is the "wildcard" and will match anything else after the initial string.

A guide to posting questions on CodeProject[^]

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

move the toolbar in program

eyes200731-Jul-07 1:29

eyes2007

31-Jul-07 1:29

hi all

i need to move the toolbar on the form

will some one let me know how to do that

thnx

Re: move the toolbar in program

Tom Deketelaere31-Jul-07 1:46

Tom Deketelaere

31-Jul-07 1:46

I'm assuming you use a toolstrip for this

if so you can do this very easaly

just select the toolstrip and then in the tasks window (the little arrow on the upper right corner of the control or the gray area under the properties window) select 'embed in toolstripcontainer' then just put the toolstripcontainer dock property on fill.

after this the user can move the toolstrip around the form (all controls added to the form must be in the toolstripcontainer)

the 'gripstyle' property of the toolstrip has to be set to 'visible'

Re: move the toolbar in program

eyes200731-Jul-07 2:46

eyes2007

31-Jul-07 2:46

thnx for the help

but it not just working

i select the toolstrip and then select embed in toolstripcontainer this make a new container

then when i put the toolstripcontainer dock property to fill then it fills the whole form

i have
2 toolstrip
one ruler
one erichtextbox and
one statustrip

plz tell me what m i forgeting

Re: move the toolbar in program

MartyK200731-Jul-07 3:17

MartyK2007

31-Jul-07 3:17

trying switching off docking
switchimg off auto size then move the tollstrip to where you wish it to be and then use the anchors.
This works with tools trips dont know about the containers though.

HTH
MArtin

life is a bowl of cherries
go on take a byte

Re: move the toolbar in program

Tom Deketelaere31-Jul-07 3:25

Tom Deketelaere

31-Jul-07 3:25

I'v tried emailing you an example project but I keep getting an delivary failure

can you provide me with a working email acount

Re: move the toolbar in program

Tom Deketelaere31-Jul-07 20:59

Tom Deketelaere

31-Jul-07 20:59

I've tried both emails you send me but they don't work
can you provide me with an hotmail, google, yahoo mail account
those are the safest and generally never cause any problems

Re: move the toolbar in program [modified]

eyes200731-Jul-07 4:22

eyes2007

31-Jul-07 4:22

thnx

Updating a control via a Thread

portech31-Jul-07 1:08

portech

31-Jul-07 1:08

Hi all
Just need some advice and help with the issue of Threads..Just come over from VB6 and not to sure about this one..

I have an application which waits for HTTP requests which is the main process. Once a request is recieved a thread is started to do something..on the Main Form i have a status Textbox which i want to keep up to date with the HTTP requests and also when the thread has finished etc.

Please advise as to how i may achieve this

TIA

Re: Updating a control via a Thread

Luc Pattyn31-Jul-07 1:15

Luc Pattyn

31-Jul-07 1:15

Since all Controls normally get created by the main thread (aka "GUI thread")
and should be handled only by the thread that created them (they are not
thread-safe), one needs a special technique to access them from another thread.

The Control class has some members to support this: the InvokeRequired property
and the Invoke() or BeginInvoke() methods. I suggest you read up on these;
examples are plenty on CodeProject. There is one in my Sokoban article (that's
in C# but the concept is exactly the same).

Smile | :)

Luc Pattyn

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

Set focus to a tabpage

Sadiq Parker31-Jul-07 0:40

Sadiq Parker

31-Jul-07 0:40

How can set focus to a particular tabpage in vb.net 2005

Re: Set focus to a tabpage

Christian Graus31-Jul-07 0:47

Christian Graus

31-Jul-07 0:47

Isn't there a selected tab property ? Assuming you're asking about winforms.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Set focus to a tabpage [modified]

Tom Deketelaere31-Jul-07 1:39

Tom Deketelaere

31-Jul-07 1:39

indeed there is

and the code would look like this

tabcontrolname.selectedtab = tabpagename

-- modified at 7:57 Tuesday 31st July, 2007

you could also use selectedindex but then this will stop working properly if you change the order of the tabs

Re: Set focus to a tabpage

SamRST31-Jul-07 4:12

SamRST

31-Jul-07 4:12

really , thnks my frnd .. its working

Re: Set focus to a tabpage

Tom Deketelaere31-Jul-07 4:47

Tom Deketelaere

31-Jul-07 4:47

glad to be of assistence Big Grin | :-D

Re: Set focus to a tabpage

SamRST31-Jul-07 4:13

SamRST

31-Jul-07 4:13

really thnks my frnd.. its working..

Urgent connection pooling

viralbhatt30-Jul-07 23:09

viralbhatt

30-Jul-07 23:09

Hello,

first of all I am new to .net and don't know much about connection pooling. I have read few articles from .net but still don't get answer for few questions.

my boss came to me and told me to do some research on connection pooling and write application that will have six buttons. three button will get connection from pool and other three button will close this connection one by one. I wanted to put one more button to destroy all connection that works fine using Clearallpools but clearpool doesn't work. I can post code here if anyone want to look at it.

Thank you.

Viral

Re: Urgent connection pooling

Christian Graus31-Jul-07 0:23

Christian Graus

31-Jul-07 0:23

.NET handles it's own connection pooling, you should not write your own.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Urgent connection pooling

viralbhatt31-Jul-07 0:49

viralbhatt

31-Jul-07 0:49

thank you for your reply.

I am not writing my own pooling, just want to know how can I handel pooling and monitor it. I just want to know how it works and what type of problem I can get if we develop project using connection pooling. it will be great if someone tells me if there are any other connection type available for .net.

Re: Urgent connection pooling

Naji El Kotob31-Jul-07 0:55

Naji El Kotob

31-Jul-07 0:55

Hi,

I hope first you are using a support pooling database (e.g. MS SQL), you can think about pooling as objects that are always ready to answer your (client) connection requests (in case they are available). This is good technique when you have a number of concurrent users. to simplify the issue:

You can enable/disable pooling via ConnectionString ADO.NET 2.0 introduces ClearAllPools http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.clearallpools(VS.80).aspx[^] and ClearPool http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.clearpool(VS.80).aspx[^] methods to clear the pool.

In addition you will need to read more about Close and Dispose of XxxConnection object (e.g. SQLClient.SQLConnection) http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection(vs.80).aspx[^]

This article could help http://www.ondotnet.com/pub/a/dotnet/2004/02/09/connpool.html[^]

hope this helps, best wishes Smile | :)

NajiCo http://www.InsideVB.NET[^]

It's nice 2b important, but it's more important 2b nice...

Re: Urgent connection pooling

Naji El Kotob31-Jul-07 1:05

Naji El Kotob

31-Jul-07 1:05

Hi Again,

This is a good article http://msdn2.microsoft.com/en-us/library/8xx3tyca(VS.80).aspx[^] Wink | ;)

NajiCo http://www.InsideVB.NET[^]

It's nice 2b important, but it's more important 2b nice...

Verbatim literal

LishaDamian30-Jul-07 22:11

LishaDamian

30-Jul-07 22:11

What is the syntax to represent Verbatim literal(@ in C#) in VB.net ?

Re: Verbatim literal

Dave Kreskowiak31-Jul-07 2:50

Dave Kreskowiak

31-Jul-07 2:50

There isn't any. All strings denoted by quotes are literal. There are no escape characters in VB.NET.

A guide to posting questions on CodeProject[^]

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

Re: Verbatim literal

Dave Doknjas31-Jul-07 13:45

Dave Doknjas

31-Jul-07 13:45

Actually, there is one escape character - a double quote is escaped by another double quote.
e.g., Dim s As String = "abc""def"

David Anton
http://www.tangiblesoftwaresolutions.com
Instant C#: VB to C# converter
Instant VB: C# to VB converter
C++ to C# Converter: converts C++ to C#
C++ to VB Converter: converts C++ to VB
Instant C++: converts C# to C++/CLI and VB to C++/CLI

Re: Verbatim literal

Dave Kreskowiak31-Jul-07 16:52

Dave Kreskowiak

31-Jul-07 16:52

Whoops, forgot about that one! :->

A guide to posting questions on CodeProject[^]

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

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.