There is no possiblity of SP returning May_Aug through earlier call as there is no pro data available for this. Only APR-JUN , APR-SEP or JAN-MAR is possible. Moreover we are facing this junk data problem only for this report (where we have used one temp table tblMonthList) but other places on page load we face this issue. We are facing this issue on couple of other applications also which is hosted on the same server.

Well Thanks Bernhard .This is my Procedure Wat i Have Written ALTER Procedure[dbo].[sp_ListofMonths] @FrmDate varchar(20), @ToDate varchar(20) AS Begin set dateformat dmy; declare @dateDiff int, @mon int, @year int, @Tmon int, @TYear int, @i int set @mon = month(@FrmDate); set @year = year(@FrmDate); set @Tmon = month(@ToDate); set @TYear = year(@ToDate); set @dateDiff = datediff(m,@FrmDate,@ToDate) set @i = 0; delete from tblMonthList; while(@i <= @dateDiff) begin if(@year <= @TYear) if(@mon != 13) begin insert into tblMonthList(mon,yer) values (@mon,@year) set @mon = @mon + 1; set @i = @i + 1; end else begin set @mon = 1; set @year = @year+1; end end select CASE mon WHEN 1 then 'JAN' WHEN 2 then 'FEB' WHEN 3 then 'MAR' WHEN 4 then 'APR' WHEN 5 then 'MAY' WHEN 6 then 'JUN' WHEN 7 then 'JUL' WHEN 8 then 'AUG' WHEN 9 then 'SEP' WHEN 10 then 'OCT' WHEN 11 then 'NOV' ELSE 'DEC' END, mon,yer from tblMonthList end exec sp_ListofMonths '01/04/2010','30/06/2010'

Thanks Maxxx Yes, there could be other area on the page also where it is possible. There is no possiblity of SP returning May_Aug through earlier call as there is no pro data available for this. Only APR-JUN , APR-SEP or JAN-MAR is possible. For this particular page as it is being used for printing information we have not used AJAX.This problem is reported by the user rarely so it is very difficult to trace out. The doubt what i have..Can sql responce be modified through network or any other source?

Hi Everybody We have one Asp.net application developed using framework 2.0 with C#,Sql and AJAX. The application is running live from past 2 years almost. All the times users will be facing kind of strange problem, reporting some junk data will be displayed on the browser some times. When they refresh the page or reopen the browser, it will display the correct information. For Eg. We have a stored procedure which returns months between 2 dates, if we pass 2 dates as '01/04/2010' and '30/06/2010' then procedure will return 'APR,MAY,JUN'. One case we have noticed where it has returned and displayed as MAY,JUN,JUL,AUG which is not possible. Once we refresh or reopen the page it displays the correct information. This is one ex. whereas we have some other page also where we get unwanted values like that. If any one has come across such scenario ever, let me know what could be the problem and solution for this. :( :( :(

Hi all can any one Help On this i am using the gridview item template ,Edit itemTemplate,footer Template to insert the data into the DB i have developed a webservice which displays Cityname as the user types in the the character here is the code.. <asp:GridView ID="dg_masters" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal" ShowFooter="True" Width="746px"><AlternatingRowStyle BackColor="#C2D69B" /> <Columns> <asp:CommandField ShowEditButton="True" /> asp:TemplateField <ItemTemplate> </ItemTemplate> <FooterTemplate> <asp:Button ID="btnAdd" runat="server" CssClass="Button" Text="Add" OnClick="AddNewDesignation" ValidationGroup="abc" /> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Designation Code"> <EditItemTemplate> <asp:TextBox ID="txt_DesignationCode" runat="server" CssClass="textboxDisabled" Text='<%# Eval("Designation Code")%>' Enabled="false"> </asp:TextBox> <asp:RequiredFieldValidator ID="txt_Vld_designCOde" runat="server" ControlToValidate="txt_DesignationCode" Display="Dynamic" ErrorMessage="Designation Code" CssClass="Validators"> </asp:RequiredFieldValidator> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="txt_designationCode" runat="server" CssClass="textboxDisabled" MaxLength="3"> </asp:TextBox> <asp:RequiredFieldValidator ID="txt_Vld_designCode1" runat="server" ControlToValidate="txt_designationCode" Display="Dynamic" ErrorMessage="Designation Code" ValidationGroup="abc" CssClass="Validators">

