|
Radha27 wrote: The thing is i have to create ten rows of controls(dropdownlist,textbox)
Is each row will contain Dropdown list and text box ???
if yes, then create a function the will generate one DropdownList and Textbox , Call that 10 times at form load and you can call the same on button click.
If it is not clear, then just give me the breif idea that what you are trying to do !!!
I will surely help you, if i Can !!!!
|
|
|
|
|
Thank you Abhijit.
Let me explain my scenario.
Basically this is for one application's Data Entry form.Each row will contain 2 Dropdown lists and 8 textboxes.10 rows shuold be loaded by default i mean at form load and a Addmore button will be there. If i want to add more data, additional rows will be added by clicking Addmore button.
(Dropdown list values shold be loaded from database.)
Can u help me?
(And i tried like what u have explained in ur previous post. But it doesn't work. Only one row is being loaded.)
Thanks & Regards,
Radha
|
|
|
|
|
> Create Runtime Table to maintain the allignment
>> Add Dropdownlist and Textbox inside each
[ That will create also in runtime ]
MAke this thing inside a function !!!
you have to use Table , Dropdownlist , and Textbox Classes Object . And it should be Array of Object !!!!
>>> Add Event Handler when you required !!!!
>>>> For Database Data, When you create the Dropdown list , use D.Items.Add() on that function itself.
>>>>> And on Button Click Call the same Function .....
--------------------------
For your reference!!
Dynamic Array of Button[^]
--------------------------
This will just add one row with that table..........
This is the simpliest IDea ....
One more idea ..... that you can create one Custom Web user control ....(ascx) file......
>>>>>>>
Regarding The Tricks ::: It was not about adding Column or anything else...
This is the .NET general Trick !!!!
e.g
when your write a if statement ....if have to write
if(condition)<br />
{<br />
{<br />
else<br />
{ <br />
}
Now just try this..
write if and press TAB
Check what the difference,similarly try with switch, for, while statement . and where i am talking there it will do the same thing...
----
Check my latest article ....
|
|
|
|
|
Abhijit, Please check the code shown below and help me;
for (int i = 0; i < 10; i++)
{
Text1[i] = new TextBox();
//b[i].ID = i; //Can use ID
Text1[i].ID = "Text1" + i.ToString();
Text1[i].TextMode = TextBoxMode.MultiLine;
c1.Controls.Add(Text1[i]);
}
Here, i tried to add the text box to Table cell c1.
But, i dont get the result.
Did i miss anything here?
Thanks & Regards,
Radha
|
|
|
|
|
Radha27 wrote: Did i miss anything here?
Did you add the table inside the page ?
|
|
|
|
|
Yes, i do.
Table tblData = new Table();
TableRow r = new TableRow();
TableCell c1 = new TableCell();
...
c1.Controls.Add(Text1[i]);
r.Cells.Add(c1);
tblData.Rows.Add(r);
Thanks & Regards,
Radha
|
|
|
|
|
where did you added the Table into page????
use
this.Control.Add(tblData);
if still problem let me know or if you solve then also inform me !!!!
|
|
|
|
|
Sorry i have a panel and add that table to panel.
Panel1.Controls.Add(tblData);
But still it doesn't work.
Thanks & Regards,
Radha
|
|
|
|
|
ok, then wait for few minutes,,,, and let me do this ....!!!!
|
|
|
|
|
Thanks a lot.
Thanks & Regards,
Radha
|
|
|
|
|
In Designed View Dragged and Drop a ASP.NET TAble Control From ToolBox
-----
Changed The ID : tblRunTime
--------------
Copy this code to page load !!!!
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
<br />
for ( int i = 0; i < 10; i++ ) <br />
{ TableRow tr = new TableRow(); <br />
TableCell td1 = new TableCell(); <br />
DropDownList _dr = new DropDownList();<br />
_dr.ID = "lbl" + i.ToString();<br />
_dr.Items.Add("DropDownList " + i.ToString()); <br />
td1.Controls.Add(_dr); <br />
TableCell td2 = new TableCell(); <br />
TextBox _text = new TextBox(); <br />
_text.ID = "TextBox " + i.ToString(); <br />
td2.Controls.Add(_text); <br />
tr.Cells.Add(td1); <br />
tr.Cells.Add(td2);<br />
tblRunTime.Rows.Add(tr);<br />
}<br />
}
---
Run It..........
------
--------
Check my latest Article in codeproject !!!!
Let me know when done !!!!
|
|
|
|
|
Hope this is now working for you !!!
|
|
|
|
|
Thanks a lot.
Its working now.
Thanks & Regards,
Radha
|
|
|
|
|
|
Sorry I am very much new to .Net.. still i have doubt in this.. How can i insert those to Database.. i mean directly using loop or in some other way, as it is not compulsary to add values for all those 10 records.. In case if i enter values for only 2 records how can i retrieve those? Please help me..
Thanks & Regards,
Radha
|
|
|
|
|
just read reocrds on Datareader , now
while(datareader!=null)
{
_dr.items.Add(datareadr[index].text);
}
This is a concept , you can try this,
|
|
|
|
|
Thanks Abhijit, But i did like this.
_dr.DataSource = GetData();
...
public DataSet GetData()
{
...
}
What i asked is.. when i click Submit button, all the 10 rows are inserted even if i enter Data only for 2 rows. I am inserting records based on the table rows count.
protected void btnSubmit_Click(object sender, EventArgs e)
{
int j = tblRunTime.Rows.Count;
for (int c = 0; c < j; c++)
{
string query = " INSERT INTO Time VALUES( ";
query = query + " '" + Request.Form["_dr1" + c.ToString()] + "', ";
query = query + " '" + Request.Form["_dr2" + c.ToString()] + "', ";
query = query + " '" + Request.Form["text1" + c.ToString()] + "', ";
...
query = query + " '" + Request.Form["text8" + c.ToString()] + "', ";
query = query + " '" + f_date_b.Value + "'";
query = query + " )";
}
So, how i can solve this?
Please help me.
Thanks & Regards,
Radha
|
|
|
|
|
Let me know if you have still any problem !!! i will check on this on tomorrow!!!
Good night !!!
|
|
|
|
|
create a table at runtime add rows into it and afterwards add the controls into the cells.
similarly u can do the same to create the single or more then one rows at run time.
all u have to do is to find the table id at runtime.
Hope this will help u.
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
Yup, this is also a greate idea !!!
|
|
|
|
|
Thank u Pankaj.
I tried this. Even, one row is loaded by default. and if i click to add a new row, a new row is added but first row disappears.
ddlActivity.ID = "ddlActivity" + i;
ddlActivity.Visible = true;
...
Text1.ID = "Text1" + i;
Text1.Visible = true;
Text1.Width = 40;
...
Table tblForm = new Table();
tblForm.ID = "tblform";
TableRow r = new TableRow();
r.ID = "r" + i;
TableCell c8 = new TableCell();
TableCell c9 = new TableCell();
TableCell c = new TableCell();
TableCell c1 = new TableCell();
TableCell c2 = new TableCell();
TableCell c3 = new TableCell();
TableCell c4 = new TableCell();
TableCell c5 = new TableCell();
TableCell c6 = new TableCell();
TableCell c7 = new TableCell();
c8.Controls.Add(ddl1);
r.Cells.Add(c8);
c9.Controls.Add(ddl2);
r.Cells.Add(c9);
c.Controls.Add(Text1);
r.Cells.Add(c);
c1.Controls.Add(Text2);
r.Cells.Add(c1);
c2.Controls.Add(Text3);
r.Cells.Add(c2);
c3.Controls.Add(Text4);
r.Cells.Add(c3);
c4.Controls.Add(Text5);
r.Cells.Add(c4);
c5.Controls.Add(Text6);
r.Cells.Add(c5);
c6.Controls.Add(Text7);
r.Cells.Add(c6);
c7.Controls.Add(Text8);
r.Cells.Add(c7);
tblForm.Rows.Add(r);
plh.Controls.Add(tblForm);
I added controls like this. Did i miss anything here??
Thanks & Regards,
Radha
|
|
|
|
|
If u r adding the table dynamically , then keep in mind that the memory of that table control is not being washed out(I mean use the access modifier for the table control at the class level.)
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
Hi all
I have 2 Datatable
the fist (dtUser): have column UserID, Name, Address (10 rows)
the second(dtOrder): have column OrderID, UserID (5)
And 2 datatable haven't relationship
How can i "Select * from dtOrder A LEFT JOIN dtUser B ON A.UserID = B.UserID" in new datatable by Asp.net ??
|
|
|
|
|
Your question has nothing to do with ASP.NET.
However, you can define parent/child relationships between DataTables by using the DataRelation[^] class.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
SELECT *
FROM dbo.dtOrder INNER JOIN
dbo.dtuser ON dbo.dtOrder.UserID = dbo.dtuser.UserID
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|