|
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
|
|
|
|
|
|
Hi Friend,
I can't get the logic,can you explain again.Please.....
|
|
|
|
|
best way to use Cache.
Best Regards
-----------------
Abhijit Jana
Microsoft Certified Professional
"Success is Journey it's not a destination"
|
|
|
|
|
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
|
|
|
|
|
Hmm: isn't it:
btspec.Attributes.Add("on_click", "this.style.border-width='0px'");
|
|
|
|
|
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?
|
|
|
|
|
Is there a way to disable a style through c#? this might help me
|
|
|
|
|
The same but style.border='none';
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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">
|
|
|
|
|
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
|
|
|
|
|
Dont you need an if statement to check if its blank
if(value == "")
{
}
else
{
}
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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 remoting
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
Can you a bit more specific, what are you trying to do?
|
|
|
|