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.

OK OK I WILL DO THAT BECAUSE OF GOOD INTENTION BEHIND THAT. :(( Arun Jacob http://codepronet.blogspot.com/

To add to Dave K's point. I have used Access over a company intranet and found the performance pretty poor even with dedicated links. Over the internet I'd think it's a non-starter. :) Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis

Hi, I would make the column ruleset a LinkButton. In your aspx you create a TemplateField that has a LinkButton like: <asp:LinkButton runat="server" ID="lbRuleSet" CommandName="EditGrid" OnCommand="Grid_OnCommand" /> In the codebehind you create a Method like: protected void Grid_OnCommand(Object sender, CommandEventArgs e) { LinkButton btn = (LinkButton)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; if (e.CommandName.Equals("EditGrid")) { MyGridView.SelectedIndex = row.RowIndex; // now you have MyGridView.SelectedValue available and you can // display your details, as I believe you want to now the row the // user selected in stead of the clumnnumber it clicked MyGridView.SelectedIndex = -1; //to have no selectedrow again } }

window.open() is the only way to open multiple windows. no any other way to open them. you can use any extra tools for popup windows to display your recodrs which may be you can get from ajax toolkit.

Hi, For prob1, I didn't quite understand your question. I'm not sure how you can make all the rows of the query output be the headings of the datagrid. While displaying the query results, it will be displayed in the query analyser with the headings. That you can bind to the dataset and thereafter to datagrid,so the headings will display. Please correct me if I'm wrong. For prob 2, please try with the following code: A) In the HTML window, add the following code inside the datagrid declaration: AutoGenerateColumns="False" AllowPaging="True" BackColor="#C0C0FF" HorizontalAlign="Center" Height="376px"> ]]>'> ]]>' MaxLength="30"> //Days is the column header in the sql query. On the code behind, add the following code: private void dgrdEditDel_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { dgrdEditDel.EditItemIndex = e.Item.ItemIndex; FillGrid();// Function for filling the Grid } private void dgrdEditDel_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { dgrdEditDel.EditItemIndex = -1; FillGrid(); } Try the above code and let me know if you have any issues. Thanks, meeram395 :) Meeram395

hi devkranth, For that you have to use javascript, first you need to find out the P1 and P2 id of the panel using javascript eg. function switchpanel(panelno) { var p1=document.getElementById("P1"); //find out P1 with its client ID var p2=document.getElementById("P1"); //find out P2 with its client ID if (panelno==1) { p1.style.display="block"; p2.style.display="none"; } else { p1.style.display="none"; p2.style.display="block"; } call this script on dropdown_change event with scriptmanager as previously mentioned. }

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 pathan thanks 4 the reply.. i should make it false..... regards DEv

update tbladvance set check=false where ecode='1011' and type='festival' and check=true

value of recovery is nothing but the amount .... in table

Thats your wish... You can store by any type which is easy to you. Eg: You can store the SelectedValue(s) it as a string with delimiter like "2, 15, 20, 25" where comma(,) is the delimiter. You can split it when you want.. :cool: Regards, Venkatesh Mookkan. Software Engineer, India My: Website | Yahoo Group | Blog Spot

devkranth wrote: have one column in the database Then you need to normalise the data into two columns. Upcoming events: * Glasgow: Introduction to AJAX (2nd May), SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services... Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton My website

Use a timer to set the Visible property of the label to either true or false. Regards, Thomas Stockwell Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Visit my homepage Oracle Studios[^]

Hi, try and develop a Library Management System, It will have users like normal users and admin users. Books will be arranged under different categories or subjects. Users can view/dld etc books. Admin can upload books etc. Good Luck, Mubashir Every job is a self portrait of the person who did it.

hi jo I want the sqlquery in dmy format.... i used setdateformat dmy ; and my sql query..

thanks Pradeeop well will try it and get back soon..