TextBox and Repeater does not work when used together in C#

Question

I was using Repeater in c# and it was able to display all the data, recently i added Multiline TextBox and after that the Repeater value is not getting displayed. But if i comment TextBoxLogInfo then the Repeater display all the data.

Is there way to show data for both same time.

Code in c#
------------
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
//Assign to your textbox here
TextBoxLogInfo.Text = sdr["LOG_DETAILS"].ToString();
}

//DataBinding Repeater
Repeater1.DataSource = sdr;
Repeater1.DataBind();

Your help will be highly appreciated

Thanks

Soft Corner · Answer

Hi Harish You are Facing this problem bcz in your code there is only one DataReader sdr once all data read at one stage the other control couldnt find the data. so after while loop close your DataReader i.e sdr.Close() & Execute the same datareader. sdr = cmd.ExecuteReader(); //DataBinding Repeater Repeater1.DataSource = sdr; Repeater1.DataBind(); Hope this will help you.

harish main · Answer

Thanks for your response. Tips you gave resolved and now it is working fine.

Suthish Nair · Answer

Is this a duplicate post? If the query got resolved then mark the post that helped you as Answer so will be helpful for others. Otherwise if you got the solution please share with us.

hamida khanam · Answer

Thanks Shrikant I was facing the same problem but after acting on your advise i got the solution.This is the solution of the problem.Thanks for helping.