Click here to Skip to main content
15,918,268 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionConverting code Pin
SirNathaniel1-Aug-07 2:03
SirNathaniel1-Aug-07 2:03 
AnswerRe: Converting code Pin
BasharatAli1-Aug-07 2:18
BasharatAli1-Aug-07 2:18 
GeneralRe: Converting code Pin
SirNathaniel1-Aug-07 6:53
SirNathaniel1-Aug-07 6:53 
AnswerRe: Converting code Pin
Dave Doknjas1-Aug-07 14:04
Dave Doknjas1-Aug-07 14:04 
QuestionCannot open any more Tables Pin
Khan.Bangash1-Aug-07 1:15
Khan.Bangash1-Aug-07 1:15 
AnswerRe: Cannot open any more Tables Pin
_mubashir1-Aug-07 1:59
_mubashir1-Aug-07 1:59 
GeneralRe: Cannot open any more Tables Pin
Khan.Bangash1-Aug-07 2:04
Khan.Bangash1-Aug-07 2:04 
GeneralRe: Cannot open any more Tables Pin
_mubashir1-Aug-07 2:13
_mubashir1-Aug-07 2:13 
OK, see this
<br />
For i = 0 To ordAsc.Count - 1<br />
SelectQuery = "SELECT customers.customer_id,customers.customer_type FROM customers INNER JOIN cust_order ON customers.customer_id=cust_order.customer_id WHERE cust_order.order_id=" & ordAsc(i) & ""<br />
command = New OleDbCommand(SelectQuery, Conn)<br />
total = command.ExecuteReader()<br />
While total.Read()<br />
cstAsc.Add(total.GetValue(0))<br />
typAsc.Add(total.GetValue(1))<br />
End While<br />
Next<br />

Here you are looping thru some list and executing reader without closing it. That is why it is throwing exception. Make sure you close the reader after you finish fetching records.




Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.

GeneralRe: Cannot open any more Tables Pin
Khan.Bangash1-Aug-07 2:22
Khan.Bangash1-Aug-07 2:22 
GeneralRe: Cannot open any more Tables Pin
_mubashir1-Aug-07 2:27
_mubashir1-Aug-07 2:27 
GeneralRe: Cannot open any more Tables Pin
Khan.Bangash1-Aug-07 2:41
Khan.Bangash1-Aug-07 2:41 
GeneralRe: Cannot open any more Tables Pin
_mubashir1-Aug-07 5:34
_mubashir1-Aug-07 5:34 
GeneralRe: Cannot open any more Tables Pin
Khan.Bangash1-Aug-07 5:53
Khan.Bangash1-Aug-07 5:53 
GeneralRe: Cannot open any more Tables Pin
_mubashir1-Aug-07 6:01
_mubashir1-Aug-07 6:01 
Questionexception classes Pin
pavanteja1-Aug-07 0:53
pavanteja1-Aug-07 0:53 
AnswerRe: exception classes Pin
kubben1-Aug-07 1:52
kubben1-Aug-07 1:52 
GeneralRe: exception classes Pin
pavanteja1-Aug-07 2:10
pavanteja1-Aug-07 2:10 
QuestionPage Unload ... Pin
itzmevishu1-Aug-07 0:49
itzmevishu1-Aug-07 0:49 
AnswerRe: Page Unload ... Pin
Christian Graus1-Aug-07 1:26
protectorChristian Graus1-Aug-07 1:26 
GeneralRe: Page Unload ... Pin
itzmevishu1-Aug-07 6:11
itzmevishu1-Aug-07 6:11 
Questioncomes to home page Pin
Raghvendra Kumar Roy1-Aug-07 0:30
Raghvendra Kumar Roy1-Aug-07 0:30 
AnswerRe: comes to home page Pin
Christian Graus1-Aug-07 0:34
protectorChristian Graus1-Aug-07 0:34 
GeneralRe: comes to home page Pin
Raghvendra Kumar Roy1-Aug-07 0:54
Raghvendra Kumar Roy1-Aug-07 0:54 
QuestionReplace cr/nl with html break tag Pin
jc.net1-Aug-07 0:24
jc.net1-Aug-07 0:24 
AnswerRe: Replace cr/nl with Pin
Christian Graus1-Aug-07 0:35
protectorChristian Graus1-Aug-07 0:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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