|
Hiiiii......i m adding n number of text boxes dynamically in a panel. but when i m going to save those values. it gives me error. My code and error is :
Dim id As Integer = Request.QueryString("ui")
Dim cmd2 As String = ("Select Specification from DefineSpecification where CategoryID=" + ID.ToString())
Dim rdr2 As IDataReader = db.ExecuteReader(CommandType.Text, cmd2)
Dim conn As New SqlConnection
Dim cmd As New SqlCommand("Select Count(*) from DefineSpecification Where CategoryID=" + ID.ToString(), conn)
conn.ConnectionString = ConfigurationManager.ConnectionStrings("See2Buy").ConnectionString
conn.Open()
Dim count As Int32 = Convert.ToInt32(cmd.ExecuteScalar())
While rdr2.Read
Dim lbl = New Label()
lbl.Width = "140"
lbl.Text = rdr2.Item("Specification")
Panel4.Controls.Add(lbl)
For counter2 As Integer = 0 To count
Dim txt = New TextBox()
txt.Width = "140"
txt.ID = "TextBoxID" + counter2.ToString
Panel4.Controls.Add(txt)
Dim txt1 As TextBox = CType(Panel4.FindControl("TextBoxID" + counter2.ToString()), TextBox)
Dim txt2 = CStr(txt1.Text)
Dim cmd3 As String = "Insert into Specification(SpecificationHeading,SpecificationDescription)Values('" + lbl.Text + "','" + txt2 + "')"
Dim dbcmd As DbCommand = db.GetSqlStringCommand(cmd3)
db.ExecuteNonQuery(dbcmd)
Next
End While
Error is: Multiple controls with the same ID 'TextBoxID0' were found. FindControl requires that controls have unique IDs.
pleas guide me
|
|
|
|
|
in which line are you getting this error....
|
|
|
|
|
in this line
Dim txt1 As TextBox = CType(Panel4.FindControl("TextBoxID" + counter2.ToString()), TextBox)
|
|
|
|
|
hi
this error is quite obvious because when datareader read second row from database counter2 in your for loop will again have same value. So, declare one counter before while loop and increament that counter in for loop.this will solve your problem
himanshu
|
|
|
|
|
thanks bro 
|
|
|
|
|
hiiiii........as u told me to add counter before while...i added and incremented in for loop.........bt still the same error...can u tell me where to use that specifically in that counter
|
|
|
|
|
Hi all,
how can i embed excel sheet with everything it holds (pivot table, charts ...) in an aspx page.
any ideas, thanks
|
|
|
|
|
You can just create a web page (e.g. WebForm1.aspx) in asp.net and put the following code in Page_Load event in code behind page
Response.ContentType = "application/vnd.ms-excel";
string sFile = Server.MapPath("MyExcel.xls");
FileStream fs = new FileStream(sFile, FileMode.Open, FileAccess.Read);
byte[] b = new byte[(int)fs.Length];
fs.Read(b, 0, (int)fs.Length);
fs.Close();
Response.Clear();
Response.BinaryWrite(b);
Response.End();
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
This will create a new excel sheet. But samerh want the excel inside the aspx page like the images and gif files.
|
|
|
|
|
|
thanx for last help
sir please send me code for taking the value from hidden column in gridview.
|
|
|
|
|
vikas shukla wrote: thanx for last help
Which help are you talking about ?
If you are pointing some of previous thread , then you should post it over there rather than posting a new thread !
|
|
|
|
|
in asp.net hidden field could not render there u can not access it.
but u can apply the technique here.
insert template field hide it. and access its ItemTemplate Control.
<asp:GridView ID="grd" Width="100%" runat="server" AllowPaging="True" AutoGenerateColumns="False" PageSize="15" AutoGenerateEditButton="True" >
<Columns>
<asp:TemplateField HeaderText="ID" Visible="False">
<ItemTemplate >
<asp:Label ID="lblID" runat="server" Text='<%# Bind("ID") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle Width="190px" />
<ItemStyle Width="190px" />
</asp:TemplateField>
</Columns>
</asp:GridView>
foreach (GridViewRow row in grd.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
Label lblID = (Label)row.FindControl("lblID");
string txt = lblID.Text;
}
}
|
|
|
|
|
instead of maintaining some values in a column and hiding it you can use datakeys.
|
|
|
|
|
if the column is a bound field and it's visibility is turn off, it cannot be retrieved as the value isn't rendered in that case. Either use template field or use datakeys, it depends how you're using it.
|
|
|
|
|
I have a dynamically databound gridview on my Page.
I have some data being entered into a textbox for every value being selected in a dropdown.
Everytime TEXTBOX value is entered, It should be reflected in one of the gridview column and should be editable.All the other colums should be non editable.
Can You please let me know how this can be achieved?
|
|
|
|
|
use bound field for non editable columns and use template fields for editable columns
|
|
|
|
|
I am using a template field already.
What is the real issue is how to map the values from a textbox onto this column for a specific row.
|
|
|
|
|
|
Dont spam
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Hi!
I am not sure where should I post this topic. I just need an idea about my task below
a central server polls from a legacy server for media updates. the media file has incremental file name i.e 1.mpeg, 2.mpeg and so forth. central server needs to poll the legacy server and check for update via ftp. once it finds update it needs to copy the files and bring into central server from legacy server and distribute to its 600 clients. each client plays those mpegs constantly and central server needs to update the content in clients playlist automatically. for example clients current playlist could be
1.mpeg
2.mpeg and so forth. how do i keep adding the updated file to the play list and keep deleting if the files are more than 20 i.e.
play 1-20 and as soon as it hits 21 delete old files
please help i dont know how to acheive this and which what program.
thanks in forward.
|
|
|
|
|
|
I have a dropdownlist and based on its selected value I want to display the appropriate pdf document. This is the code under the dropdownlist
protected void ddlBasicConcept_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlBasicConcept.SelectedValue.Equals("Variable"))
{
ShowPdf1.Visible = true;
ShowPdf1.FilePath = "file///C:/Documents and Settings/lingwatil/My Documents/VisualStudio2008/websites/LearningConceptsB/asp.net_tutorial01_Basics_cs.pdf";
showpdf1 is my Iframe
and this is the ERROR I'm getting, please help.
Server Error in '/LearningConceptsB' Application.
--------------------------------------------------------------------------------
HTTP Error 400 - Bad Request.
--------------------------------------------------------------------------------
Version Information: ASP.NET Development Server 9.0.0.0
ML Lingwati
|
|
|
|
|
my application is, shutdown remote system using process.start("shutdown",-s,-f \\machinename);
it works fine from visual studio.
but when i install this application in iis server and run, it will displays error
shutdown.exe - application error
application failed to initialized properly.
do i need to set any permissions to run shutdown.exe from remote machines
Thank You
|
|
|
|
|
Hi,
apps in IIS are running under a different account (ASPNET for IIS5, NETWORKSERVICE for above). You could impersonate your process.start with using the properties username and password.
Regards
Sebastian
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
