[Code]....
I have a question about datalist control. See I only need to display 12 records when the users are viewing in a small preview setting. How can I achieve that? I know I can get TOP 12 from the sql query, but is there a way I can modify in the datalist control itself? DataTable dt = new DataTable();
I have written a code from here http://www.aspsnippets.com/Articles/Display-GridView-with-Empty-Message-and-Header-and-Footer-when-no-data-in-ASP.Net.aspx. I just edited this as follows. this is my gridview code:-
<asp:GridView ID="gvCustomers" runat="server" Width="550px" AutoGenerateColumns="false"
Font-Names="Arial" Font-Size="11pt" AlternatingRowStyle-BackColor="#C2D69B" HeaderStyle-BackColor="green"
AllowPaging="true" PageSize="10">
<Columns>
<asp:BoundField HeaderText="State Name" DataField="StateName" FooterText="Footer" />
<asp:BoundField HeaderText="Organizatio Name" DataField="OrganizatioName" FooterText="Footer" />
<asp:BoundField HeaderText="Partner Name" DataField="PartnerName" FooterText="Footer" />
</Columns>
<AlternatingRowStyle BackColor="#C2D69B" />
<EmptyDataTemplate>
<table cellspacing="0" rules="all" style="font-family: Arial;
font-size: 11pt; width: 550px; border-collapse: collapse;">
<tr style="background-color: Green;">
<th scope="col">
State Name
</th>
<th scope="col">
Organization Name
</th>
<th scope="col">
Partner Name
</th>
</tr>
<tr>
<td colspan = "3" align = "center">
No Data found.
</td>
</tr>
</table>
</EmptyDataTemplate>
</asp:GridView>
and my code file code is as follows
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["contest"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind_Grid();
}
}
protected void Bind_Grid()
{
string strSql = "select * from mtblInformation";
SqlCommand com = new SqlCommand(strSql,con);
SqlDataAdapter sda = new SqlDataAdapter(com);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
gvCustomers.DataSource = dt;
gvCustomers.DataBind();
}
}
when in database table have records then gridview binds and its showing records, But when there is no record in DB , instead of showing msgs that "No Data found." gridview doesn't appear.
There is a gridview and I am binding some records to it. in my database there are 4 records but gridview always shows 3 records. Even I have given PageSize 10.
View 4 Repliesi m try to read a xml file using Datalist its working , but i need to show only top 4 records how i can do that
View 3 RepliesI have a datalist using an XmlDataSource to source records. The issue is the datalist only shows the first record from the xml file. How do I get the datalist to show the first 10 records from the XmlDataSource?
[Code]....
I wanto to limit the display of records in Datalist and enable paging.
View 6 RepliesI have jquery menu in index.aspx page when user click on item related to that item it go to House.aspx and show products information in datalist these are my table in DB:
1-House_info Table
Id Behcode Name Region H_name
1 1111 Jack 1 Cloth
2 2222 Ana 1 Electric
3 3333 Edvard 2 Electric
4 4444 Math 1 Furniture
2-House_product Table
Id Behcode Name Description H_name
1 2222 Iron Test Electric
2 4444 Sofa Test Furniture
3 1111 Scarf Test Cloth
4 3333 Laundry Test Electric
And these are my code in index.aspx and House.aspx
Index.aspx:
<ul><li>
<a href="house .aspx?H_name=Electric">Electric</a>
<ul>
<li class="current"><a href="house .aspx?H_name=Furniture>Sofa</a></li>
2-House_aspx
string Code = Request.QueryString["H_name"];
SqlCommand _cmd = new SqlCommand("select * from House_p where H_name=@H_name", _cn);
_cmd.Parameters.AddWithValue("@H_name", Code);
_cn.Open();
SqlDataReader _dr = _cmd.ExecuteReader();
[Code] ...
EX : In index.aspx When user click on Electric item it go to house.aspx and show all product that have H_name=Electric According to House_p table it will show :
Id Behcode Name Description H_name
1 2222 Iron Test Electric
4 3333 Laundry Test Electric
Now I have one DDL and 1 button in House.aspx page I want when user click on menu and go to house.aspx page after they see result of their selected item from menu choose their region from ddl and click on button after that they see product that are in that region according to table House_info
EX : If user select region 1 it will show all Electric product that have region=1
Id Behcode Name Description H_name
1 2222 Iron Test Electric
As we use datalist it will shown all the data which is on my data base. But I want to show only 5 row and rest of my data will be show on the button click so how can i do it...
View 1 Repliesi have a data list control displaying offer coupons . i want visitor to select desired coupon through check box and print only that coupons(records) that have been checked.
View 1 RepliesMy question is I have multiple Checkbox Lists and i want to compare it and Filter Datalist records on Checkbox list checked event.. (I want filtering something like [URL]
using System;
using System.Collections.Generic;
using System.Linq;
[Code].....
My problem is If first checkbox list is checked and user clicks on second checkbox list then i want to compare both checkboxes and populate result based on both checkboxes.
Print only the items which are selected using checkbox in a ASP.Net DataList control"
How to moidfy the above article by include dropdownlist getting data from a database table.
then filter the datalist using the selected value of dropdownlist. and then print only records that are selected by checkbox.
when form loads the datalistcontrol should display all the records.
I am trying to find out the best method or practice to use a dropdownlist to feed my oracleparameter value. I currently have this working when I have a value selected in the dropdownlist. My issue is how to account for if the user leaves the dropdownlist empty. I want this to then return all data. My SQL has a where clause = to :HRM. I use a function that gets the text for my SQL from a text file. My dropdownlist box is populated via databind. I then inserted a item in my dropdown with 0 index with no text display and a value of "novalue" Below is my code to populate my dropdownlist
[Code]....
[Code]....
If I select an item and run my code it works great. This doesnt work with the no selection tho. Do I have to build the SQL dynamically with a check if the listbox is empty or not and then add the criteria? I was hoping there was a eailer way since I have many queries and parameters to build.
Here is part of my code using the oracleparameter.
[Code]....
I also saw a post about trying this, but I get an illegal error.
[Code]....
Not sure if I can replace the "AND HRM_FIELD = " text and use :HRM instead and then build the oracleparameter with an IIF to include the AND HRM_FIELD part.
[Code]....
this is my html code
[Code]....
this is my code behind
[Code]....
this is my bal code
acuttally
in my javascript popup i am getting the checked values but i need it in record by record in the lblsave data
i have a question regarding grid view. i have done almost all work i needed. but one thing i want to do is i have set 4 of page size of grid. so when i show records on the web page i want to set a iframe after first two records then iframe and then two more records like i have shown in the example image. i have used LINQ with C#.how to do it. if you people want i can show you my code.
View 3 Repliesi have a datalist in my aspx like this:
<asp:DataList
ID="dlSubs"
runat="server"
CellPadding="0"
CellSpacing="5"
RepeatDirection="Vertical">...</asp:Datalist>
when i do this in the code-behind:
this.dlSubs.DataSource = dtCat; // dtCat is a datatable with about 13 rows
this.dlSubs.DataBind();
everything gets rendered in one column (vertical) but i want two colums... so i do this:
DataTable dtCat = shop.DAL.ArtikelenDB.GetLeftMenu(Convert.ToInt32(Request.QueryString.Get("catg")));
double tmpDouble = (double)dtCat.Rows.Count / 2.0;
double repRow = Math.Ceiling(tmpDouble);
dlSubs.RepeatColumns = Convert.ToInt32(repRow);
dlSubs.RepeatDirection = RepeatDirection.Vertical; // also tried without this line...
this.dlSubs.DataSource = dtCat;
this.dlSubs.DataBind();
but when i do the above. it gets rendered horizontally... how is that possible?
The problem is that i have a search page. Access Database holding the information. I have a Access Datasource on the page with a Datalist to show the data. I need to find a way on setting it up to says "Sorry no results found" when the is no results. i am unsure on how to do this though.
Below is my datasource and datalist
[Code]....
im tryin to create repeater from code behaind using C#. The data bind is working good, im tryin to put some pager. the pager is half working. i can see the pager links at the bottom, i can see the the code split the records to 10 lines each page as i set it but when i click the next link the records stay the same it wont changing for the next 10 records. my code
[Code]....
i have 500 records to show in webpage. i am using DataList in that webpage. if i use direct binding it is slowing down the performance of the page and is taking time to load. now i have used update panel and i want to append data records by records(i want to append as first 50records and then next 50 records something like)
View 4 RepliesAm building a Form for out intranet that runs on ASP.NET and C#, it is to be a survey from a SQL database. I have the connections setup can pull informations/Questions from the database. I am having a problem with setting up radio buttons within a datalist, ive never done this and i know they require unque names.
It is to be 4 radio buttons per question where only one can be select, i know how to group just not via a datalist with unique names
How can I do paging with datalist if that datalist is populated with inputs coming from a querystring?
View 3 RepliesI need to find which Selected Key value that was selected in the ChildDatalist inside the MainDatalist
this is my Html code...for the MainDataList and the nested Childdatalist
[Code]....
I am trying to place a datalist inside datalist. I managed to place a datalist inside gridview but not datalist inside datalist.
Below is the code I am using to bind the datalist into the master gridview, I am trying to change this code in such way it will be right for datalist inside datalist but so far I did not succeed.
[Code]....
i have a datalist . that is contains 7 columns in repeat layout .when i have more from 7 columns , datalist style is normal .but when i have smaller than 7 columns ! data list style is not normal,
because there are some empty columns without specific schema.
How i can make a datalist > when i have 1 columns in my datalist my first layout width be 100% ;
and dont show some empty layout ?
i want if there wasn't any thing to show in datalist it show some text in datalist like
"there isn't any thing to show" how i can do it?
<ASP:Repeater id="MyRepeater" OnItemDataBound="MRBound" runat="server">
<HeaderTemplate>
<Table width="100%" style="font: 10pt verdana">
<tr style="background-color:DFA894">
<th>
Status
</th>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr style="background-color:FFECD8">
<td>
<%#DataBinder.Eval(Container.DataItem, "Status")%>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</ASP:Repeater>
I want to change the status in the table to word(eg. pending, reject, accept) instead of number(0,1,2),
but i dont know how to select the extra row and value.