|
Hi,
Sorry, if this question is stupid but i have tried searching alot and couldn't find an exact answer. Also, i am not looking for an exact solution but guidance in the right direction would be highly appreciated.
I realize that gridview paging selects all data but displays a portion of it. I want to implement custom paging where data is only specific data is selected. I have kind of done my homework on it. ie i can use linq to select and skip data, but i want page links to be displayed at the bottom of the page. Is there any property that sets this (i believe datagrid had virtualitemcount). Does gridview has something like this or do i need to program this portion. I would like to mention here that i don't want to use SqlDataSource or ObjectDataSource, rather i want to assign datatable to gridview.DataSource. Again, would i have to manage paging my self, if i implement above solution.
Sorry, if its a stupid question. Again i found solutions on google but none had numbered pages in bottom of gridview, which i want to have. I can do it with next,prev btn at the moment.
Thankyou very much
|
|
|
|
|
mark_me wrote: i can use linq to select and skip data
I don't know anything about the problem domain you are working on and data structures you use. But if database is your persisting area, efficient way to do this is to get only rows that will be displayed.
mark_me wrote: Again i found solutions on google but none had numbered pages in bottom of gridview, which i want to have. I can do it with next,prev btn at the moment.
IMO, there is nothing wrong in using ObjectDataSource since it comes with inbuilt paging capabilities. If you are binding a DataTable , you need to set the TypeName property to DataTable .
You need to provide two methods, one for selecting the data according to the page number and another method for calculating the total count of data. These methods should be assigned to SelectMethod and SelectCountMethod properties respectively.
Scott Guthrie's article[^] gives an overview of doing this. He is using ASP.NET AJAX but the concepts are same.
|
|
|
|
|
Thankyou very much Navaneeth!
I looked into the link that u have forwarded and seems like its the solution i was looking for. Thankyou.
Actually, to be honest, i don't know why i didn't use sqldatasource. Probably, because i thought that maybe i will require a sqldatasource for each page and thought its better that i make one procedure and pass column names along with whereCondition and table name , and then use datasource=mytable. Though, initially it seemed a good idea but now i realize that probably, it was a bad idea. Anyways, I can get count of rows, but my problem is page links ie 1 2 3 4 ... at the bottom, Do i have to implement it manually or is there any property that would help me in a few lines of code.
Thankyou,
|
|
|
|
|
mark_me wrote: i don't know why i didn't use sqldatasource
I was recommending ObjectDataSource not SqlDataSource . In fact, SqlDataSource is crap and should only be used for demonstration purpose.
mark_me wrote: , Do i have to implement it manually or is there any property that would help me in a few lines of code.
You don't have to implement it. See the article which I linked, he hasn't wrote extra code to display page numbers.
Glad to hear that it helped.
|
|
|
|
|
Thanks,
SqlDataSource is a crap! wow, thankyou, it was good to hear after i haven't used it. I will though, research on it a bit during the weekend. (for learning purposes)
Yeah, after i replied and returned back to ur link, i realized that i replied a bit too soon. Thanks for pointing the direction.
Thanks
|
|
|
|
|
My sql s not working...whenever i try 2 add sqldb file it gives login failed....in sql server configuration manager properties of sql express are-
logon-build in account-local system....itz been a trouble from long i have to create my database in access...
|
|
|
|
|
This is nothing to do with ASP.NET. Please ask your questions in General DB Forum.
|
|
|
|
|
I think the login you are using cannot have permission to the Database. Add the login to an user in the database.
And also this is not Database forum. It would be nice if you move the discussion to appropriate section.
|
|
|
|
|
I don't know a particular name for that kind of controls....it's like when u click a (+) it sub divides under a line representing itz subcomponents....and when u click (-) then again it wraps up...i wanna create such contols on client side how to do?
|
|
|
|
|
greendragons wrote: ..i wanna create such contols on client side how to do?
These are nothing but DIV . You can easily create them using DIV by just expanding and collapsing DIV control using javascript.
Or You can have a look into AJAX Accordion Control
|
|
|
|
|
Thnx i'll try..if i have a problem in ajax accordion i'll ask u..right now im going to bed..*g'nite evry1*
|
|
|
|
|
|
One page containg two frame....with help of SHDocVw.InternetExplorer object i have to excess second frame.
Problem is that when try to loop through below code
Dim HTMLDoc As mshtml.HTMLDocument
HTMLDoc = oIE.Document
For i As Integer = 0 To HTMLDoc.frames.length - 1
Dim f1 As mshtml.IHTMLWindow2 = CType(HTMLDoc.frames.item(i), mshtml.IHTMLWindow2)
MessageBox.Show(f1.document.body.innerHTML)
Next
while access through second one it gives me that "Access is denied."
after searching i come to know that this is happen dur to cross page scripting of frame....
here i have see that second frame point to different domain.
is there any solution for this problem....???
thank you.
|
|
|
|
|
No. For security reasons, scripts cannot access other domains.
You can try doing a similar code on the server side, that is, the .net (and not the browser script) would query the page and read the HTML for you. This can be achieved throught the System.Net.WebRequest class. After gathering all the HTML, you can just write it in a file or something.
Regards,
Leonardo Muzzi
|
|
|
|
|
hi,
I m using MS-Index Services, everything doing well
But i want to Retrieve Office Document(doc,xls)html etc Metadata
means some text area just like google web site Result.
somebody help me for configuration and query for retrieve documents text part.
|
|
|
|
|
Hi there! I'm pretty much unfamiliar with .net and our developer is out. I'm hoping someone could help me with the following. I was told to insert this code into the page load event of the master page file:
if (Request.Headers["User-Agent"] != null && (Request.Browser["IsMobileDevice"] == "true" || Request.Browser["BlackBerry"] == "true" || Request.UserAgent.ToUpper().Contains("MIDP") || Request.UserAgent.ToUpper().Contains("CLDC")) || Request.UserAgent.ToLower().Contains("iphone")) ||
Request.UserAgent.ToUpper().Contains("BREW")) ||
Request.UserAgent.ToUpper().Contains("sony")) ||
Request.UserAgent.ToUpper().Contains("symbian")) ||
Request.UserAgent.ToUpper().Contains("nokia")) ||
Request.UserAgent.ToUpper().Contains("samsung")) ||
Request.UserAgent.ToUpper().Contains("mobile")) ||
Request.UserAgent.ToUpper().Contains("windows ce")) ||
Request.UserAgent.ToUpper().Contains("epoc")) ||
Request.UserAgent.ToUpper().Contains("opera mini")) ||
Request.UserAgent.ToUpper().Contains("nitro")) ||
Request.UserAgent.ToUpper().Contains("j2me")) ||
Request.UserAgent.ToUpper().Contains("netfront")) ||
Request.UserAgent.ToUpper().Contains("mot")) ||
Request.UserAgent.ToUpper().Contains("up.browser")) ||
Request.UserAgent.ToUpper().Contains("up.link")) ||
Request.UserAgent.ToUpper().Contains("audiovox")) ||
Request.UserAgent.ToUpper().Contains("ericsson")) ||
Request.UserAgent.ToUpper().Contains("panasonic")) ||
Request.UserAgent.ToUpper().Contains("philips")) ||
Request.UserAgent.ToUpper().Contains("sanyo")) ||
Request.UserAgent.ToUpper().Contains("sharp")) ||
Request.UserAgent.ToUpper().Contains("sie-")) ||
Request.UserAgent.ToUpper().Contains("portalmmm")) ||
Request.UserAgent.ToUpper().Contains("blazer")) ||
Request.UserAgent.ToUpper().Contains("avantgo")) ||
Request.UserAgent.ToUpper().Contains("danger")) ||
Request.UserAgent.ToUpper().Contains("palm")) ||
Request.UserAgent.ToUpper().Contains("series60")) ||
Request.UserAgent.ToUpper().Contains("palmsource")) ||
Request.UserAgent.ToUpper().Contains("pocketpc")) ||
Request.UserAgent.ToUpper().Contains("smartphone")) ||
Request.UserAgent.ToUpper().Contains("rover")) ||
Request.UserAgent.ToUpper().Contains("ipaq")) ||
Request.UserAgent.ToUpper().Contains("au-mic")) ||
Request.UserAgent.ToUpper().Contains("alcatel")) ||
Request.UserAgent.ToUpper().Contains("ericy")) ||
Request.UserAgent.ToUpper().Contains("vodaphone/")) ||
Request.UserAgent.ToUpper().Contains("iphone.")) ||
Request.UserAgent.ToUpper().Contains("iPhone.")) ||
Request.UserAgent.ToUpper().Contains("ipod.")) ||
Request.UserAgent.ToUpper().Contains("iPod.")) ||
Request.UserAgent.ToUpper().Contains("wap1.")) ||
Request.UserAgent.ToUpper().Contains("wap2.")) ||
Request.UserAgent.ToUpper().Contains("lg-"))
{
Response.Redirect("http://app.mobile.com/shops/web/shop");
}
And here's my master file which I keep breaking when I try inserting the code above:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Web.Caching;
using System.Xml;
/// <summary>
/// Summary description for default
/// </summary>
public partial class _default : System.Web.UI.Page
{
private string FeaturedXmlDocPath = ConfigurationSettings.AppSettings["ShopWebsitePath"].ToString() + @"\bake\xml\featured_recipe.xml";
protected void Page_Load(object sender, EventArgs e)
{
XmlDocument MyDoc = GetXmlDoc();
FeaturedImage.ImageUrl = "~" + MyDoc.SelectSingleNode("/featuredRecipe/homepageImageUrl").InnerText;
FeaturedLink.NavigateUrl = "~/bake/recipe.aspx?id=" + MyDoc.SelectSingleNode("/featuredRecipe/recipeId").InnerText;
//FeaturedLink.NavigateUrl = "~/bake/default.aspx";
}
private XmlDocument GetXmlDoc()
{
if (Cache["FeaturedXmlDoc"] != null)
{
Trace.Write("FeaturedXmlDoc from cache");
return (XmlDocument)Cache["FeaturedXmlDoc"];
}
else
{
Trace.Write("FeaturedXmlDoc from file system");
// Load the document from the file system
XmlDocument MyDoc = new XmlDocument();
MyDoc.Load(FeaturedXmlDocPath);
// Create cache file dependency
CacheDependency MyDepends = new CacheDependency(FeaturedXmlDocPath);
// Insert doc and dependency object to cache
Cache.Insert("FeaturedXmlDoc", MyDoc, MyDepends);
// return the doc
return MyDoc;
}
}
}
I would really appreciate any help or direction you could provide.
Thanks so much!
Tammy
|
|
|
|
|
Tammy Marchi wrote: Hi there! I'm pretty much unfamiliar with .net and our developer is out.
You should rather ask to be out forever.
I really have never seen so may OR conditions ever.
Try putting the code here in your master page...
protected void Page_Load(object sender, EventArgs e)
{
XmlDocument MyDoc = GetXmlDoc();
FeaturedImage.ImageUrl = "~" + MyDoc.SelectSingleNode("/featuredRecipe/homepageImageUrl").InnerText;
FeaturedLink.NavigateUrl = "~/bake/recipe.aspx?id=" + MyDoc.SelectSingleNode("/featuredRecipe/recipeId").InnerText;
}
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.
|
|
|
|
|
You are my hero! Thank you so much!
|
|
|
|
|
You should start learning ASP.NET[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
Gentleman:
I just added a Java window to an ASP web page which shows an enlarged graphic. This works perfectly in Explorer, however it does something unusual in Firefox. Firefox opens a user request interface which asks the following:
What should Firefox do with this file:
Open With ... etc
or
Save
Neither option will open the new graphic in the Java window as it does in Explorer. Following is the code that I am using to open call the Window and get the graphic:
IN THE HEADER
<%--Large WIndow Scripts --%>
<script type="text/javascript">
function OpenLargeWindow1(image)
{
window.open("Ads/" + image, "", " width=760,height=300,top=200,left=200,scrollbars=0").focus();
}
</script>
IN THE BODY
<a href="javascript:OpenLargeWindow1('gears33.png')">
<asp:Image ID="Image18" runat="server" ImageUrl="~/Ads/plus_sign.png" /></a>
Does Firefox require a proprietary code or what option in the select process will put the graphic in the window if any? OR ???.
Any insight to this dilemma is appreciated.
Thank You, Pat
modified on Friday, August 7, 2009 1:24 PM
|
|
|
|
|
Hi I need a expression which does not contains the following characters \ / : * ? " < > |
Pankaj
|
|
|
|
|
|
Subject says it: I'm having trouble tying into the "onLoad" client side event of a stock 1.1 DataGrid. What I'm trying to do seems to be pretty basic, but the Grid is being very stubborn
What I have on the server page:
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
dgBillDeterminant.Attributes.Add("onLoad", "loadGrid();")
End Sub
"loadGrid()" is a javascript method contained within "GridBehavior.js" that is src'd into the ascx markup page. Currently, it just declared a var x and sets it = 1 in hopes of checking for access to the function, but the breakpoint is never being hit.
....yes, Client side script debugging is enabled through IE,
and yes, "GridBehavior.js" is displaying in my running documents when execution reaches my page.
Can anyone provide an example of how this event and handler should be stitched together?
"I need build Skynet. Plz send code"
|
|
|
|
|
You can try out the approach as I posted earlier..Can you tell me what you are trying achieve at runtime?
If you want to do some look and feel changes in the Grid at runtime then check out [^].
modified on Friday, August 7, 2009 12:11 PM
|
|
|
|
|
Hi All
I have one doubt,how to pass array to javascript function from asp.net aspx.cs page.can you help me?
Thanks in Advance
|
|
|
|