I have estate_p table that contain zone column this column datatype is Varvhar(5) and in this column save below data
1 2 3 4 5 6 7 8 9 10 11 12 13
I bind DDlZOne from this column and in SP I define order by zone asc
but in ddl show above number like below:
1 10 11 12 13 2 3 4 5 6 7 8 9
how I can solve these problem I don't want change zone data type to int becuse I want save data in string in this column ...
I have a gridview with an hyperlink item pointing to a "detailspage.aspx" allowing users to read the full article. What I would like to do is to add a column to the GridView where it is possible to read the number of times a specific article has been read, that is any single time a user has clicked onm the hyperlink.
View 16 RepliesThere is a Dropdown(named "Station") in my code.
<asp:DropDownList ID="DStation" runat="server" Width="100%"></asp:DropDownList>
Im fetching the data saved in DB inside dropdown SelectedValue on page load as below:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
[Code].....
But its always showing "ABC" (i.e, 1st Id's station) in selectedValue of dropdown, for every "id" dont know why.
I have created an out-of-the-box (default everything) ASP.NET Dynamic Data Entities Web Site using VS2010, C# and the .NET Framework 4. Created an ADO.NET Entity Data Model based off a MS SQL 2008 R2 database and registered that EF data model for my dynamic data. Everything works great except for the one change I would like to make. By default, the GridViewPager.ascx file provides the values 5, 10, 15 and 20 in the dropdown for GridView's "Results per page" option. I would like to change that to 10, 20, 30 and 40 - with 40 being the default selected option.
I went to the code behind file and modified it to have the values I am wanting. Those values now show in the dropdown, and work if I select them. Problem: when the page is first rendered only 10 rows will show. How can I change this?
I have a DropDownList on my webpage using an Access Database to fill it. However in my database record there a multible values with the same name.
My situation now:
MyDropDownList1
-ValueBaarlo
-ValueBaarlo
-ValueVenlo
-ValueMaasbree
-ValueMaasbree
-ValueMaasbree
-ValueMaasbree
What I want:
MyDropDownList1
-ValueBaarlo
-ValueVenlo
-ValueMaasbree
I only want to show every value (name) just once!
I dont want them to be able to select a listitem until they click edit .
here is a picture of what it looks like now.
How to display the selected value of a dropdownlist in header taemplate of a gridview? As i change the dropdownlist's value, it should also change in the gridview. i have taken a label in the gridview's header template named "lbl_mnth" my dropdownlist's id is "ddl_mnth".
View 1 RepliesI have gridview and button and radiobutton in page below are codes...
<input type="radio" name="n" id="RBmkvM" runat="server"/>
<input type="radio" name="n" id="RBdvdM" runat="server"/>
<asp:ImageButton ID="ImageButton1" runat="server" CssClass="imgored" ImageUrl="~/Image/Main/png1.png" OnClick="Imgorder_Click"></asp:ImageButton>
[Code]....
I have a listview that is showing its result by using a linq query. The linq query goes like this.
[Code]....
* db.Varer: Varer is a table that contains basic product information like proudct name, product nr. etc. ** a.fk_kategori_id == CatParamId : I'm just saying limit the result according to the Category ID (a.fk_kategori_id). The category id is coming from a dropdownlist (CatParamID) *** Join: Besides the Varer (Product) table I also have another table, Sizes. This Sizes table contains 6 columns (ID_Sizes (int) primary key and the columns: OneSize, S, M, L, XL, XXL all are bit (true or false)). There is a relationship between Varer table and Sizes table. It says that I can only insert a value into the "fk_sizes_id - column" of varer table if that value already exists as primary key within the Sizes table. **** I'm starting by picking basic product values like productId, ProductName etc from the Varer (a) table ***** Then I'm picking the corresponding Sizes values (onesize, s, m, ...) from the Sizes table. Now within my ListView I'm showing the above result by using Eval, like this.
[Code]....
And this works perfectly, but now comes the thing that is causing me trouble. I have the below drop down list (still within the ListView ItemTemplate):
[Code]....
I want this drop down list to be populated with only those of the "linq query's Sizes table result" that are true. By "Sizes table result" I mean these
[Code]....
I came across a situation where a user selects no of rows from dropdown , depending upon the user input, automatically that no of editable rows should appear to input data...(maximum 8 rows only)
View 1 RepliesI my website i have 2 dopdownlost i want when i change the value of one.. The other one loads data depending on the first one value
the both of the dropdownlists is in ajax update panal and i do have script manager
i used this code but not working
protected void floor_ddl0_SelectedIndexChanged(object sender, EventArgs e)
{
floor_ddl1.DataBind();
}
i want datalist to show only 6-8items ,as these datalist is connected to datasource which has more than 20 items..
like in facebook,we have lots of friends but in friend box only 6 friends is shown and when we click that we go to next page which display all list of friends...
I get this message when i go to update formview.
View 2 RepliesThe following code gives error: "When casting from a number, the value must be a number less than infinity."
<asp:TemplateField HeaderText="DATE" SortExpression="date1">
<ItemTemplate>
<asp:Calendar ID="Calendar1" runat="server"
SelectedDate='<%# Bind("date1") %>' VisibleDate='<%# Eval("date1") %>'>
</asp:Calendar>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="Date1" runat="server" Text='<%# Bind("date1") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
The error occurs at the line <asp:Calendar ID="Calendar1"...>
It errors because there are records with null value for date1 when the records are returned from the database.
Is there a way to specify in the .aspx file telling it to ignore null or display null/blank?
I would like to dropdown box to show only starting from second row of the table. How to use data reader to do it?
View 9 RepliesI am displaying selectable rows in a gridview. The selected row uses a stored procedure to display all the fields in a formview when the Select button is clicked.
Only a small subset of the fields in the selected row are editable. When I click the Edit button only the EditItemTemplate fields show up, the read-only fields from the ItemTemplate disappear. I want the read-only rows to remain visible with the editable rows.
If I include the read-only fields in the EditItemTemplate, I get an error when I click Update on the FormView. The error states that there are too many parameters being passed to the stored procedure to update fields. How can I continue to show the read-only fields with the editable fields on the FormView and avoid getting the input parameter error on the stored procedure for the Update command?
I have a web user control with DataList control in it. In my .aspx page, I have a report header, an empty panel as a place holder, a report footer.In my .aspx.vb file, I'll loop through a list of departments. Within each department, I'll load a label to display the department name and the user control for the data, and add both the label and user control to the panel. So there are two variables:
the number of departments and the number of records in a user control.
Now I need to display the current page number and the total page number in the report footer. Is it doable? How? I'm thinking of this approach: declare a page variable count, count the number of department name labels and the number of records in a user control. When the total count reaches a number, such as 20, I'll break the page. This way, I can get the the page current number and the total number of pages. But how to add a page break to an asp.net page?
I have a combo box, with Date picker. In combo, there are two items 1> Going to USA 2> Going to China
Suppose user select 'Going to USA' then pick any date and now again select 'Going to China' a select some other date.
Now the user selected both items with dates and on clcik of button a grid should genrate.
Ex Location Date
Going to USA x date
Going to China y date
I have a listview that shows the user the details of the members who have sent friendship request. The table from which the data come has two fields namely, sender_id[id of the one who sends friendship request] and receiver_id[id of the one to whom the request is sent].
There will be two columns in the listview. The first would show the pic and the name of the user. The problem is that how am I going to show the pic and the name if the table from where the data come does not contain these info. I know that the sender_id can be used to fetch the pic and name of the sender, but how should it be done?
Earlier I would do something like <%#Eval("fieldName")%>. But in the above described scenario the field is not present in the current table but the other one.
I have a datasource:
[Code]....
I have a detailsView bounded by some other datasource. There is a dropdown in detailsview which is bounded by sqldatasource named "sdsNature" . Here is the templatefield for dropdown:
[Code]....
I want to show FNature instead of FNatureID in the selected mode as Label and in Edit mode as dropdown. When I am running this project, in Select mode it is showing FNatureID instead of FNature and if I click to Edit the record it is displaying following error:
'lstNature' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value Do I have to give some If else condition that if FNatureID is .... then dropdown should display FNature.... If yes then what should be the code?
Say I have a table which as two fields Category and Subcategory. There are multiple sub categories under a particular category. when displaying in grid it shows all subcategories along with the category which is the same is this case.
How can I display records so that the category is displayed only once and all subcategories are displayed.
I just hit the same problem as described here: [URL] - GridView paging with ObjectDataSource. I see the column headers but no data, and I know for a fact my method returns a DataTable with data in it.
View 1 RepliesI have a page with a gridview control that shows files that have been uploaded to our site. The name of the uploaded files, who uploaded them, and if they have been downloaded, etc are stored in a table. The gridview is bound to the table through a sqlDataSource control. I have a button column in the gridview that downloads the file associated with a row when the button is clicked. All that works well. I have a check box column that shows checked if a file has been downloaded. When the download button is pressed.
the file downloads and then a short routine is run to update the downloaded field in the uploaded files table to set the downloaded field to true. This is done through a command string. All this works. Here is the question. After the update is run I do a databind on the gridview to update it. The databind is run in the PageLoad event is the page is a postback. This does not cause the current row to show downloaded =true (checked). If I refresh the page in the browser then it displays correctly.
I am using 3 dropdown list in a gridview and the values for the dropdownlist is dynamic from database.based on first dropdown list selected value the values must fill to second dropdown and based on second dropdownlist selected value then items should load to 3rd dropdown and same for 4th dropdown list. Here if i select age,gender,sex, fist name, last name from the template name Human. The first drop down only populate the fields like Age,gender,Sex and so on., When the second dropdown list populate from the fields corresponding Template name Human, Finance, and so on.
View 3 RepliesI have 2 table in database
1-House_info
Id Name Behcode Subset H_name
1 Sara 1111 Electric House
2 Jack 2222 House
3 Micheal 3333 House
2-House_p
Id Model Behcode Subset H_name
1 Sofa 2222 Furniture House
2 Chair 2222 Furniture House
3 Curtain 3333 Curtain House
In House_info saved Users information and in House_p saved users Product Information
I have datalist in my page that bind from House_info table and if users insert their produt in House_p, their information from House_info will be bind ...
Below is SP
ALTER procedure [dbo].[GetCustomersPageWise2]
@H_name nvarchar(50)
,@subset nvarchar(30)
,@PageIndex INT = 1
,@PageSize INT = 5
,@RecordCount INT OUTPUT
[Code] ...
Here if users insert Their product into House_p table in datalist shows their information from House_info Table so here just shows users with behcode=2222,3333
In House_p table is Subset column if users select Item from menubar in Product.aspx page according to their selected Item it will show information in datalist
i.e
If they select Furniture from menubar it shows users information from House_info table that they inserted product with subset=furniture in house_p table
Now I want if users select item=Electric from menubar it shows users information from House_info table that subset=Electric (but she didn't insert any Product in House_p table)
In above SP it just show users that insert Product in house_p table
I want shows both of them...