About placeholder controls to numbering the controls

Question

1.00/5 (1 vote)

See more:

I have a place holder in a webpage and one TextBox and one DropDownlist. Textbox is for entering quantity of products and DropDownList is for product names. when i am selecting a product name(suppose RAM)from the DropDownList and suppose i write int the text box 3 as the quantitity of products. There is a OK button also when i m clicking the ok button 3 text boxes with levels are generated in the placeholder as given below:-
RAM textbox
RAM textbox
RAM textbox

But My requirement is it should display as

RAM1 textbox
RAM2 textbox
RAM3 textbox

Again whatever we write in this textboxes are the serial numbers and that are must be updated in a database. Kindly help to solve this problem.

Posted 9-Feb-14 18:33pm

Member 10578683

Add a Solution

Comments

Dinesh.V.Kumar 10-Feb-14 1:00am

Can you paste the code where you are generating the "RAM textbox" part? This may help us solve your problem...

Regards

Member 10578683 10-Feb-14 6:34am

protected void Button1_Click(object sender, EventArgs e)
{
if (txtQuantity.Text != "")
{
for (int i = 0; i < Convert.ToInt16(txtQuantity.Text); i++)
{
Label la = new Label();
la.Text = ddlProductName.SelectedItem.Value;
la.ID = "abc" + i.ToString();

PlaceHolder1.Controls.Add(la);
//la = FindControl(String.Format(i)) as Label;

TextBox tb1 = new TextBox();
tb1.ID = "ghj" + i.ToString();
PlaceHolder1.Controls.Add(tb1);
PlaceHolder1.Controls.Add(new LiteralControl("<br/>"));

}
}
}
}

Member 10578683 10-Feb-14 6:35am

RAM1 RAM2 are Labels not text boxes.

Dinesh.V.Kumar 10-Feb-14 6:37am

Try this
la.Text = ddlProductName.SelectedItem.Value + i.ToString();

Regards,

Member 10578683 10-Feb-14 6:50am

Thanks My friend it is working

Member 10578683 10-Feb-14 6:52am

I have another problem how will i insert the value of the text boxes in the placeholder in the database

Dinesh.V.Kumar 10-Feb-14 7:22am

try this
string tb1Val=string.Empty;
TextBox txtBox1= (TextBox)PlaceHolder1.FindControl("tb1");
tb1Val = txtBox1.Text.Trim();
You can use this value and send this to the insert query/sp to save it to database.

Regards

Member 10578683 10-Feb-14 8:15am

protected void btnSave_Click(object sender, EventArgs e)
{

string entryDate = lblCurrentDate.Text;
string customerName = ddlCName.SelectedItem.Value;
string customerLocation = ddlCLocation.SelectedItem.Value;
string GatePassNo = txtGatePass.Text;
ViewState["GatePassNo"] = GatePassNo;
string productName = ddlProductName.SelectedItem.Value;
int quantity = Convert.ToInt32(txtQuantity.Text);
con.Open();
string qryClientID = "select ID from Customer_Details where Customer_Name='" + customerName + "' and Customer_Location='" + customerLocation + "'";
int clientID = du.ExecuteSqlScaler(qryClientID);

string qryCustomer_Name = "select Customer_name from Customer_Details where Customer_name='" + ddlCName.SelectedItem.Value + "' and Customer_Location='" + customerLocation + "'";
SqlCommand comma = new SqlCommand(qryCustomer_Name, con);
comma.ExecuteNonQuery();
con.Close();

// string serials = txtSerials.Text;
string status = "Under Repair";
//string qryCheck = "Select GatePassNo from Product_Details ";
//string[] serialArray = serials.Split(';');

for (int i = 0; i < quantity; i++)
{
try
{

string tb1Val=string.Empty;
TextBox txtBox1= (TextBox)PlaceHolder1.FindControl("tb1");
tb1Val = txtBox1.Text.Trim();
con.Open();

string qryInsertProduct = "insert into Product_Details(GatePassNo,ClientID,Product_Name,SerialNo,Status,CheckIN_Date ,Customer_Name, Customer_location) values('" + GatePassNo + "','" + clientID + "','" + productName + "','" +tb1Val + "','" + status + "','" + entryDate + "','" + ddlCName.SelectedItem.Value + "','" + ddlCLocation.SelectedItem.Value + "')";
SqlCommand comInsertProduct = new SqlCommand(qryInsertProduct, con);
comInsertProduct.ExecuteNonQuery();
con.Close();

}

catch (Exception ex)
{

}

finally
{
if (con.State == ConnectionState.Open)
{
con.Close();

}
}
}
txtQuantity.Text = "";
// txtBox1.Text = "";
gdvProducts.Visible = true;
PopulateGridView();

}

