Search results

  1. T

    Quick sql 2005 query question

    This is a basic example of what I'm trying to achieve. One table Table TEMP ID Date 1 1/15/2007 2 1/25/2007 3 2/16/2007 4 2/25/2007 I want to return the most recent date within each month. so I want 2 1/25/2007 4 2/25/2007 SELECT Date, ID FROM temp AS ut...
  2. T

    Oracle autonumber question

    How do you generate a autonumber that needs to be put in more than one table to create a relationship? For example I have 3 tables. TBgenData Proj_Num* Proj_Name TBdate Date_ID* Proj_Num Date TBfinancial Fin_ID* Date_ID YTD_Budg In this case, the Date_ID needs to be...
  3. T

    Search for a string in a HTML file c#

    Is is possible to search out a string with a start and end and grab everything between? It starts with /content/ ends is /NAME.tmp.x.xls so I want to grab window.open('/content/RANDOMESTUFF/NAME.tmp.x.xls', This is out of a html file and there can be anywhere from 1 to 30...
  4. T

    How to stop IE6 from auto launching excel file downloads

    I want to revert back to asking me to save the file instead of automatically opening it. I've looked through the security features and I have tried every option in there. Any ideas? Thanks
  5. T

    Dynamic loading multiple pie charts

    How would I go about loading more than one pie chart by reading a database. I know it would be some kind of loop to get the data but I have no idea how to render them? http://www.carlosag.net/Tools/...art/sampleDataSet.aspx I'm using this.. The part that would need to be looped is...
  6. T

    IE6 automatically opens excel files how to reset?

    Is there anyway to reset the settings in IE6 to get excel files to ask me if I want to download it? When I download it now, it automatically opens. Thanks.
  7. T

    Creating a XML file with arrays in C#

    I have a question. say I have 2 arrays. arrayNames arrayContent so arrayNames has ProjectName, ProjectID, ProjectDate and arrayContent has Server Implementation, 123, 05/30/07 I want to loop through and create a XML file. The other thing is, there are more then one project so I...
  8. T

    find replace in c# with a certain character.

    I have a issue with extracting some cells from c#. When I open what I make in excel, the csv does some new lines or something and causes excel not to do CSV correctly. I opened the file in wordpad and I found that there are some box characters [] < Like that but a full box. So I did a...
  9. T

    Passing a array piece to a function

    Hi, let's say I have an array and cellData[5], cellData[7], and cellData[15] need to be passed off to a function to format it right. In this case, it's a date from excel, but it doesn't convert right, 10/27/2007 turns into 39545 or something. So I have a piece of code that can convert it...
  10. T

    Reading an Excel sheet by cell in c#

    I've been looking online and I still am stuck. I'd like to select certain cells out of 50+ excel files. Each file is the same, just different numbers. So say I want to extract A1, B5, C7, D9 etc..... What is my best approach? I found some c# code and I'm able to capture one cell...
  11. T

    GridView to CSV file in C#

    I'm trying to convert a GridView to CSV All I have is the GridView displaying my XML file. //************** protected void Page_Load(object sender, EventArgs e) { DataSet myDataSet = new DataSet(); myDataSet.ReadXml(Server.MapPath("portfolio.xml"))...
  12. T

    MS Reporting Services and Oracle db

    There's a chance that the company I work for can get Reporting Services. We use Oracle as the standard db but we can use SQL 2005. It's just that this app might need to hook up to another Oracle database in the future for more financial information so using Oracle for our database might make it...
  13. T

    username and role protection in C#

    I have a a web app that uses single sign on but it still needs to read my web app to see if a user is allowed on the site. Would hashing the username and role be enough security? What other methods are there? It's gonna be working with a Oracle database. Edit: Looks like I need to do...
  14. T

    Auth methods in ASP.NET

    I have a few questions on how to approach this. We have a LDAP server/corporate site and we are developing a ASP.NET app. What I want to do is once a user logs onto our corporate site, to be able to to try to log onto our ASP.NET app. (We have the method on capturing the LDAP username)...
  15. T

    Dynamic stored procedures in C#/ASP.NET

    How would I go about making a dynamic stored procedure? For example, I have a Oracle database with a table Row1 has Dates Row2 has Numbers So say I want to make a select query from Jan 08 to June 08, but also also be able to do Jan 07 to Jan 08 if I want to dynamically as in it's up to...
  16. T

    Multiple classes in C# and one connection string

    I'm working on a project and I have a question. I and another person are working on it and we have decided to keep classes separate for organization. So we have dbLoginAuth.cs and dbDataReader.cs classes, there will be more in the future. They both need to connect to a database. I'd...
  17. T

    .NET 3.5/.NET 2.0 and IIS 5.0 compatibility

    I'm working on a .NET 3.5 project, I am just informed that the servers here are Windows Server 2003 but they are IIS 5.0, I guess they aren't going 6.0 just yet. This looks like it's not going to work out.
  18. T

    Side scrolling game programming

    Hi, I would like to program a side scrolling game. My languages that I know are C# and VB.NET, I have C++ experience but pointers and stuff like that are really foreign to me. Any ideas? Thanks.
  19. T

    Login script and active directory

    Hello I'm having a issue on how to approach this. in the page load........... //***** foreach (string Item in Request.ServerVariables) { Response.Write("<br> " + Item + " = " + Request.ServerVariables + "<br>"); } //***** This script...
  20. T

    CSS help

    I have a css box and I'm trying to figure out how to have text on the left and right. It should look like [left side] Comment [far right side] Comment History http://i302.photobucket.com/al...EarthWillShake/css.jpg But the comment history is one step down. HTML ************...
  21. T

    authorization and querystrings in ASP.NET

    Hello I have a simple question on how to approach this. Let's say we have 3 users, user11, user15, and user19. user11 has 2 graphs he is allowed to look at, ?graph=1, 4 user 15 has ?graph=2, 3 and user19 has ?graph=5, 6. This is of course gonna have to be dynamic as the user may get...
  22. T

    Export Excel 2007 to XML

    I don't understand why Excel can't export to XML in 2007, 2003 did it just fine. It says I can't export to XML because there is no XML mapping. Any ideas?
  23. T

    Chicago 294 Cameras

    Anyone know any info about these speed cameras? I hear they will start enforcing in July. Anyone know?
  24. T

    Microsoft OWC and SQL 2005 Issue in C#

    Hey, I'm trying to read a database and display it as a graph. I have accomplished this but I have an issue. Database structure is one table called num1. num1 only has ID, X, and Y columns. That's it. The graph displays right but the tags at the bottom have all shifted over right so...
  25. T

    c# conventions

    How do you guys program your code? Do you do all the functions at the bottom and call them in buttons etc??? I'm just curious what would be the optimal way for programming something so future programmers can read and understand at the clearest level.
  26. T

    FAFSA Question

    My parents did a join tax thingy but the FAFSA wants the amount my Mom made and my Dad made and I can't find it on our Income Tax Return. Wtf?
  27. T

    My nephew went on a site and now I don't know if my computer is infected

    Hey went on a site that I don't approve of and I'm now concerned that my computer is infected. I have AVG installed but I doubt that's enough.
  28. T

    ASP.NET programming in a corporate environment

    Could someone please give me some pointers or guides on programing in this environment. I feel a bit overwhelmed with how to approach my project as I haven't ever made a huge application. Thanks
  29. T

    Where to get boot camp files

    I left my 10.5 disc at home and I want to install Vista. Is there a place where I can download the Macbook Vista drivers package? Thanks
  30. T

    Read a database to display graph in .NET

    Does anyone know of a guide that shows how to do this? I'm trying to read a database into a array, two parts. Day and Cost I want to read this and plot it on a bar graph. I would like to make it dynamic so I can choose my Days and then create the graph...