|
|
|
Do not 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.
|
|
|
|
|
|
|
kishorgh wrote: wht SPAM
That was not for you !
Some one Spamming in this site and we have marked him.
|
|
|
|
|
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.
|
|
|
|
|