ASP.NET Discussion Boards

Re: fetching multiple records in Gridview

Harini N K30-Apr-08 1:28

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

Re: fetching multiple records in Gridview

Kartik Rathi30-Apr-08 1:57

Kartik Rathi

30-Apr-08 1:57

Thank u sir

Re: fetching multiple records in Gridview

senthilsstil30-Apr-08 2:22

senthilsstil

30-Apr-08 2:22

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

Re: fetching multiple records in Gridview

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

eyeseetee

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

Re: setting css in c#

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

Re: setting css in c#

eyeseetee30-Apr-08 0:23

eyeseetee

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?

Re: setting css in c#

eyeseetee30-Apr-08 0:29

eyeseetee

30-Apr-08 0:29

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

Re: setting css in c#

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

about session variable in asp.net 2005

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

eyeseetee

29-Apr-08 23:20

Dont you need an if statement to check if its blank

if(value == "")
{

}
else
{
}

Re: Datalist problem

yogesh_kumar_agarwal29-Apr-08 23:23

yogesh_kumar_agarwal

29-Apr-08 23:23

Thanks for Reply

Yes it has to done but first i have to fetch the value to compare, the problem is in fetching the the once it come then only i could compare it

with regards

Yogesh Agarwal

Getting error in compare datareader value and string value

Member 387988129-Apr-08 22:52

Member 3879881

29-Apr-08 22:52

Im getting error in compare place of datareader value and string value;
That i mentioned in bold letters:
Error Msg:The name 'dr' does not exist in the current context

private bool SiteLevelCustomAuthenticationMethod(string UserName, string Password)
{

bool boolReturnValue = false;

string strConnection = "server=(local);Database=WorkOut;User ID=sa;Password=bumi";

SqlConnection Connection = new SqlConnection(strConnection);

string strSQL = "Select User,pwd From Main";

SqlCommand command = new SqlCommand(strSQL, Connection);

SqlDataReader Dr;

Connection.Open();

Dr = command.ExecuteReader();

while (Dr.Read())
{

if ((UserName == dr[0].ToString()) & (Password == dr[1].ToString()))
{

boolReturnValue = true;

}
Dr.Close();

return boolReturnValue;

}

}

Thanks & Regards,
NeW OnE,
please don't forget to vote on the post

Re: Getting error in compare datareader value and string value

^1.21 Gigawatts29-Apr-08 22:54

^1.21 Gigawatts

29-Apr-08 22:54

You may want to the use Equals() method of the string class, as that will compar the value of the two strings not the reference. Smile | :)

Re: Getting error in compare datareader value and string value

Guffa29-Apr-08 23:24

Guffa

29-Apr-08 23:24

The == operator is overridden for strings to call the Equals method. This is done so that you can use the == operator for strings, so there is no reason not to.

Despite everything, the person most likely to be fooling you next is yourself.

Re: Getting error in compare datareader value and string value

Blue_Boy29-Apr-08 23:03

Blue_Boy

29-Apr-08 23:03

Change first letter to upper of datareader in your if condition.

.<br />
.<br />
.<br />
if ((UserName == Dr[0].ToString()) & (Password == Dr[1].ToString()))<br />
{<br />
<br />
boolReturnValue = true;<br />
<br />
}<br />
.<br />
.<br />
.

I Love T-SQL

How to handel this(The channel 'tcp' is already registered.) Exception in remotin

Piyush Vardhan Singh29-Apr-08 22:51

Piyush Vardhan Singh

29-Apr-08 22:51

How to handel this(The channel 'tcp' is already registered.) Exception in remoting

Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com

Re: How to handel this(The channel 'tcp' is already registered.) Exception in remotin

eyeseetee29-Apr-08 22:54

eyeseetee

29-Apr-08 22:54

Can you a bit more specific, what are you trying to do?

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