my table got around 15 columns and 50 k records.
which controls will be most efficient.
Gridview, datalist , repeater , detailsview , listview
There are considerations -
1. Should I use paging
2. If I am using repeater , is there any option to create the itemtemplate at runtime.
i have a gridview, and an itemtemplate who contains a checkbox, if the field: "DtFineValidita" (datetime field), is expired, i want set the checkbox to false, and if is null to true this is the checkbox
[Code]....
and this is the code:
[Code]....
but, if i set an breakpoint, and the funciton return false, the ckeckbox is every time checked! it is strange!, when the function return false is every time checked
How do I create and control the content of a div inside a cell of an itemtemplate in a gridview?
View 1 Replieshow to create search option for a site.
i want to place option on site that custmor can seach thing on site by writting word or phrases like google.
In my application I have successfully pulled some rows from a database into a DataSet and then used an ASP.NET Repeater Control to create a div container for each row with each field contained within a span element as follows:
<asp:Repeater
id="repeater"
runat="server">
<ItemTemplate>
<div
id="ticketContainer">
<a
href="#"><img
src="~/Images/treeview_expand.png"
alt=""
runat="server"
/></a>
<span><%#DataBinder.Eval(Container.DataItem,
"USERNAME")%></span>
<span><%#DataBinder.Eval(Container.DataItem,
"COMPUTERNAME")%></span>
<span><%#DataBinder.Eval(Container.DataItem,
"CATEGORY")%></span>
<span><%#DataBinder.Eval(Container.DataItem,
"DATE")%></span>
<span><%#DataBinder.Eval(Container.DataItem,
"TIME")%></span>
<span><%#DataBinder.Eval(Container.DataItem,
"STATUS")%></span>
<p><%#DataBinder.Eval(Container.DataItem,
"DESCRIPTION")%></p>
</div>
</ItemTemplate>
</asp:Repeater>
My problem is that I want the .png graphic link to have a onclick event so that a new div is dynamically inserted under the div to show data from a seperate database table. However since its all declared within the ItemTemplate then targeting the correct div using the JS DOM would be difficult/impossible as the id for each of the divs will be the same.
If this is going to be infeasible then what is the possibility of having data brought in from multiple tables would I have to manipulate the DataSet to include the extra columns as I think Repeater Controls can only have a single DataSet (corret me if i'm wrong).
This is a weird issue. I have a List view with 2 Link buttons. "Edit" and "Delete" Iam able to attach an event handler for the first linkbutton(Update). Code in the event handler executed fine. But If I try to attach a event handler for the second link button(Delete) , I get an error.
My Item Template Looks like this.
[Code]....
First Item works absolutely fine. But If I attach the second handler, I get the following error
Am I missing some thing ? Note - There is no error if I try to attach the 1st event handler to the second link button.[ie EditLinkButtonClicked to DeleteLinkButtonClicked ] Issue occurs only when I try to attach DeleteLinkButtonClicked to DeleteLinkButton
using a repeater to display multiple 'comments' related to a parent database entity (a 'task' in my case). When the user creates these comments they can optionally attach a file. Now, I'm working on the page that lists these comments and I'm not sure how to go about displaying the link to the attached file, if one is present. There may not be a file. The database record that contains the comment will also contain the url to the file if one was attached.
what are my options for this? I would like to just display a link to the file after the comment content, only if a file is available.
i have gridview resulted from sql query as below:
customer_id
items
123
pen
123
paper
456
pen
456
paper
678
pen
then i pivot the gridview by using the datatable.. i call the sql query to the datatable, pivot it using pivoted function and the datatable then become the datasource bind to the gridview..the result of pivoted datatable in gridview as below:
customer_id
pen
paper
123
(empty)
(empty)
456
(empty)
(empty)
678
(empty)
(empty)
my question is..how can i replace the empty column with textbox to be display within the gridview??? i need to use textbox so that user may enter the value of the item within the textbox.. i try using the itemtemplate for gridview but it's doesn't work and the itemtemplate create new column with textbox beside the paper column.. how to input textbox within the datatable in my case??
Eg:-- When I type "A" all the elements starting with A should be displayed... If "B" then elements with B....etc)
Ex:
<asp:DropDownList ID="ddlLocation" style="width:140px" runat="server">
<asp:ListItem Value="1" >India</asp:ListItem>
<asp:ListItem Value="2" >India - Hyderabad</asp:ListItem>
<asp:ListItem Value="3">South Africa</asp:ListItem>
<asp:ListItem Value="4">Australia</asp:ListItem>
</asp:DropDownList>
javascript :
function DisplayText()
{
var textboxId = '<% = txtText.ClientID %>';
var dropdownListId = '<% = ddlLocation.ClientID %>';
document.getElementById(textboxId).value = document.getElementById(dropdownListId).value;
document.getElementById(textboxId).focus();
}
code behind :
ddlLocation.Attributes.Add("onChange", "DisplayText();");
Now I have a datalist
I have done the itemtemplate and edittemplate,when I click on the button in itemtemplate, the edittemplate will show.But that row in itemtemplate will disappear.How can I keep that row in itemtemplate and ecotent in edittemplate both appear?
When I create a new website in IIS and its associated application pool, I get the option of setting the .NET framework to 1.0 or 2.0.Via windows updates I have installed versions 3.0 and 3.5..however these dont show up in the drop down list.I read that the aspnet_regiis -i command needs to be run in the installed .NET framework folder for it to be visible in IIS.However, the aspnet_regiis.exe is only present in the 1.0 and 2.0 folders. Can I use the same exe to register the 3.5 framework with IIS?
View 2 RepliesI have two item template which consist two dropdownlist D1,D2...
here what im doing is d2 is binding based d1 selected value...
im using this code in D1_Selectedindexchanged
foreach (GridViewRow row in Gridview1.Rows)
How to create Rows and Column using Datatable Gridview Itemtemplate with multi header I need to create Datatable Gridview Itemtemplate fixed rows and column such as 7 rows and 7 columns
[Code]....
I have a dynamic dropdown that is populated from sql. The user is supposed to select an option from the dropdown, then click a search button on the form to return some results based on that selection. It works fine if the dropdown gets populated with more than one record. However, if only one record is returned, that one record can't be selected. Whether you select it or just leave it alone since it's the only one, when you click the form button (search button), no results are returned b/c the dropdown selection must not be actually selected.
I've included the relevant code below. First the DDL, then the datasource, and finally the C# code in the if (!Page.IsPostBack)
[Code]....
Suppose I want to Edit a fixed section the an HTML section of an ASP.NET Page. I may add some text there and Upload some images etc. Then I want to make PDF (High Resolution) of that particular section. What should I do? I am using ASP.NET (C#) and Javascript (For Edit Text Of that section).
View 2 RepliesI want to ask how I can create a waterMark for a image runtime in other words I want to write some text at every Image I show in my site.
View 1 RepliesHow to create Text Box at runtime?
means if months contain 4 week 4 text box should be created.
SqlConnection conn = new SqlConnection("Persist Security Info=True;Data Source="+txtdatasource.Text+";database="+txtDBName.Text+"; User ID="+txtDBUsername.Text+";password="+txtDBPass.Text);
conn.Open();
SqlCommand cmd =new SqlCommand("SELECT [ItemCode],[ClientDescription] FROM ["+txtDBName.Text+"].[dbo].[Bookings]");
cmd.ExecuteNonQuery();
This gets the folowing error ExecuteNonQuery: Connection property has not been initialized. i know it connects to the database
How Create Page In runtime
View 5 RepliesI was wondering is it possible to create a css class at runtime?
I am unable to use the traditional method of doing so as one of the attributes need to be loaded at runtime.
As I am using the Coolite Toolkit, whenever i need to use a custom image onto one of the controls, the custom image path needs to be loaded in via a stylesheet class.
I've figured out how to create the controls in the format I want, but now I am confused as to how create more than one set of them. I set everything to new and increment the names of each control, but it's only updating the one set. Here is my code:
[Code]....
How we can create a WCF proxy by giving the url in code at runtime??
not with WSDL tool or VS Web reference
In my application, I am using Tab Container in one Panel. At runtime on one of the Button Click
I want to create Tab Panel in to the tab Container. I am doing this as follows:
protected void btnMSOpen_Click(object sender, EventArgs e)
I want to create dynamic integer variable for each role in this loop. Which I will user later for totaling item count in other logic.
Is this possible to create a runtime dynamic variable?
Am currently working on my first ASP.NET projects. I have a requirement for a page where a user can enter their current address, and then add as many previous addresses as they like. I have created a Panel with the required text boxes in, and also an 'Add' button which will allow them to add another address. How could I make a copy of that Panel and add it to the page at runtime ... assuming that it is possible!!!
View 14 Replies