hi experts, my stored procedure is very big...i want to debug it..when i start debugging it , i am getting the following error failed to start debugger additional information: error hresult e_fail has been returned from a call to a com component.(mscorlib) i googled regarding that...i am not able to debug... my db is remote sql server 2008 r2 coud anyone help me pls

hi, thanks for replying...by d way i am not hacking anyone's db...i tried my function...i succeeded in encrypting but couldn't succeed in decrypting it....ie i asked in this forum...once again thanks for replying...

hi experts, can anyone guide me ,how to decrypt the encrypted user defined function in sql server 2008

hi, thanks for replying

hi experts, i am trying to install vsn server 2.5.9 from the link http://www.visualsvn.com/visualsvn/download/[^] while installing vsn server i was asked to choose port no(2 port nos are displayed 443 & 8443).i have chosen 443 port no for https.so what i did is i removed https & selected 443 for visual vsn.now vsn is working fine.the issue i am facing is i am unable to run my application on iis using http.when i run my application i am getting "the address is incorrect,type the correct address".but the address is correct in the address bar.how to overcome this problem?if i want to run my application using https what port n do i have to choose?could anyone help me pls...

hi, can anyone suggest me the best book for mvc4 pls

hi, what i mean is user control page has extension as .ascx---here the expansion of ascx is "active server control extension" along the same lines .asax ----the expansion of asax is "active server application extension". in the same manner just i wanna know the expansin of axd in tracefilename.axd usually trace files have .axd extension i googled it but i am unable to find the answer.ie y i asked in this blog....

hi all , Tracing web application with ASP.NET[^] Tracing Methods • On the Page When this method is used, the trace output is displayed on the page that is executed. • Out of Page In this method, the tracing results are not displayed on the page but these are stored on the web server and in the root folder of the application in a file named as “trace.axd”. After execution of the pages, this file can be viewed on the browser. “trace.axd”.-----here what is the expansion of axd...

thanks its working

hi everybody, i have win7 ultimate and vs2010 ultimate....now i want to update to vs2010 SP1.....so that i can install mvc4... i tried the following links http://weblogs.asp.net/jgalloway/archive/2011/03/09/tips-on-installing-visual-studio-2010-sp1.aspx[^] http://www.microsoft.com/en-us/download/details.aspx?id=27130[^] i tried for more than 8 hrs both the links but not even 1% is installed... can anyone help me how to update vs2010 to vs2010 sp1....so that i can install mvc4... i tried to install vs2012 from asp.net/mvc/mvc4 link....for more than 7 hrs...from this link also i couldn't install... can anyone help me how to update vs2010 to vs2010 sp1...such that i can install mvc4 pls...i am trying for the past 3 days...

what is .net framework

hi everybody can anyone let me know what is worker process...and expansion of w3wp...how can i download it?i have VS2010,iis7,SQLSERVER 2008 R2..and win 7 ultimate OS...what is R2 in sqlserver 2008R2

hi everybody, in my sys i have ii6 is installed....now i want to upgrade it to iis7.5....my OS is win7 ultimate 64bit...and VS2010 and SQL 2008R2....can anyone help me pls....

now i have been instructed to use textboxes... now i am using the following code protected void Calendar1_DayRender(object sender, DayRenderEventArgs e) {if (e.Day.Date < DateTime.Today) { e.Day.IsSelectable = false; e.Cell.ForeColor = System.Drawing.Color.Gray; } else { e.Cell.ForeColor = System.Drawing.Color.Green; } if (e.Day.Date >= FromDate && e.Day.Date <= ToDate) { e.Cell.ForeColor = System.Drawing.Color.Red; } } protected void Button1_Click(object sender, EventArgs e) { FromDate = DateTime.ParseExact(txtFrom.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); ToDate = DateTime.ParseExact(txtTo.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); } when i run the application the dates which user enters are appearing in red color in calender...but the pbm i am facing is i vil stop running the application & once again re-run application...this time user entered dates are not in red color....they are in green color. the same pbm i faced when i was using dropdownlist....even now also, the same issue i am getting...even when i stop & rerun the application user entered dates should appear in red color...by seeing red color in calender user comes to know that those dates are already booked...so he vil enter other dates..when the user clicks on calender image ,all past dates shoud be disabled....and booked dates in red color and rest of the dates in green color...at the bottom of the page indication is given to user that gray colored dates are not selectable,red colored dates are already booked and green colored dates are available for booking....this is the concept i am using...pls guide me how to solve my issue....

it doesn't work

hi,my requirement is changed now...i have to use 2 textboxes namely txtFrom and txtTo.i vil enter dates in these 2 textboxes..the dates mentioned from txtFrom to txtTo shuld appear in red color.i am converting string to date by the following code DateTime FromDate = DateTime.ParseExact(txtFrom.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); DateTime ToDate = DateTime.ParseExact(txtTo.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); but how to implement in calender...pls give me any suggestion...

i mean , i vil select dates from dropdown lists namely ddlfrom and ddlto dropdownlists to book a room in hotel.in a calender these dates which are selected from the above mentioned dropdownlists should appear in red color...which indicates those dates are booked....available dates are in green color...only dates which are in green color the user can book....red colored dates he cannot book...i tried this in selection_changed event ...but i couldn't meet this requirement...

i am disabling past dates and remaining dates in green color with the following code

protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{if (e.Day.Date < DateTime.Today)
{

        e.Day.IsSelectable = false;e.Cell.ForeColor = System.Drawing.Color.Gray;
   }
   else
   {
       e.Cell.ForeColor = System.Drawing.Color.Green;
   } }

i have two dropdownlists ddlFrom and ddlTo.i vil select dates from these dropdownlists to book a room in a hotel.the dates fromdate to todate should appear in red color...any help is appreciated

hi i am disabling all past dates and remaining dates in green color with the following code

protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{

if (e.Day.Date < DateTime.Today)
{

        e.Day.IsSelectable = false;

e.Cell.ForeColor = System.Drawing.Color.Gray;
}
else
{
e.Cell.ForeColor = System.Drawing.Color.Green;
}

} i have two dropdownlists ddlFrom and ddlTo.i vil select dates from these dropdownlists to book a room in a hotel.the dates fromdate to todate should appear in red color...any help is appreciated

i don't know how to use if...exists i am new to asp.net & database as well my requirement is to get 3 consecutive working days declare @i int declare @count int set @i=0 set @count=0 while(@count <= 3) begin 1) select Holiday_Name from Holiday where Holiday_On = DATEADD(day,@i,CONVERT(date,GETDATE())) the above statement is to check whether holiday exists 2) IF DATEPART(day, DATEADD(day,@i,CONVERT(date,GETDATE()))) = 7 OR DATEPART(dw, DATEADD(day,@i,CONVERT(date,GETDATE()))) = 1 the 2nd statement is to check whether weekend or not set @i = @i + 1 if there no holiday and not weekend then only the following code is executed set @count = @count + 1 here i have to retrieve the date...i don't know how to get the date...because i vil get 3 dates... end actually i no need to select holiday name in 1)statement...there i am checking for holiday..