|
Hi,
From the Following Code when Executing the statement
dr1 = cmd1.ExecuteReader();
It shows me error that There is already an open DataReader associated with this Command which must be closed first.
cmd = new SqlCommand("SELECT * from Product_price where category_id=" + CatID, cn);
cn.Open();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
string PID = dr["product_id"].ToString();
cmd1 = new SqlCommand("SELECT * from t_Product where product_id=" + PID, cn);
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
else
{
dr1 = cmd1.ExecuteReader();
dgBindImage.DataSource = dr1;
dgBindImage.DataBind();
}
}
}
How to solved this error
|
|
|
|
|
A DataReader should be closed when you are finished using it, to free up resources.
When you read the first row you are opening dr1 and binding to dgBindImage, that DataReader is still open and using the cmd1 object when you read the second row.
To solve the error you need to close the DataReader when you are finished with it.
|
|
|
|
|
But Every time I want the value from dr
|
|
|
|
|
That is fine for the first DataReader which you have called "dr".
For the second DataReader, which you have called "dr1", each iteration of the loop is a separate call of cmd1.ExecuteReader(); so you need to close off this reader before calling it again.
|
|
|
|
|
Requirement:
Ultrawebgrid has a checkbox,
outside the Ultrawebgrid, "Asp button"(default visible false) is available
once checkbox selected in Ultrawebgrid "Asp button" should be visible
problem: iam not able to find the checkbox in Ultrawebgrid in Databound event
please help me out...
regards
kiran
venkat
|
|
|
|
|
The CheckBox will have an Id to allow you to identify it in the server code.
In the Databound event you can access it like this:
CheckBox myCheckbox = (CheckBox)e.Item.FindControl("CheckboxId");Also, if you want the checking of the CheckBox to cause a postback ensure that AutoPostBack is set on the control like this: AutoPostBack="True"
|
|
|
|
|
Thanks for reply
i guess the code u wrote is for gridview 0r datagrid
iam looking for ultrawebgrid
venkat
|
|
|
|
|
Member 1677774 wrote: Ultrawebgrid has a checkbox,
outside the Ultrawebgrid, "Asp button"(default visible false) is available
So raise this on the vendors forums. They have staff that are paid to deal with issues in their products.
|
|
|
|
|
I have HP 6767 (with vista OPerating system) NoteBook and SQL Server 2005 inbuild in opertaing system . but i can not access sql sever2005 so how i can access sql Please help me.
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
|
thanku Bossssss
one more fever for me sir please provied me some url where i download SQL Server 2005 Express Edition.
Thanku
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
You can download it from the url in my previous post.
|
|
|
|
|
Thanku sir its working
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
|
ok Sir I gted url from ur post Thanks
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
|
there iis some thing wrong what we do? my dear
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
I see that you have posted this question on the SQL / ADO / ADO.NET forum also, you should not do this.
People here offer their assistance for free so please abide by the rules.
|
|
|
|
|
A home Without People thats not Home that Like graveyard. so posted here
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
Piyush Vardhan Singh wrote: A home Without People thats not Home that Like graveyard
A metaphor of Cantona-esque surrealism. Definitely up there with seagulls following the trawler...
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
pmarfleet wrote: A metaphor of Cantona-esque surrealism. Definitely up there with seagulls following the trawler...
And you owe me a new monitor for the snortage that ensued.
|
|
|
|
|
Piyush Vardhan Singh wrote: there iis some thing wrong what we do? my dear
You've posted this on 4 forums. That's not good. And please don't call me dear. You're creeping me out.
|
|
|
|
|
Hi friends..
I manually code to get tables holding values returned from database in an .aspx page.Now i need to clear those tables when i click the clear button which i have in my page..how to to it..someone help in this regard..
Regards,
Balaguru
|
|
|
|
|
I'm not sure at what level you are manually coding to "get tables holding values" but if you are databinding a control to a datasource you can clear that control by binding to a null value.
If you are dynamically writing out HTML to the page then you should write it out to a Literal control and to clear it, you can assign it an empty string.
|
|
|
|
|
Dear Bright..
How to write the HTML to a literal control and clear it..? Can u just give me some sample code to do that..?
Thanks & Regards,
Balaguru
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
