ASP.NET

fetching multiple records in Gridview

30-Apr-08 2:15

can you post your code

hi all

Ankit At Codeproject30-Apr-08 2:23

Ankit At Codeproject

30-Apr-08 2:23

hi friends i got the solution

solution is to create new ajaxenabledwebsite and then add all pages from simple website projects in it.

thanks to all of u

Re: hi all

N a v a n e e t h30-Apr-08 3:42

N a v a n e e t h

30-Apr-08 3:42

Ankit At Codeproject wrote:
create new ajaxenabledwebsite and then add all pages from simple website projects in it.

More easy solution would be copying the ajax enabled websites's web.config file to your current project and add necessary references. Smile | :)

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Kartik Rathi30-Apr-08 0:15

Kartik Rathi

30-Apr-08 0:15

I have 1000 records that i m showing in gridview.
i also implemented paging in gridview to show users 5,10,20,50 and all records per page.if user select 10 from drop down then 10 records are showing and when he clicks on next page then i fetched all the records again and show next 10 records.

How can i only fetched next 10 records,so that burden on database decreases.
Means after 10 records we should fetched 11 to 20 records only.

Can anybody provide me code to solve this problem.

Any help is greatly appreciated...

Harini N K30-Apr-08 1:28

Harini N K

30-Apr-08 1:28

Hi

Are you having any identity column (or serial number) field in your application?

Then you need to pass extra parameters like current page number and number of records per page to your SP and based on these parameters you can return results.

-- Calculate first and last record number

<br />
<br />
SET @FirstRec = (@CurrentPageIndex - 1) * CAST(@PageSize AS INT)<br />
SET @LastRec = (@CurrentPageIndex * CAST(@PageSize AS INT) + 1)<br />
<br />
SELECT *<br />
FROM Table1<br />
WHERE IDCol > @FirstRec AND IDCol < @LastRec

If @PageSize = 10 and @CurrentPageIndex = 1, then @FirstRec will be 0 and @LastRec = 11. So first page will return only 10 records

If @PageSize = 20 and @CurrentPageIndex = 1, then @FirstRec will be 0 and @LastRec = 21. So first page will return only 20 records and so on.

Hope this solves your problems.

Harini

Kartik Rathi30-Apr-08 1:57

Kartik Rathi

30-Apr-08 1:57

Thank u sir

senthilsstil30-Apr-08 2:22

senthilsstil

30-Apr-08 2:22

Hi Friend,
I can't get the logic,can you explain again.Please.....

Abhijit Jana30-Apr-08 1:39

Abhijit Jana

30-Apr-08 1:39

best way to use Cache.

Best Regards
-----------------
Abhijit Jana
Microsoft Certified Professional
"Success is Journey it's not a destination"

setting css in c#

eyeseetee30-Apr-08 0:06

30-Apr-08 0:06

Hi
I have the following code which sets the css in c#, but it doesnt seem to be working

public void btspec_click(object sender, EventArgs e)
{

btspec.Attributes.Add("on_click", "this.style.border-width:0px");
}
is this correct?
I want the button when clicked to have no border.

thanks

R. Giskard Reventlov30-Apr-08 0:14

R. Giskard Reventlov

30-Apr-08 0:14

Hmm: isn't it:

btspec.Attributes.Add("on_click", "this.style.border-width='0px'");

me, me, me

eyeseetee30-Apr-08 0:23

30-Apr-08 0:23

i tried that, but because Ive got it in an onclick event does that make a differene
I set the css in aspx page and then I want to be able to amend that through the c# if a user clicks on the button
am I going the right way about it?

eyeseetee30-Apr-08 0:29

30-Apr-08 0:29

Is there a way to disable a style through c#? this might help me

about session variable in asp.net 2005

R. Giskard Reventlov30-Apr-08 0:55

R. Giskard Reventlov

30-Apr-08 0:55

The same but style.border='none';

me, me, me

Http post error???

Dotnetkanna30-Apr-08 0:01

Dotnetkanna

30-Apr-08 0:01

Hi Everyone,
while i am running the application i getting the following error.any suggestion?

Server Error in '/CombinedSolowest' Application.
--------------------------------------------------------------------------------

