|
|
|
Hi
I want to fill about 80 textboxes from datatable.
What is the best way to do this?
|
|
|
|
|
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
|
|
|
|
|
Thanks alot;
I work in windowsApplication;
How can i work with repeater;
I think that repeater doesn't exist in windows!
|
|
|
|
|
|
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)
{
TextBox tb = ctr as TextBox;
}
}
Edit: Corrected Code
modified on Wednesday, December 2, 2009 2:41 PM
|
|
|
|
|
Thanks alot;
Is it possible for you that how can i bind each textboxes to each cells of datatable after i write this foreach?
|
|
|
|
|
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?
|
|
|
|
|
I have 7 datatable that these datatables are the result of 7 select from database;
The total culumns of these datatables are 80.
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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++;
}
}
|
|
|
|
|
In that example it would go like this:
foreach(Control ctr in this.Controls)
{
if (ctr is Panel)
{
Panel p = ctr as Panel;
foreach(Control ctrP in p.Controls)
{
if (ctrP is TextBox)
{
TextBox tb = ctr as TextBox;
tb.Text = "hellow";
}
}
}
}
|
|
|
|
|
Excuse me sir;
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?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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)
{
TextBox tb = ctr as 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.
|
|
|
|
|
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)
{
}
)
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)
|
|
|
|
|
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
|
|
|
|
|
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]
ds.Tables[0].Rows[0][1]
so on......
|
|
|
|
|
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..!
|
|
|
|
|
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");
|
|
|
|
|
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..!
|
|
|
|