|
What s the difference between Database operations with Stored procedures and Direct Queries?
|
|
|
|
|
Stored procedure is a pre compiled query. So, it is much faster than the direct queries
Balasubramanian K.
|
|
|
|
|
K. Can u give a simple example on how to write stored procedure and how to call from Dotnet? Or any other reference?
modified on Friday, March 6, 2009 1:44 AM
|
|
|
|
|
Google it.
You will get a lot more than you are expecting from here.
|
|
|
|
|
Hi,
i need to set the prevoisly selected date colour to be green and the current selection of the date colour to be red i tried as
protected override void CreateChildControls()
{
Calendar1.SelectedDayStyle.BackColor = System.Drawing.Color.Red;
Calendar1.DayRender += new DayRenderEventHandler(Date_Create);
}
public void Date_Create(Object Src, DayRenderEventArgs EvmArg)
{
if (ViewState["PrevCell"] == null)
ViewState["PrevCell"] = EvmArg.Cell;
else
{
EvmArg.Cell.BackColor = System.Drawing.Color.Green;
ViewState["PrevCell"] = EvmArg.Cell;
}
}
but it is changing over the entire control, i want to set for only current selection and prevois selection
Thanks in Advance
Regards,
Jeeva
|
|
|
|
|
Hi all,
any one please tell me, any performance differences or any difficulties in a web application, when we set constraints, foriegn key, uneiq key in sql server.
I'm doubt because lot of small organizations when they develop windows application s/w ,they will use these.
But when they create web application they avoid these unieq key, constraints etc.
Plz let me clear..
|
|
|
|
|
Ha_80 wrote: I'm doubt because lot of small organizations when they develop windows application s/w ,they will use these.
But when they create web application they avoid these unieq key, constraints etc.
I never knew that the way you ran your database changes based on you UI...
Where did you get that information?
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Can anyone tell me where I might find the assembly for HITINFO? I have created a code snippet as seen below that utilise the HITINFO method to prevent Denial of Service attacks but I keep getting the following error:
"The type or namespace name "HITINFO" could not be found, are you missing an assembly reference?"
public static bool IsValid(ActionTypeEnum actionType)
{
HttpContext context = HttpContext.Current;
if(context.Request.Browser.Crawler)return false;
string key = actionType.ToString() + context.Request.UserHostAddress;
var hit = (HitInfo)(context.Cache[key]?? new HitInfo());
if(hit.Hits == 1)
{
context.Cache.Add(key, hit, null, DateTime.Now.AddMinutes(DURATION), System.Web.Caching.Cache.NoSlidingExpiration, System.Web.Caching.CacheItemPriority.Normal, null);
}
return true;
}
Illegal Operation
|
|
|
|
|
Hi all,
I am using iis 5.1 and my application is in two part one is in asp.net net and another one is asp.net + ASP. My first application is woking fine but when i am calling the asp page then getting the server application error 404 . I try to debug the code then getting this exception .
system.platformnotsupported exception and "This operation requires IIS integrated pipeline mode".
Please help me out. its very urgent i am working with this error since one week.
Thanks with regards,
Jitendra
|
|
|
|
|
Hi Jitendra,
If you are using Server.TransferRequest this cannot be used on any versions of IIS below version 7. If you are then this is the error you will get.
Please post the code that you are using when you receive the error.
Regards
Julian Mummery
Please Visit my FREE Bug / Fault Logging Website at FaultLogger.com
|
|
|
|
|
i am using the same code for calling the .aspx page but when i am trying to call those aspx page which having the asp file call those are not working.
please let me know.
|
|
|
|
|
Hi,
Please confirm, are you using Server.Transfer? yes or no.
Regards
Julian Mummery
Please Visit my FREE Bug / Fault Logging Website at FaultLogger.com
|
|
|
|
|
no i am not using server.transfer
this is my code
Response.Cache.SetCacheability(HttpCacheability.NoCache);
if (HttpContext.Current.Items[Constant.Authorization] == null ||
!(bool)HttpContext.Current.Items[Constant.Authorization]) Response.Redirect(Constant.AccessRequestPage);
|
|
|
|
|
How are you calling your asp pages? Asp and asp.net run on different engines. you can not directly interact between them. You can redirect calls from one to another. If you show us how you doing it, it will give us some clue as to what you trying to do.
I have asp + asp.net running side by side. I interact between them, when I move from one to the other, I save my session state to db then call
Request.Redirect("somepage.aspx?someparameter) (I call both somepage.asp and somepage.aspx the same way)
then on the other side I load my session state read what I need to get and continue doing what I need to do.
Yusuf
|
|
|
|
|
my applicaion is running and working fine on microsoft server 2003 that is the dev,qa server . but my desktop having xp and IIS 5.1 so is it require any setting in iis for executing the ASP pages because only asp pages are not runing in my application.
Thanks...
|
|
|
|
|
Its because Only IIS7 supports the integrated pipeline. you cannot run this on IIS 5.1
Regards
Julian Mummery
Please Visit my FREE Bug / Fault Logging Website at FaultLogger.com
|
|
|
|
|
my applicaion is running and working fine on microsoft server 2003 that is the dev,qa server . but my desktop having xp and IIS 5.1 so is it require any setting in iis for executing the ASP pages because only asp pages are not runing in my application.
Please suggest me what i need to do.
thanks.....
|
|
|
|
|
on your xp desktop, try the following:
1. Disable IE show friendly error messages from the advanced page
2. Open IE and type the following http:\\localhost\
this should redirect you to http://localhost/localstart.asp. If you see the page ok, then asp is running on your xp, if not what error message do you see. that should give you some clue.
If you see http:\\localhost ok, then make sure your asp program is installed properly in your xp machine. make sure any COM objects it uses are configured and registered properly.
Yusuf
|
|
|
|
|
HI,
i am created one test solution for checking purpose whether asp is working or not . I am getting this error in test application
Server Error in '/WebSite1' Application.
--------------------------------------------------------------------------------
This type of page is not served.
Description: The type of page you have requested is not served because it has been explicitly forbidden. The extension '.asp' may be incorrect. Please review the URL below and make sure that it is spelled correctly.
Requested URL: /WebSite1/Default2.asp
|
|
|
|
|
|
then you need to configure IIS to serve asp pages see here for details[^]
Make sure 'Active Server Pages' are allowed, see the picture.
Yusuf
|
|
|
|
|
Yusuf,
Actually my IIS dont have these option "Application pools" and "Service web extentions" .
please see your link which you sent me.
what i need to do ...
|
|
|
|
|
read the whole article. There is more than the picture in it. There are plenty of other resources on that page.
Yusuf
|
|
|
|
|
Yusuf wrote: There is more than the picture in it.
Lol, beautiful!
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
I have an ASP Login control contained in a UpdatePanel. What I need to do is call a javascript function when the Login control's onauthenticate event is fired. I tried adding the following to the Login control definition:
onauthenticate="authenticate(this, e)"
The problem is that when I try to run the application I receive an error that argument e is undefined in the current context. How can I do this?
Thanks,
Steve
modified on Thursday, March 5, 2009 5:29 PM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