//}
I have this Code but the save button is not working. Kindly help

Dinesh.V.Kumar 10-Feb-14 8:20am

Did u check what value you got in tb1Val variable? Can you post that too?

Member 10578683 10-Feb-14 8:25am

When i click the save button i didn't get anything. gridview also not generating

Dinesh.V.Kumar 10-Feb-14 8:35am

Place a breakpoint in save click event and debug and check if the break point is getting hit...

Regards

Member 10578683 10-Feb-14 8:48am

It is not executing the line int quantity = Convert.ToInt32(txtQuantity.Text);

Dinesh.V.Kumar 10-Feb-14 8:52am

It could be because the txtQuantity is wrong name for the text box...Pls check that..

Member 10578683 11-Feb-14 0:53am

It is showing format Exception is unhand-led by user code. text box name is right. this is my code please check
protected void btnSave_Click(object sender, EventArgs e)
{

string entryDate = lblCurrentDate.Text;
string customerName = ddlCName.SelectedItem.Value;
string customerLocation = ddlCLocation.SelectedItem.Value;
string GatePassNo = txtGatePass.Text;
ViewState["GatePassNo"] = GatePassNo;
string productName = ddlProductName.SelectedItem.Value;
int quantity = int.Parse(txtQuantity.Text);
con.Open();
string qryClientID = "select ID from Customer_Details where Customer_Name='" + customerName + "' and Customer_Location='" + customerLocation + "'";
int clientID = du.ExecuteSqlScaler(qryClientID);

string qryCustomer_Name = "select Customer_name from Customer_Details where Customer_name='" + ddlCName.SelectedItem.Value + "' and Customer_Location='" + customerLocation + "'";
SqlCommand comma = new SqlCommand(qryCustomer_Name, con);
comma.ExecuteNonQuery();
con.Close();

// string serials = txtSerials.Text;
string status = "Under Repair";
//string qryCheck = "Select GatePassNo from Product_Details ";
//string[] serialArray = serials.Split(';');
string tb1Val = string.Empty;
for (int i = 0; i < quantity; i++)
{
try
{

TextBox txtBox1= (TextBox)PlaceHolder1.FindControl("tb1");
tb1Val = txtBox1.Text.Trim();
con.Open();

string qryInsertProduct = "insert into Product_Details(GatePassNo,ClientID,Product_Name,SerialNo,Status,CheckIN_Date ,Customer_Name, Customer_location) values('" + GatePassNo + "','" + clientID + "','" + productName + "','" +tb1Val + "','" + status + "','" + entryDate + "','" + ddlCName.SelectedItem.Value + "','" + ddlCLocation.SelectedItem.Value + "')";
SqlCommand comInsertProduct = new SqlCommand(qryInsertProduct, con);
comInsertProduct.ExecuteNonQuery();
con.Close();

}

catch (Exception ex)
{

}

finally
{
if (con.State == ConnectionState.Open)
{
con.Close();

}
}
}
txtQuantity.Text = "";
// txtBox1.Text = "";
gdvProducts.Visible = true;
PopulateGridView();

Member 10578683 11-Feb-14 1:00am

whatever value i m putting in the dynamically generated text boxes that are not updating in the gridview

Member 10578683 11-Feb-14 1:45am

Page Language="C#" AutoEventWireup="true" CodeFile="CheckIn.aspx.cs" Inherits="CheckIn"
MasterPageFile="~/MasterPage.master" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
<table cellpadding="3" cellspacing="3" border="0" width="100%" align="left">
<tr style="background-color: #EEEEEE;">
<td colspan="4">
<asp:Label ID="lblHeading" runat="server" Text="Material in from customer to FSPL">
</td>
</tr>
<tr>
<td style="width: 25%;">
<asp:Label ID="lblH1" runat="server" Text="Current date & time">
</td>
<td style="width: 25%;">
<asp:Label ID="lblH2" runat="server" Text="Customer Name">

</td>
<td style="width: 25%;">
<asp:Label ID="lblH3" runat="server" Text="Customer Location">

</td>
<td style="width: 25%;">
<asp:Label ID="lblH4" runat="server" Text="Gate Pass No">
</td>
</tr>
<tr>
<td style="width: 25%;">
<asp:Label ID="lblCurrentDate" runat="server" Text="">
</td>
<td style="width: 25%;">
<asp:DropDownList ID="ddlCName" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlCName_SelectedIndexChanged">

</td>
<td style="width: 25%;">
<asp:DropDownList ID="ddlCLocation" runat="server">

</td>
<td style="width: 25%;">
<asp:TextBox ID="txtGatePass" runat="server">
</td>
</tr>
<tr>
<td colspan="4">

</td>
</tr>
<tr>
<td>
<asp:Label ID="lblProductName" runat="server" Text="Product Name">
</td>
<td colspan="3">
<asp:DropDownList ID="ddlProductName" runat="server">

</td>
</tr>
<tr>
<td>
<asp:Label ID="lblQuantity" runat="server" Text="Quantity">
</td>
<td colspan="3">
<asp:TextBox ID="txtQuantity" runat="server" AutoPostBack="False"
>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblSerials" runat="server" Text="Serial Numbers">
</td>
<td colspan="3">
<asp:PlaceHolder ID="PlaceHolder1" runat="server">
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="OK" />
<br />
</td>
</tr>
<tr>
<td colspan="2">
<asp:Button ID="btnSave" runat="server" Text="Add" Width="100px" OnClick="btnSave_Click" />
</td>
<td colspan="2">
<asp:Button ID="btnreset" runat="server" Text="Save" Width="100px" OnClick="btnreset_Click" />
</td>
</tr>
<tr>
<td colspan="4">

</td>
</tr>
check this also

Member 10578683 11-Feb-14 1:46am

Dinesh.V.Kumar 11-Feb-14 2:02am

Instead of int.Parse(txtQuantity.Text);
try
Convert.ToInt32(txtQuantity.Text.Trim());

Regards,

Member 10578683 11-Feb-14 2:21am

No it is not working. u please check the asp:code for place holder textbox

Dinesh.V.Kumar 11-Feb-14 2:40am

As already mentioned
the below code will work to get the value from textbox placed in a place holder
string tb1Val=string.Empty;
TextBox txtBox1= (TextBox)PlaceHolder1.FindControl("tb1");
tb1Val = txtBox1.Text.Trim();

As for your error...I can just point out the solution as I do not have the db and it will take time to reproduce the error. Please paste the detailed error message so that I can try to help you..

Regards

Member 10578683 11-Feb-14 3:02am

<asp:TextBox ID="txtBox1" runat="server" Text='<%# Bind("tb1") %>'>
i have written this code for the text box in place holder. is it right

Dinesh.V.Kumar 11-Feb-14 3:18am

Pls tell me clearly what you want to do with the text box in the place holder. If you have to get the value from the text box use my code...if you have to set a value to the text box dynamically what you are doing is correct..but check the "tb1" you are using to bind...If it is not declared/used earlier, it will throw error.

Hope this helps!!

Regards

Member 10578683 11-Feb-14 3:27am

i want to bind the textbox value in a gridview.

Dinesh.V.Kumar 11-Feb-14 3:28am

then your code is correct...

But ensure the column that you are binding is correct.

Regards

Member 10578683 11-Feb-14 4:25am

the grid view is generating but the column Serial Number remains empty. i m getting some binding problem i think

Dinesh.V.Kumar 11-Feb-14 4:31am

Did you check the "SerialNo" that you are binding..Is the name correct? pls check the datasource you are binding...

Regards

Member 10578683 11-Feb-14 4:58am

can you please tell me in detail how to bind a text box value in a gridview column.

Member 10578683 11-Feb-14 5:14am

In database also the value inside the textbox is not updating

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)