Wrox Programmer Forums
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 23rd, 2007, 03:54 AM
Authorized User
Join Date: Nov 2006
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to akhilhp
Default SQL Error.

I have prepared and submitted a site to my head office. The Problem is when my boss is trying to run the s/w he is getting following error :

Timeout Expired. The Time out period elapsed before completion of the operation or the server is not responding.

I have follwing code and the error is occuring at the line underlined here :
            SQLStr = "Select * from cTable"
            Con = New SqlConnection(MainConStr)
            Dim sqladap As New SqlDataAdapter(SQLStr, Con)
            Dim b, i As Integer

            Me.DropDownList1.Items.Add("------Select Court---------")
            Me.RequiredFieldValidator1.InitialValue = "------Select Court---------"
           [u] b = sqladap.Fill(dataset, "courts")</u>

Please Help !!!
Old January 23rd, 2007, 08:46 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi

hi there...

you have a time out, maybe too much data in the table???

maybe you can't connect to the database??

did you try others things???



================================================== =========
Read this if you want to know how to get a correct reply for your question:
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server Reg. SQL Server does not exist error Arsi SQL Server 2000 1 June 11th, 2008 11:20 AM
error sql! hamai VS.NET 2002/2003 0 April 20th, 2007 04:14 PM
SQL Error fs22 ASP.NET 2.0 Basics 1 August 2nd, 2006 01:07 AM
ANY HELP WITH SQL??? ERROR koco ASP.NET 1.0 and 1.1 Basics 1 June 8th, 2006 09:13 AM
SQL ERROR IN C# divyak02 C# 5 December 11th, 2005 12:35 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.