Timeout Expired

[Agnes]

I am using vb.net to process a SP
The sp are insert XXX select () statment, there are two parameters , Start
Company code and End Company Code,
The user input the range From A to Z or From A to B.
I found that If the range is A to C , the SP runs fine , if the range is A
to Z , I will got Timeout Expired error,
If I run the SP in SQL analyzer, everyting go fines.
Does the error belong to vb.net ?

Dim cmd As New SqlClient.SqlCommand
cmd.Connection = conSea
cmd.CommandText = "dbo.sel_cs_company"
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@reportid",
SqlDbType.VarChar, 20)).Value = Me.pReportId

cmd.ExecuteNonQuery()
cmd.Parameters.Clear()
cmd.Dispose()

--
Thanks !

--
..

[Cor Ligthert]

Agnes,

In this code is not much VBNet except that you uses "dim" furter it is exact
the same as C# without row end stuff.

You can use the
cmd.CommandTimeout = 160

However when it stays I would ask it in the newsgroup
Adonet
news://msnews.microsoft.com/microsof...amework.adonet

Web interface:
http://communities2.microsoft.com/co...amework.adonet

I hope this helps?

Cor

"Agnes" <ag***@dynamictech.com.hk>

I am using vb.net to process a SP
The sp are insert XXX select () statment, there are two parameters , Start
Company code and End Company Code,
The user input the range From A to Z or From A to B.
I found that If the range is A to C , the SP runs fine , if the range is A
to Z , I will got Timeout Expired error,
If I run the SP in SQL analyzer, everyting go fines.
Does the error belong to vb.net ?

Dim cmd As New SqlClient.SqlCommand
cmd.Connection = conSea
cmd.CommandText = "dbo.sel_cs_company"
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@reportid",
SqlDbType.VarChar, 20)).Value = Me.pReportId

cmd.ExecuteNonQuery()
cmd.Parameters.Clear()
cmd.Dispose()

--
Thanks !

--
.

[Cor Ligthert]

Agnes,

In this code is not much VBNet except that you uses "dim" furter it is exact
the same as C# without row end stuff.

You can use the
cmd.CommandTimeout = 160

However when it stays I would ask it in the newsgroup
Adonet
news://msnews.microsoft.com/microsof...amework.adonet

Web interface:
http://communities2.microsoft.com/co...amework.adonet

I hope this helps?

Cor

"Agnes" <ag***@dynamictech.com.hk>

I am using vb.net to process a SP
The sp are insert XXX select () statment, there are two parameters , Start
Company code and End Company Code,
The user input the range From A to Z or From A to B.
I found that If the range is A to C , the SP runs fine , if the range is A
to Z , I will got Timeout Expired error,
If I run the SP in SQL analyzer, everyting go fines.
Does the error belong to vb.net ?

Dim cmd As New SqlClient.SqlCommand
cmd.Connection = conSea
cmd.CommandText = "dbo.sel_cs_company"
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@reportid",
SqlDbType.VarChar, 20)).Value = Me.pReportId

cmd.ExecuteNonQuery()
cmd.Parameters.Clear()
cmd.Dispose()

--
Thanks !

--
.

[Agnes]

I just set commandTimeout = 0 , and there is no error anymore

--
..
"Cor Ligthert" <no************@planet.nl> ¦b¶l¥ó
news:eK****************@TK2MSFTNGP15.phx.gbl ¤¤¼¶¼g...

Agnes,

In this code is not much VBNet except that you uses "dim" furter it is exact the same as C# without row end stuff.

You can use the
cmd.CommandTimeout = 160

However when it stays I would ask it in the newsgroup
Adonet
news://msnews.microsoft.com/microsof...amework.adonet

Web interface:
http://communities2.microsoft.com/co...amework.adonet
I hope this helps?

Cor

"Agnes" <ag***@dynamictech.com.hk>

I am using vb.net to process a SP
The sp are insert XXX select () statment, there are two parameters , Start Company code and End Company Code,
The user input the range From A to Z or From A to B.
I found that If the range is A to C , the SP runs fine , if the range is A to Z , I will got Timeout Expired error,
If I run the SP in SQL analyzer, everyting go fines.
Does the error belong to vb.net ?

Dim cmd As New SqlClient.SqlCommand
cmd.Connection = conSea
cmd.CommandText = "dbo.sel_cs_company"
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@reportid",
SqlDbType.VarChar, 20)).Value = Me.pReportId

cmd.ExecuteNonQuery()
cmd.Parameters.Clear()
cmd.Dispose()

--
Thanks !

--
.

[Agnes]

I just set commandTimeout = 0 , and there is no error anymore

--
..
"Cor Ligthert" <no************@planet.nl> ¦b¶l¥ó
news:eK****************@TK2MSFTNGP15.phx.gbl ¤¤¼¶¼g...

Agnes,

In this code is not much VBNet except that you uses "dim" furter it is exact the same as C# without row end stuff.

