[Message Deleted] - C# Discussion Boards

2-Dec-09 9:45

I have a user control that it has many textboxes and i want to fill textboxes by datatable;
what is the best way for it?
Please somebody help me

Blue_Boy2-Dec-09 9:52

2-Dec-09 9:52

What you have done so far, show your code?
Dude,answers on your previous question,isn't good enough?

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

farokhian2-Dec-09 10:27

2-Dec-09 10:27

I want to fill my textboxes that these textboxes are in a one user control;
in my user control i have a tablelayout and in this tablelayout i put my textboxes ;
when i trace it ,ctr can find the tablelayout in usercontrol but i don't know how can i access to textboxes that exist in tablelayout?

this is my code:

foreach (Control ctr in mycomponent.Controls)
{
if (ctr is TextBox) // This is correct statement for checking if Object is specific type
{
TextBox tb = ctr as TextBox; // This line cast Object to TextBox
tb.Text = "salam"; //dataSet1.DataTable1[nCount].Text1;
nCount++;
}
}

Saksida Bojan2-Dec-09 10:34

2-Dec-09 10:34

farokhian wrote:
i have a tablelayout and in this tablelayout i put my textboxes ;

As Groub box, Panel or Table Layout, it is a Countainer. It can hold Other Controls.

foreach (Control ctr in mycomponent.Controls)
{
   if (ctr is TableLayoutPanel) // This is correct statement for checking if Object is specific type
   {
      TableLayoutPanel tp = ctr as TableLayoutPanel;
      foreach (Control ctrtp in tp.Controls)
      {
         if (ctrtp is TextBox)
         {
            TextBox tb = ctr as TextBox; // This line cast Object to TextBox
            tb.Text = "salam"; //dataSet1.DataTable1[nCount].Text1;
         }
      }
   }
}

farokhian2-Dec-09 10:57

2-Dec-09 10:57

oh my dear;
I reaaly thank you;
Good Luck;
Can you suggest me something to improve my coding?

Saksida Bojan2-Dec-09 12:02

2-Dec-09 12:02

farokhian wrote:
Can you suggest me something to improve my coding?

I am not expert in coding, but i do not know how you code, so it is mearly inpossible (At least for me) to answer that question.

[Message Deleted]

hande542-Dec-09 8:52

hande54

2-Dec-09 8:52

[Message Deleted]

Re: String to datetime

Blue_Boy2-Dec-09 9:05

2-Dec-09 9:05

Have you search on google like first?[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

datatable

farokhian2-Dec-09 6:56

2-Dec-09 6:56

Hi I want to fill about 80 textboxes from datatable.
What is the best way to do this?

Blue_Boy2-Dec-09 7:02

2-Dec-09 7:02

Use SqlDataReader [^]to bind textboxes with value from table.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

farokhian2-Dec-09 7:21

2-Dec-09 7:21

Thanks alot;
I work in windowsApplication;
How can i work with repeater;
I think that repeater doesn't exist in windows!

Blue_Boy2-Dec-09 7:27

2-Dec-09 7:27

Check this link.[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Re: datatable [modified]

Saksida Bojan2-Dec-09 7:09

2-Dec-09 7:09

If you do not want to type for each control you can get all controls from Form

foreach (Control ctr in this.Controls)
{
if (ctr is TextBox)
{
// To do
TextBox tb = ctr as TextBox;
}
}

Edit: Corrected Code

modified on Wednesday, December 2, 2009 2:41 PM

farokhian2-Dec-09 7:24

2-Dec-09 7:24

Thanks alot;
Is it possible for you that how can i bind each textboxes to each cells of datatable after i write this foreach?

Saksida Bojan2-Dec-09 7:38

2-Dec-09 7:38

How do you access your data?
Are you using DataSet or do you create a reader through code?

Those 80 cells, are in Single Row?

farokhian2-Dec-09 7:52

2-Dec-09 7:52

I have 7 datatable that these datatables are the result of 7 select from database;
The total culumns of these datatables are 80.

Blue_Boy2-Dec-09 7:57

2-Dec-09 7:57

I will suggest you to set column alias name same as textboxes names and bind each TextBox (by looping) with value from correspoding coumn name.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

farokhian2-Dec-09 8:16

2-Dec-09 8:16

How can i recognize each textboxes ;
for example i have textbox1 to textbox80 ;How can i move through these textboxes and another question
how can i access the cells of each datatable to set each textbox?

Saksida Bojan2-Dec-09 8:24

2-Dec-09 8:24

farokhian wrote:
How can i recognize each textboxes ;

Control have a Name property

farokhian wrote:
ow can i move through these textboxes

Look at example at my other reply, you go through all Controls on form, not only TextBoxs

how can i access the cells of each datatable to set each textbox?
Depends. Are you using DataSet?

A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 1[^]
That Article has 4 series. It shows how to do it programaticly

farokhian2-Dec-09 8:46

2-Dec-09 8:46

I create my database in sql server 2005 and connect to it in my project;
I execute each select command and put answers in datatable;
At first i want to say "thanks alot for your attention"
now i want to put each cells of datatable in textboxes.
Note:The result of each datatable is one row and total culumns of 7 datatable is 80;

I wanted to test your code but it doesn't work!
for example all the textboxes.text must have text "hellow" but in foreach loop it just check one of the controlls( it is a panel)and see that it is not textbox and then leave the loop!?

int nCount = 0;
foreach (Control ctr in this.Controls)
{
if (ctr is TextBox) // This is correct statement for checking if Object is specific type
{
TextBox tb = ctr as TextBox; // This line cast Object to TextBox
tb.Text = "hellow";
nCount++;
}
}

Saksida Bojan2-Dec-09 8:55

2-Dec-09 8:55

In that example it would go like this:

foreach(Control ctr in this.Controls)
{
   if (ctr is Panel)
   {
      Panel p = ctr as Panel;
      // Now another foreach and loop all controls within Panel.Controls

      foreach(Control ctrP in p.Controls)
      {
         if (ctrP is TextBox)
         {
            TextBox tb = ctr as TextBox; // This line cast Object to TextBox
            tb.Text = "hellow"; 
         }
      }
   }
}

farokhian2-Dec-09 9:18

2-Dec-09 9:18

Excuse me sir; Frown | :(

Most of my textboxes in a usercontrol ;
How can i set the value of each these textboxes?
I mean that what should i put in foreach ? place:(Control ctr in ?.Controls)
i write my user control name but it doesn't work?
Note: i set the modifier of each textboxes "public"
and now i have access to the textboxes.text

can you tell me that what is the code of addressing to one cells of datatable?

Blue_Boy2-Dec-09 9:34

2-Dec-09 9:34

If is impossible to loop all TextBoxes then refer one-by-one by writing 80 lines of code (with which I dont agree because if you try to implement Saksida Bojan's answer you can have proper solution)

farokhian wrote:
addressing to one cells of datatable?

datatablename.Rows[0][0]

//Rows[0][0], first[0] means rows and second [0] means column

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

Saksida Bojan2-Dec-09 10:25