Dear all i have this problem keeps coming often using inet control 12002 time out can any body give me the solution .its very urgent... i am using the inet control to download the data from remote server.. the main intention is to download the database rows from remote server to my local system which is in access database plzzzzzzzzzzzzzzzzzzzzzzzzzzzzz help me thanks in advance

hi all i have a problem please suggest me the solution i have a datagrid which consists of bounded columns i need to get the column number or column index datagrid sample is like this where heading channel and corporate are link buttons dynamically displayed slno | region Name |channel | corporate| 1 | abc |ruleset | forapproval 2 | a23 |ruleset | forapproval 3 | 2asdas |ruleset | forapproval 4 | adas |ruleset | forapproval so when i click on channel->ruleset i need to get the column no as 2.. based updon the column number i need to display the details if 2 then channel details else corporate details please .. its very urgent

hi all how to open multiple windows in asp.net.. pleas help i need to generate the same quotation for several partners like a,b,c,d... i am using this code in the save button ie.. how many records it inserts it should display the Quotaion or pop up the window... ClientScript.RegisterStartupScript(Me.GetType(), "Message", "<script>window.open('frmquotation.aspx?quot=" & ViewState("Order") & "&pid=" & partner.Text & "&Type=" & ddlLeadtype.SelectedItem.Text & "&custid=" & ViewState("CustIdCOrp") & " &sourceLead=" & ddlLeadSource.SelectedItem.Text & "&optprint=" & rdPrint.SelectedItem.Text & "','a' + new Date().getTime(),'resizable=1,scrollbars=yes,width=800,height=768')</script>", True) if there is any other way to display plz let me know..its very urrgent :(

hi thanks for u reply i cannot add textbox the template column coz i need to add the texboxes for those columns which are generated by The query(in the sense Heading) Prob 3: i need to dump the values into the database Table.. i needto insert all the datagrid items to the database table

hi thanks for u reply yeah i need to make whole rows to appear as datgrid

hi to all i have a problem please suggest me the solution prob1: i get some rows for one Query..(select..) i need to make this rows as my datagrid heading.. prob2 : and the datagrid should consists of text boxs datgrid FOrmat ==================================== col1 remaiming columns heading from the above Query ================================== a textbox textbox textbox b textbox textbox textbox prob3: Insert into the table

hi u can do like this open a new solution file with the name u wanted to be then right click on the project name(the recent one)in the Solution Explorer then select add exiting items then select all the Items of the old project.. i think this solves ur problem

hi amar thanks for u response.i think the first Case u said is not going to happen coz when i add an update panel to the P1 and p2 it gives me a message saying u have to add another Update panel the second option i am not clear can u briefly explain me..

hi laxmikant thanks for the response ... as u said i did the Same but the problem is when i debug the code the panels state are changing but it is not reflected in the Form...

hello every body i have a datagrid which is inside an Update panel, which contains a Dropdownlist with options "YES" and "No". on the Other End i have 2 panels namely p1 and p2 which is outside the UpdatePanel where p1 and p2 on form load visiblibity is set to False now my intention is to make p2 visbile=true on selecting the Dropdownlist which is inside the Datagrid Ex if dropdownlist ="YES" then p1.visible=true else p2.visible= false Thanks in Advance DevKranth

hi i have done my Project in VS 2005 .. i Precompiled it and uploaded to the Server. now i have changed the code in ONE aspx.vb file and i uploaded the Following Files bin directory precompiled aspx page Precompiled.web.. but i get an error am i following the Correct Method..i am wrong please suggest me the process help me Thanks in advance Regards devkranth

hi prasad i want to display the confirm message after he selects the id and updates the data The Flow is as follows 1.user clicks in edit the catpion is changed 2 Update 2.User Selects the id n accoording to the selected id the data is displayed in there respective textboxes 3.User Changes the neccessary data.. 4. When user clicks on the Update Button i need the Confirm Message DO u wantto update?

hi thanks for ur reply i am using it OnCLientClick Propety now wannt 2 update based upon the return value in the codebehind

hi folks... i am developing a project using Asp.net (2005) i Have a button called CmdEdit . and the caption(Text) will change from edit to Update when clicked on it.. now i need to use the confirmation using javascrpt when he clicks on update... Like Do u want To update and two buttons OK Cancel Totally i need to display a confirm box after he updates and clicks on update button thanks in advance :)

GOD Thanks ....... But Do Post it to nay Loacl NEWSPAPER NOt here