Re: datatable - C# Discussion Boards

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

2-Dec-09 10:25

If you are using Controls, it doesn't matter if Controls are public, private or protected

http://i26.photobucket.com/albums/c104/bsaksida/Pic-1.png[^]

That is a link to a pic. That 3 textboxex at the button are in a custom control. I did not change anysthing at custom control expect added 3 text boxex

The code belov was inside OnLoad event

int nCountText = 0;
            foreach (Control ctr in Controls)
            {
                if (ctr is GroupBox)
                {
                    GroupBox gb = ctr as GroupBox;
                    foreach (Control ctrlGB in gb.Controls)
                    {
                        if (ctrlGB is TextBox)
                        {
                            TextBox tb = ctrlGB as TextBox;
                            nCountText++;
                            tb.Text = "This text box is within Group Box with a name: \"" + ctrlGB.Name + "\" and has Text: \"" + gb.Text + "\". Its Textbox number is: " + nCountText.ToString();
                        }
                    }
                }
                else if (ctr is TextBox)
                {
                    TextBox tb = ctr as TextBox;
                    nCountText++;
                    tb.Text = "This TextBox is not Within Group box. Text Box name is: \"" + tb.Name + "\" And it is " + nCountText.ToString() + ". control found";
                }
                else if (ctr is UserControl1)
                {
                    UserControl1 uc = ctr as UserControl1;

                    foreach (Control ctrUc in uc.Controls)
                    {
                        if (ctrUc is TextBox)
                        {
                            ctrUc.Text = "I Made it";
                        }
                    }
                }
            }

PS: If this is too hard, then i suggest go to regular 80 lines to change all TextBox text property

Saksida Bojan2-Dec-09 8:10

2-Dec-09 8:10

Are you using DataSet as container? Do you know how to extract data?

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 = dataSet1.DataTable1[nCount].Text1;
nCount++;
}
}

This is an example how to do it. Based on how you read your data, it may be a different than this example.

I Hope I put you in the Right direction.

How to access fields and values from an XML Database

DaveyM692-Dec-09 11:24

DaveyM69

2-Dec-09 11:24

I believe this is a better way of checking an object's type as there is only the one cast then just a null check...

foreach (Control control in Controls)
{
    TextBox textBox = control as TextBox;
    if(textbox != null)
    {
        // do your textBox thing!
    }
)

Dave

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Why are you using VB6? Do you hate yourself? (Christian Graus)

DTWC_Lawrence2-Dec-09 6:35

DTWC_Lawrence

2-Dec-09 6:35

I have an XML Database that I am loading into a Dataset object in a C# 2008 Windows Forms project. I need to know how to access the individual fields and values. The actual database is not in my control, so I have to use it as given. And I need to be able to offer portions of the values for editing, while hiding others. So I need to how to access each individual field and value. Here is a very tiny mocked up version of the XML code:

<?xml version="1.0"?>
<database version="1.0">
<DatabaseItem name="FirstTable">
<DatabaseSubitem id="1">
<DatabaseField name="Id" value="1" />
<DatabaseField name="Freq" value="151955000" />
<DatabaseField name="Mode" value="Mode:Selective" />
</DatabaseSubitem>
<DatabaseSubitem id="2">
<DatabaseField name="Id" value="1" />
<DatabaseField name="Freq" value="151955000" />
<DatabaseField name="Mode" value="Mode:Selective" />
</DatabaseSubitem>
<DatabaseSubitem id="3">
<DatabaseField name="Id" value="65535" />
</DatabaseSubitem>
</DatabaseItem>
<DatabaseItem name="SecondTable">
<DatabaseSubitem id="0">
<DatabaseField name="access_p" value="500" />
</DatabaseSubitem>
</DatabaseItem>
<DatabaseItem name="ThirdTable">
<DatabaseSubitem id="0">
<DatabaseField name="access_Short" value="500" />
</DatabaseSubitem>
</DatabaseItem>
</database>

If there is an easier way than the Dataset object to process the database, please let me know.

Any help would be most appreciated.
Thanks,
Bruce

Re: How to access fields and values from an XML Database

puri keemti3-Dec-09 23:05

puri keemti

3-Dec-09 23:05

It will create table under dataset having three rows

(1) Id<br />
(2) Freq<br />
(3) Mode

You can access values easily by using

ds.Tables[0].Rows[0][0]  // It will return 1
ds.Tables[0].Rows[0][1]  // 151955000

so on......

System.Diagnostics.Process.Start

CoderOnline2-Dec-09 6:27

CoderOnline

2-Dec-09 6:27

Is There any Other Way..!

System.Diagnostics.Process.Start(url + "?/" + txtFolderName.Text+"&UserName="+txtauthUserName .Text +"&Password="+txtAuthPassword .Text);

I also tried

System.Diagnostics.Process.Start(string,string,secure,string)

but not worked..!

Thanks..!

Re: System.Diagnostics.Process.Start

Saksida Bojan2-Dec-09 6:32

Re: System.Diagnostics.Process.Start....modified

2-Dec-09 6:32

You are attempting to launch URL?
you need url to pass as Arguments not process name

System.Diagnostics.Process.Start("Chrome.exe", "http://www.google.com");

CoderOnline2-Dec-09 6:34

CoderOnline

2-Dec-09 6:34

Saksida Bojan wrote:
System.Diagnostics.Process.Start("Chrome.exe", "http://www.google.com");

I need pass username and password which is in windows authentication..!
like

System.Diagnostics.Process.Start("Chrome.exe", "http://www.google.com&username=xxx&password=XXX");

but in a secure way..!

Re: System.Diagnostics.Process.Start....modified

Saksida Bojan2-Dec-09 6:37