You can use the
cmd.CommandTimeout = 160

However when it stays I would ask it in the newsgroup
Adonet
news://msnews.microsoft.com/microsof...amework.adonet

Web interface:
http://communities2.microsoft.com/co...amework.adonet
I hope this helps?

Cor

"Agnes" <ag***@dynamictech.com.hk>

I am using vb.net to process a SP
The sp are insert XXX select () statment, there are two parameters , Start Company code and End Company Code,
The user input the range From A to Z or From A to B.
I found that If the range is A to C , the SP runs fine , if the range is A to Z , I will got Timeout Expired error,
If I run the SP in SQL analyzer, everyting go fines.
Does the error belong to vb.net ?

Dim cmd As New SqlClient.SqlCommand
cmd.Connection = conSea
cmd.CommandText = "dbo.sel_cs_company"
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@reportid",
SqlDbType.VarChar, 20)).Value = Me.pReportId

cmd.ExecuteNonQuery()
cmd.Parameters.Clear()
cmd.Dispose()

--
Thanks !

--
.

[Cor Ligthert]

Agnes,

Than you can probably as well delete your database without that you get an
error.
From the page about that property

A value of 0 indicates no limit, and should be avoided in a CommandTimeout
because an attempt to execute a command will wait indefinitely.

I hope this helps?

Cor

"Agnes" <ag***@dynamictech.com.hk>
..

I just set commandTimeout = 0 , and there is no error anymore

--
.
"Cor Ligthert" <no************@planet.nl> ¦b¶l¥ó
news:eK****************@TK2MSFTNGP15.phx.gbl ¤¤¼¶¼g...

Agnes,

In this code is not much VBNet except that you uses "dim" furter it is

exact

the same as C# without row end stuff.

You can use the
cmd.CommandTimeout = 160

However when it stays I would ask it in the newsgroup
Adonet
news://msnews.microsoft.com/microsof...amework.adonet

Web interface:

http://communities2.microsoft.com/co...amework.adonet

I hope this helps?

Cor

"Agnes" <ag***@dynamictech.com.hk>

>I am using vb.net to process a SP
> The sp are insert XXX select () statment, there are two parameters , Start > Company code and End Company Code,
> The user input the range From A to Z or From A to B.
> I found that If the range is A to C , the SP runs fine , if the range
> is A > to Z , I will got Timeout Expired error,
> If I run the SP in SQL analyzer, everyting go fines.
> Does the error belong to vb.net ?
>
> Dim cmd As New SqlClient.SqlCommand
> cmd.Connection = conSea
> cmd.CommandText = "dbo.sel_cs_company"
> cmd.CommandType = CommandType.StoredProcedure
> cmd.Parameters.Add(New SqlParameter("@reportid",
> SqlDbType.VarChar, 20)).Value = Me.pReportId
>
> cmd.ExecuteNonQuery()
> cmd.Parameters.Clear()
> cmd.Dispose()
>
> --
> Thanks !
>
> --
> .
>
>

[Cor Ligthert]

Agnes,

Than you can probably as well delete your database without that you get an
error.
From the page about that property

A value of 0 indicates no limit, and should be avoided in a CommandTimeout
because an attempt to execute a command will wait indefinitely.

I hope this helps?

Cor

"Agnes" <ag***@dynamictech.com.hk>
..

I just set commandTimeout = 0 , and there is no error anymore

--
.
"Cor Ligthert" <no************@planet.nl> ¦b¶l¥ó
news:eK****************@TK2MSFTNGP15.phx.gbl ¤¤¼¶¼g...

Agnes,

In this code is not much VBNet except that you uses "dim" furter it is

exact

the same as C# without row end stuff.

You can use the
cmd.CommandTimeout = 160

However when it stays I would ask it in the newsgroup
Adonet
news://msnews.microsoft.com/microsof...amework.adonet

Web interface:

http://communities2.microsoft.com/co...amework.adonet

I hope this helps?

Cor

"Agnes" <ag***@dynamictech.com.hk>

>I am using vb.net to process a SP
> The sp are insert XXX select () statment, there are two parameters , Start > Company code and End Company Code,
> The user input the range From A to Z or From A to B.
> I found that If the range is A to C , the SP runs fine , if the range
> is A > to Z , I will got Timeout Expired error,
> If I run the SP in SQL analyzer, everyting go fines.
> Does the error belong to vb.net ?
>
> Dim cmd As New SqlClient.SqlCommand
> cmd.Connection = conSea
> cmd.CommandText = "dbo.sel_cs_company"
> cmd.CommandType = CommandType.StoredProcedure
> cmd.Parameters.Add(New SqlParameter("@reportid",
> SqlDbType.VarChar, 20)).Value = Me.pReportId
>
> cmd.ExecuteNonQuery()
> cmd.Parameters.Clear()
> cmd.Dispose()
>
> --
> Thanks !
>
> --
> .
>
>