Search results for query: *

  1. C

    Pulling data from a database to a datagrid

    Figured it out had to make it 11% (as opposed to 11*) in my query on the .NET side.
  2. C

    Pulling data from a database to a datagrid

    Must be my query: Here is my query that works in Access: Dim sSelect As String = "select sum(HSCG_GT)+sum(HSPT_GT)+sum(AM_GT)+sum(TI_GT)+sum(HT_GT)+sum(Ch_GT)+sum(Ot_GT) as Totals from tblTest where TDate Like '11*/'" In my code, when I put that in, I recieve the columheading, but no data...
  3. C

    Pulling data from a database to a datagrid

    I'm using VS 2003 I have a datagrid that I am trying to populate with data from an Access database. I am attempting to pull in data from a query I created within Access. Here is the code at my data tier Public Shared Function TestData() As DataSet Dim dsTestData As New DataSet...
  4. C

    Need to query weekly data

    I want to query weekly data. To be more specific, I am using MS Access for now, but planning on converting it to MS SQL Server 2005. We go by the 4-5-4 calendar as well. I have a table with a date column that has the format dd-mm-yy. I want to do queries based off the weekly data for each month...
  5. C

    How do I get the Windows account name (common name) using Windows Authentication?

    System.Environment.UserName Will give you the ID they are logged in with.
  6. C

    How do was this project deployed??

    ahhhh... I see You da man!:) I understand now. I ended up editing the solution file.
  7. C

    How do was this project deployed??

    True but... You can't just edit the files can you? I thought you have to re-compile....
  8. C

    How do was this project deployed??

    I have two projects One on my PC (local) One on the server (in production) I copied over the files from the server, double clicked the sln file to open the project on my PC for editing but recieve the following message. Web Access Failed The default Web access mode for this project is et...
  9. C

    Putting project in new directory

    My project right now is in a directory c:\inetpub\wwwroot\test\ops\requests It runs fine from there. I want to move it to c:\inetput\wwwroot\dev\ops\requests I made the new folder (virtual directory) and copied over the compiled project, but when I go to open the web page in the browser I...
  10. C

    Extract month num and week num from date

    You're right Thank you, I appreciate it.
  11. C

    install msde other drive

    You're right You're right, probably shouldn't have posted it, but needed the help. Figured it out anyways. I took the setup.ini file and put the following into it [Options] INSTANCENAME="HOMEPC" TARGETDIR="D:\TARGETDIR" DATADIR="D:\DATADIR" Of course, the targetdir and datadir doesn't have...
  12. C

    install msde other drive

    Is there any way to install MSDE 2000 on a drive other than your system volume. I wan to install it on the D drive (my OS is on the C drive). MSDE automatically puts itself on the C drive. Does anybody know if you can install MSDE 2000 on the D drive?
  13. C

    Extract month num and week num from date

    If I have a date value in the format 11/03/2005 How would I extract the month value (11) & the week value (1) from the date?
  14. C

    Performance monitoring program

    I have two servers that talk to each other in using this IBM program. The user searches a databases and recieves a result set (from one server). When they pick a record from this result set and it grabs the associated image from the other server. The people that use this are changing to...
  15. C

    Performance monitoring

    This maybe more of a server related question, but I was wondering what the maximum number of applications running on a server should be? This is assuming the server is a descently sized up server (Win 2000 Server, 40 GB for applications, P4 processor, at least a GB of memory) That is kind of...
  16. C

    How would I create a series of arrays?

    How would I create a series of arrays (each one needs a different name) based off an integer value? Example. If the integer value is 3 then create arrays r1, r2, r3 as string() = new string() {} so if value is five then create r1, r2, r3, r4, and r5. How would I programmatically do this?
  17. C

    Help with a regular expression

    Thanks Thanks, that will work. :) One more question I forgot to put in there: How do I test to see if a line is blank? I want to loop through a bunch of lines, reading them in and parsing them. I want to do it until it comes to a blank line. (do until ?)
  18. C

    Help with a regular expression

    Say I have a line of text like this 11/12/06, 71,00589331,00200,00227755,00210,00058889,00017 I want to split this line up so that I have variables for all the values separated by commas. In other words I want 11/12/06 to have it's own variable, 71 to have its own variable, 00589331 to...
  19. C

    Crystal report based off an Excel spreadsheet

    I would greatly appreciate any help on this. I have an ASP .NET app which I would like to do some reporting with. I am basing the reports off of a couple excel spreadsheets. I want to duplicate the spreadsheets into Crystal Reports. That would include the format and all the calculations that...
  20. C

    Updating a program

    I have an ASP .NET application. It is a multi-page application. I want to make a change to the code in one of the pages. When I am doing making the changes can I just upload that one updated page and everything should work or do I have to re-deploy the whole project? Do I have to recompile the...
Back
Top