|
Hi,
I want to copy one datareader dr to another datareader dr1.
I am using while loop to get one by one value from dr
and I want to copy into dr1.
How can I do this.
Thanks
|
|
|
|
|
|
I am binding dr1 to datalist in which image will be there.
I am fetching one by one record from the database where while loop is there and then depending upon that value it taken from the database as dr1 and then I am binding to the datalist dgBindImage.
But Datalist which contains images that display last image.
That overwrite the previous one.
So I want to add or copy dr1 to another dr2 so that direct whole dr2 can be bind to datalist.
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, cn1);
cn1.Open();
dr1 = cmd1.ExecuteReader();
SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
dr1.Close();
cn1.Close();
}
dgBindImage.DataSource = dr1;//dgBindImage is Datalist
dgBindImage.DataBind();
}
|
|
|
|
|
I presume this is in relation to your previous post.
Try setting the CommandBehavior on the inner DataReader:
SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
|
|
|
|
|
Thanks for the information.But
The Problem is like below
I am binding dr1 to datalist in which image will be there.
I am fetching one by one record from the database where while loop is there and then depending upon that value it taken from the database as dr1 and then I am binding to the datalist dgBindImage.
But Datalist which contains images that display last image.
That overwrite the previous one.
So I want to add or copy dr1 to another dr2 so that direct whole dr2 can be bind to datalist.
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, cn1);
cn1.Open();
dr1 = cmd1.ExecuteReader();
SqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
dr1.Close();
cn1.Close();
}
dgBindImage.DataSource = dr1;//dgBindImage is Datalist
dgBindImage.DataBind();
}
|
|
|
|
|
The line of code from my previous post was a demonstration of how to set a CommandBehavior on the ExecuteReader method. Copying and pasting it directly into your code in this way will have no effect. You need to apply it to your datareader.
To solve your problem with overwriting the previous image, you need to create a new dgBindImage control for each iteration of the loop. You can do this by nesting it inside another list control and calling your code inside the row data bound event of the list control.
|
|
|
|
|
Hi All,
How to use the splitter control in web form. I'm using asp.net 2.0 How to do this? Give me any sample.
I searched in google, I found free vwd-cms, But I want to create it.
How to do this?
Thanks in advance
|
|
|
|
|
Check out this article: ASP.NET Splitter Bar[^]. By looking through the javascript file VwdCmsSplitterBar.js you get some idea of how to create it.
|
|
|
|
|
Thanks.I saw that one.Is it a thirdparty s/w?
Shall I use in my application?
|
|
|
|
|
Have a read of the license associated with the article, there is a link near the end of the article.
|
|
|
|
|
Hi all
i have gird view set auto generate fields is true
How can i visible column on gridview. So dont remove column on Datatable.
|
|
|
|
|
Hi,
I got the following error while binding radscheduler to a Sqldatasource.Please solve this problem for me...
DataBinding: 'System.Char' does not contain a property with the name 'ID'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: DataBinding: 'System.Char' does not contain a property with the name 'ID'.
Source Error:
Line 17:
Line 18: Me.RadScheduler1.DataSource = "SqlDataSource1"
Line 19: RadScheduler1.DataBind()
Line 20: RadScheduler1.DataSource = String.Empty
Line 21
thank you
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
