Re: SQL NOT WORKING - ASP.NET Discussion Boards

Custom /efficient paging and sorting gridview

mark_me7-Aug-09 17:33

7-Aug-09 17:33

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

Re: Custom /efficient paging and sorting gridview

N a v a n e e t h7-Aug-09 17:59

N a v a n e e t h

7-Aug-09 17:59

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.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Re: Custom /efficient paging and sorting gridview

mark_me7-Aug-09 18:19

mark_me

7-Aug-09 18:19

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,

Re: Custom /efficient paging and sorting gridview

N a v a n e e t h7-Aug-09 18:30

N a v a n e e t h

7-Aug-09 18:30

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. Smile | :)

Navaneeth

How to use google | Ask smart questions

Re: Custom /efficient paging and sorting gridview

mark_me7-Aug-09 18:57

mark_me

7-Aug-09 18:57

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

SQL NOT WORKING

greendragons7-Aug-09 9:30

greendragons

7-Aug-09 9:30

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... Frown | :(

Re: SQL NOT WORKING

Abhijit Jana7-Aug-09 10:36

Abhijit Jana

7-Aug-09 10:36

This is nothing to do with ASP.NET. Please ask your questions in General DB Forum.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: SQL NOT WORKING

Abhishek Sur7-Aug-09 10:49

Abhishek Sur

7-Aug-09 10:49

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. Thumbs Up | :thumbsup:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

wraper controls

greendragons7-Aug-09 9:22

greendragons

7-Aug-09 9:22

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?

Re: wraper controls

Abhijit Jana7-Aug-09 10:39

Abhijit Jana

7-Aug-09 10:39

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

Big Grin | :-D

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Re: wraper controls

greendragons7-Aug-09 10:47

greendragons

7-Aug-09 10:47

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*

Re: wraper controls

Abhijit Jana7-Aug-09 11:07

Abhijit Jana

7-Aug-09 11:07

Yeah, let me know if you have any issue.

Here is some sample for you
AJAX Accordin Control[^]
Accordin Control Video[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Access frames on different domain from Frameset

Hemant_ec487-Aug-09 9:15

Hemant_ec48

7-Aug-09 9:15

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.

Re: Access frames on different domain from Frameset

Leonardo Muzzi7-Aug-09 10:30

Leonardo Muzzi

7-Aug-09 10:30

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

how to Retrieve Metadata in office Document using MS Index Services

alisolution7-Aug-09 8:31

alisolution

7-Aug-09 8:31

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. D'Oh! | :doh:

Adding Code to a Page Load Event

Tammy Marchi7-Aug-09 8:04

Tammy Marchi

7-Aug-09 8:04

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

Re: Adding Code to a Page Load Event

Manas Bhardwaj7-Aug-09 8:18

Manas Bhardwaj

7-Aug-09 8:18

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)
{
//
//put your code here
//
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";
}

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.

Re: Adding Code to a Page Load Event

Tammy Marchi7-Aug-09 12:05

Tammy Marchi

7-Aug-09 12:05

You are my hero! Smile | :)

Thank you so much!

Re: Adding Code to a Page Load Event

Blue_Boy7-Aug-09 13:13

Blue_Boy

7-Aug-09 13:13

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

Opening Java Window - Explorer v Firefox Conflict [modified]

PDTUM7-Aug-09 7:17

PDTUM

7-Aug-09 7:17

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

Regular expression in asp.net

Pankaj Saha7-Aug-09 5:13

Pankaj Saha

7-Aug-09 5:13

Hi I need a expression which does not contains the following characters \ / : * ? " < > |

Pankaj

Re: Regular expression in asp.net

Arindam Sinha7-Aug-09 6:02

Arindam Sinha

7-Aug-09 6:02

Did you try to Google or search in CodeProject with the subject 'Regular expression in asp.net'?
Microsoft itself provides good articcles which I got in the first search result in Google with your subject -
1. Regular Expressions in ASP.NET[^]
2. How To: Use Regular Expressions to Constrain Input in ASP.NET[^]

There is another good article in CodeProject itself -
The 30 Minute Regex Tutorial[^]

Instead of asking somebody spare at least 30 mins.

Regards,
Arindam Sinha
MyBlog - http://arindamsinha.wordpress.com/
Please give your feedback on this answer.

1.1 DataGrid client side - Need help tying into DataGrid's client side "onLoad" event

Alaric_7-Aug-09 4:53

Alaric_

7-Aug-09 4:53

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"

Re: 1.1 DataGrid client side - Need help tying into DataGrid's client side "onLoad" event [modified]

Arindam Sinha7-Aug-09 5:52

Arindam Sinha

7-Aug-09 5:52

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 [^].

Regards,
Arindam Sinha
MyBlog - http://arindamsinha.wordpress.com/
Please give your feedback on this answer.

modified on Friday, August 7, 2009 12:11 PM

Passing Array to javascript from aspx.cs page

amarnath n.n7-Aug-09 4:02

amarnath n.n

7-Aug-09 4:02

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 Rose | [Rose]

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.