The HTTP verb POST used to access path '/CombinedSolowest/addtocart.aspx_22010007' is not allowed.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The HTTP verb POST used to access path '/CombinedSolowest/addtocart.aspx_22010007' is not allowed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): The HTTP verb POST used to access path '/CombinedSolowest/addtocart.aspx_22010007' is not allowed.]
System.Web.DefaultHttpHandler.BeginProcessRequest(HttpContext context, AsyncCallback callback, Object state) +463
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +505
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +191

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

Re: Http post error???

Vasudevan Deepak Kumar30-Apr-08 1:46

Vasudevan Deepak Kumar

30-Apr-08 1:46

The form target appears like a foldername with the METHOD as POST. Are you building the target ane missing out something?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

M.Ramesh30-Apr-08 0:00

M.Ramesh

30-Apr-08 0:00

Hai,

There u will find that session variables is only working on the same page but it is not transfering the value to other page. anybody help.

Regards
Ramesh

Re: about session variable in asp.net 2005

yogesh_kumar_agarwal30-Apr-08 0:03

yogesh_kumar_agarwal

30-Apr-08 0:03

Session variable will available till session is available on your site, if there is no user concept then the variable will never distroy till you close your browser.

Re: about session variable in asp.net 2005

M.Ramesh30-Apr-08 0:21

M.Ramesh

30-Apr-08 0:21

Dear Friend,

I am not able to handle the session variable from one page to the next page. Why it is not possible. What is the reason to handle the session in different pages (ie.in iframe pages)

thanks & Regards
Ramesh

Control 'ctl00_Menu1' of type 'Menu' must be placed inside a form tag with runat=server.

Member 419490629-Apr-08 23:37

Member 4194906

29-Apr-08 23:37

hi i am making a web site in VS 05 and when i add a menu i get this message when i rum the site

Server Error in '/WNC' Application.
--------------------------------------------------------------------------------

Control 'ctl00_Menu1' of type 'Menu' must be placed inside a form tag with runat=server.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Control 'ctl00_Menu1' of type 'Menu' must be placed inside a form tag with runat=server.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): Control 'ctl00_Menu1' of type 'Menu' must be placed inside a form tag with runat=server.]
System.Web.UI.Page.VerifyRenderingInServerForm(Control control) +214
System.Web.UI.WebControls.Menu.Render(HtmlTextWriter writer) +37
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +53
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +280
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +24
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +21
System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +53
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +280
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +24
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +21
System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +53
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +280
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +24
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +21
System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +53
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +280
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +24
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +21
System.Web.UI.Control.Render(HtmlTextWriter writer) +7
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +53
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +280
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +24
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +199
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +21
System.Web.UI.Page.Render(HtmlTextWriter writer) +27
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +53
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +280
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +24
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +7425

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

This is the code i am useing to impliment the menu

<asp:Menu ID="Menu1" runat="server" DataSourceID="SiteMapDataSource1" Height="83px" Width="203px">

</asp:Menu>

jAgAdEeP.sUgGuLa

Re: Control 'ctl00_Menu1' of type 'Menu' must be placed inside a form tag with runat=server.

R. Giskard Reventlov29-Apr-08 23:48

R. Giskard Reventlov

29-Apr-08 23:48

The message is telling you what the problem is.

Try it like this:

<asp:menu id="Menu1" runat="server" datasourceid="SiteMapDataSource1" height="83px" width="203px">

me, me, me

Datalist problem

yogesh_kumar_agarwal29-Apr-08 22:59

yogesh_kumar_agarwal

29-Apr-08 22:59

Hi All

I use the datalist control on my page used to display the value of database now some of the value are blank("") so i want to check for the same and if the value is blank or null then i want to change the color for that cell is yellow.

i got the follwoing it its not work. plz reply what is incorrect with that and what i have to do to find the solution i mentioned above.

<br />
<br />
Label l1 =  e.Item.FindControl("Correct_AnswerLabel").;<br />
            Response.Write(l1.Text);<br />
<br />
<br />
<br />

With Regards

Yogesh Agarwal

Re: Datalist problem

eyeseetee29-Apr-08 23:20