niall29

Thanks This looks like what I am after.

Hi all Can any one tell me how I can force a web page created in ASP.NET to open maximized.

Actually that does seem to be what I am looking for. Let me see if I am understanding it. I always had the whole tree populating at the form load but from what I understand is you populate it as you click the Parent node. If I am write how would that work on a search feature which should open the tree to show that employees position.

Hi I hope somebody can help me but I want to make a treeview that can have endless levels. I made my original tree which had 5 levels but now our company is growing and there are some depts that have 7 or 8 levels and growing. I was using If Mang_ID = Person_ID in my tree is there away that I could make it instead of (Example) Childnode, childnode 2 etc I could make the number an integer and put it on a loop In theory I think this should work but unfortunately I cant get it to work in practice. Any help would be greatly appreciated.

Thanks I will look at it. I have never used it before, I know Im being a bit of a pain but can you give me any examples how to use it

It is only a site on the Intranet which we would prefer if agents didnt see so I have set it up as. <authentication mode="Windows" /> <authorization> <allow roles="Management " /> <deny users="*" /> </authorization> and if you are in management it will go to the page and if your not it will go to the Unauthorized page. Or what would you recommend??

But that is the problem, I don't want to give them a form to log on. I want it to check their Windows logon and if it doesn't have authentication then redirect to the other page and not give the form for an alternative signon.

I have a site on the intranet at work and what I am trying to do is when an employee does not belong to a Group which is Authorized to look at a page it will go directly to the Page that says unauthorized instead of giving them 3 chances to log in. Please can some body help. Thanks in advance

dont know if this is even possible but here it is...... I want to use a datepicker to enter a date but on the calendar I want it to highlight every second Friday in RED. Any help would be greatly appreciated...... Thanks in Advance Oh This a a Windows application.

Im not sure about how to go about it Have you any ideas

I dont know if this is even possible but here it is...... I want to use a datepicker to enter a date but on the calendar I want it to highlight every second Friday in RED. Any help would be greatly appreciated...... Thanks in Advance Oh This a a Windows application.

But I dont have Excel installed on the IIS Server. It doesnt let me call Excel.AutoFilter. Do you know, Do I have to install Excel on the IIS server.

I am actually having 2 problems: 1 When I do the export to SQL the Accnt # (16 digits) eports to excel like 1.11111E +15. 2. Turning on Auto filter The code I am using is like. Response.ContentType = "application/vnd.ms-excel" ' Remove the charset from the Content-Type header. Response.Charset = "" ' Turn off the view state. Me.EnableViewState = True Dim tw As New System.IO.StringWriter Dim hw As New System.Web.UI.HtmlTextWriter(tw) ' Get the HTML for the control. DataGrid1.RenderControl(hw) ' Write the HTML back to the browser. Response.Write(tw.ToString()) ' End the response. Response.End() ' Response.ContentType("A:A")Selected) End If Conn.Close() End Sub If you need any more let me know but I think this should give the basic idea.

As you can see by my code below I tried a few ideas befor I got it to work see if this helps you or if you need more info I will try yo make in to better English. DataGrid1.DataSource = RDR DataGrid1.DataBind() DataGrid1.Visible = True ' Verify if the page is to be displayed in Excel. If Label1.Text = "1" Then 'Dim xl As New Excel.Application 'Dim wbk As Excel.Workbook 'xl.Visible = True 'wbk = xl.Workbooks.Add 'wbk.Sheets.Add() '' wbk.ActiveSheet.Cells(1, 1).AutoFilter() 'wbk.ActiveSheet.Cells(1, 1).CopyFromRecordset(DataGrid1) ' If Request.QueryString("bExcel") = "1" Then ' Set the content type to Excel. Response.ContentType = "application/vnd.ms-excel" ' Remove the charset from the Content-Type header. Response.Charset = "" Response. ' Turn off the view state. Me.EnableViewState = True Dim tw As New System.IO.StringWriter Dim hw As New System.Web.UI.HtmlTextWriter(tw) ' Get the HTML for the control. DataGrid1.RenderControl(hw) ' Write the HTML back to the browser. Response.Write(tw.ToString()) ' End the response. Response.End() ' Response.ContentType("A:A")Selected) End If Conn.Close() End Sub

I have a web page with a datagrid of results from a query, then with a press of a button it exports the details to Excel which is working great but I want it when the page loads it automatically turns on Auto filter. Can any one help me with this. Any help would be greatly appreciated.

Hi Again, and thanks for all your help so far with this project. So far I have been able to pull all the info I need and export it to an excel file. My question is How can I activate auto filter in my code because when my mangers gets the file that is the first thing they do and if possible I would like to automate that. but am having no luck trying to figure it out. Thanks in advance for any help.

Hello all, I am using Page.Response to on a click event to open a webform and to carry info from the first page and put it into the Second, but the second page opens in the same window as the first. Is it possible to open the second page in a new window using VB code or what would be the best way to do it. Thanks in advance

I have tried Google but and found some that work if you populate the datagrid on a form_load event. but I need users to be able to pick what they want to query and then press a button to populate the datagrid. I am presently working on sending a query from one page to a form_load of another page if I can get that to work I should be good. so if anyone knows a better way or can help me with this way, Please let me know Thanks

I am still stuck at getting a datagrid to export to an Excel file. I have found ways to do it if your datagrid populate on the page load event but mine doesnt it poulates on a button_click event. So I have 2 questions and you can pick what ever is the easiest or best to use as I dont know. 1. How can I change a query on a page load_event from another page to populate a datagrid. or 2.Or if I can export my datagrid to an excel file after it populates from a button_click event. Any help will be Highly appreciated

I dont mean to be a pain but I have just discovered IFrames and want to know how can I press a button on one form which will fill a say fill text in on another.

Thanks I will try that

You are right with radio buttons you have to pick one. but when the form opens none of them have been picked yet. You see I have the Radiobuttonlist set to a table and what I plan to do is link that table to another table of field names so when they pick Search by first name it will know to search the field F_name and if the user picks Last Name then it knows to search L_name but I do not want to use If and Else IF statements because what I am trying to do is Allow the user to put in new search categorys without having to change the code. i hope this helps to understand what Im trying to do and maybe its not possible but I will never find out unless I try.

This is probably a silly question but I want to say if nothing is selected in the Radiobuttonlist. it will display a message box saying you need to pick one" I can get the message box but I dont know how to say if nothing is selected.

Ok I dont know if it is always this way but when I used a server user login in stead of a domain/User it works but I still have a problem with the login box coming up when you open the page. Which I dont want.

Tried it and still doesnt work. I am pulling my hair out. I cant understand what is wrong.