how to solve this error??
-
error is : Timeout expired. The Timeout period elapsed prior to completion of the operation or the server is not responding.. This error comes when i used the datareader and passed the query . Dipan Patel.
-
error is : Timeout expired. The Timeout period elapsed prior to completion of the operation or the server is not responding.. This error comes when i used the datareader and passed the query . Dipan Patel.
Your query is taking longer than (by default) 30 seconds to run. If you expect your query to be completed in less than 30 seconds then there is a problem with your query. Otherwise you need to increase the
CommandTimeouton theSqlCommandobject to a satisfactory value.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog -- modified at 9:11 Saturday 6th May, 2006
-
Your query is taking longer than (by default) 30 seconds to run. If you expect your query to be completed in less than 30 seconds then there is a problem with your query. Otherwise you need to increase the
CommandTimeouton theSqlCommandobject to a satisfactory value.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog -- modified at 9:11 Saturday 6th May, 2006
please write in more detail... Dipan Patel.
-
please write in more detail... Dipan Patel.
The detail I gave is commensurate with the detail you gave in the original question. There was enough information to use Google or MSN Search to find the entry in MSDN: SqlCommand.CommandTimeout[^] You should learn how to use search engines - they are are most useful invention.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog -- modified at 9:21 Saturday 6th May, 2006
-
Your query is taking longer than (by default) 30 seconds to run. If you expect your query to be completed in less than 30 seconds then there is a problem with your query. Otherwise you need to increase the
CommandTimeouton theSqlCommandobject to a satisfactory value.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog -- modified at 9:11 Saturday 6th May, 2006
see Colin Angus Mackay, i wrote the code like --- dim Conn as New connect ' the file named connect.vb dim dr as sqldatareader dim query as string query="select * from enquiry" ' Error occur in below sentence dr=Conn.adpter(query) ' it call adpter(string) if dr.Read then end if --- The code written in adpter() Public Function adpter(ByVal pstr As String) As SqlDataReader dim s as sqlDataReader dim conn as new sqlconnection dim cmd as sqlcommand conn.open() cmd=New sqlcommand(pstr,conn) s=cmd.executereader() return s end function --- This function works properly 100% with other web forms.. but in this form i got the error... so help me.. Dipan Patel.
-
see Colin Angus Mackay, i wrote the code like --- dim Conn as New connect ' the file named connect.vb dim dr as sqldatareader dim query as string query="select * from enquiry" ' Error occur in below sentence dr=Conn.adpter(query) ' it call adpter(string) if dr.Read then end if --- The code written in adpter() Public Function adpter(ByVal pstr As String) As SqlDataReader dim s as sqlDataReader dim conn as new sqlconnection dim cmd as sqlcommand conn.open() cmd=New sqlcommand(pstr,conn) s=cmd.executereader() return s end function --- This function works properly 100% with other web forms.. but in this form i got the error... so help me.. Dipan Patel.
dipanmaster4u wrote:
This function works properly 100% with other web forms..
Either this statement is false, or the code you posted is not the code you are using. The code you have posted cannot work as it would throw an exception about a lack of connection string.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog
-
The detail I gave is commensurate with the detail you gave in the original question. There was enough information to use Google or MSN Search to find the entry in MSDN: SqlCommand.CommandTimeout[^] You should learn how to use search engines - they are are most useful invention.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog -- modified at 9:21 Saturday 6th May, 2006
I tried before it... if any other solution then tell me Dipan Patel.
-
dipanmaster4u wrote:
This function works properly 100% with other web forms..
Either this statement is false, or the code you posted is not the code you are using. The code you have posted cannot work as it would throw an exception about a lack of connection string.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog
hello sir, i already this function in 20 webforms... and works successfully... but in one form it not worked.. so there is not way to say that this code is wrong... Dipan Patel.
-
hello sir, i already this function in 20 webforms... and works successfully... but in one form it not worked.. so there is not way to say that this code is wrong... Dipan Patel.
dipanmaster4u wrote:
so there is not way to say that this code is wrong...
Then you did not post the actual code you are using because there is no connection string and without a connection string you cannot access any database. You need to post the actual code that you are using otherwise it does not help me to help you!
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog
-
dipanmaster4u wrote:
so there is not way to say that this code is wrong...
Then you did not post the actual code you are using because there is no connection string and without a connection string you cannot access any database. You need to post the actual code that you are using otherwise it does not help me to help you!
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog
-- this is code for connect.vb Imports System.Data.SqlClient Public Class connect Dim str As String Dim conn As New SqlConnection Public ds As DataSet Dim cmd As SqlCommand Public Sub setconnection() str = ConfigurationSettings.AppSettings("connstr") conn.ConnectionString = str End Sub Public Function adpter(ByVal pstr As String) As SqlDataReader Dim s As SqlDataReader conn.Open() cmd = New SqlCommand(pstr, conn) 'cmd.CommandTimeout = 15 s = cmd.ExecuteReader() Return s End Function end class ----- In my "fees.aspx" form Imports System.Data.SqlClient Public Class RegularFees Inherits System.Web.UI.Page Dim Conn As New connect Private Sub SAVE_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SAVE.Click Dim dr As SqlDataReader Dim query as String query = "Select * from ENQUIRY where enquiryformno=2" dr = Conn.adpter(query) If dr.Read Then txtPayment.text=dr(0) End If End Sub End class -------- so u better try it... Dipan Patel.
-
-- this is code for connect.vb Imports System.Data.SqlClient Public Class connect Dim str As String Dim conn As New SqlConnection Public ds As DataSet Dim cmd As SqlCommand Public Sub setconnection() str = ConfigurationSettings.AppSettings("connstr") conn.ConnectionString = str End Sub Public Function adpter(ByVal pstr As String) As SqlDataReader Dim s As SqlDataReader conn.Open() cmd = New SqlCommand(pstr, conn) 'cmd.CommandTimeout = 15 s = cmd.ExecuteReader() Return s End Function end class ----- In my "fees.aspx" form Imports System.Data.SqlClient Public Class RegularFees Inherits System.Web.UI.Page Dim Conn As New connect Private Sub SAVE_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SAVE.Click Dim dr As SqlDataReader Dim query as String query = "Select * from ENQUIRY where enquiryformno=2" dr = Conn.adpter(query) If dr.Read Then txtPayment.text=dr(0) End If End Sub End class -------- so u better try it... Dipan Patel.
A number of possibilities. 1. The table is large and it takes the SQL Server a long time to filter on
enquiryformno. Indexing that column might help speed things up. 2. You don't seem to close theSqlDataReader. It is possible that the SQL Server has locks on objects and it is waiting for those locks to be released. So, once you've used your Data Reader remember toCloseit. 3. YouSELECT *yet only get the first column of the first row. You would be better usingSELECT justOneColumnNamewithExecuteScalarrather than use aSqlDataReader. This would automatically solve 2 also.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog
-
A number of possibilities. 1. The table is large and it takes the SQL Server a long time to filter on
enquiryformno. Indexing that column might help speed things up. 2. You don't seem to close theSqlDataReader. It is possible that the SQL Server has locks on objects and it is waiting for those locks to be released. So, once you've used your Data Reader remember toCloseit. 3. YouSELECT *yet only get the first column of the first row. You would be better usingSELECT justOneColumnNamewithExecuteScalarrather than use aSqlDataReader. This would automatically solve 2 also.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog
sir i write the conn.close() in " if dr.read then ...after the dr(0). so not worry about the connection close.. and writing the executescalar in this.. it also gives the same error... i take also only one column name.... Dipan Patel.
-
sir i write the conn.close() in " if dr.read then ...after the dr(0). so not worry about the connection close.. and writing the executescalar in this.. it also gives the same error... i take also only one column name.... Dipan Patel.
I don't see where the connection or Data Reader are being closed.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog
-
sir i write the conn.close() in " if dr.read then ...after the dr(0). so not worry about the connection close.. and writing the executescalar in this.. it also gives the same error... i take also only one column name.... Dipan Patel.
To add. If you dont call dispose on the connection object, It will not pool the connection and will eventually cause timeouts. Thats because they are never really sent back to the pool without calling dispose. 1 line of code equals many bugs. So don't write any!!