Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by aradia926

  1. aradia926

    Need Help with a Cursor

    I've got a SQL Server 2000 stored procedure that returns data to be used in a crystal report in Visual Studio 2005. Most of the stored procedure works well, but there is a point where I need to calculate an average number of days been a group of date pairs. I'm not familiar with cursors, but...
  2. aradia926

    Page Footer Printing on blank page

    I'm using Crystal Reports for VS 2005. I have a report with a subreport (which is another crystal reports file) and I'm having trouble with the page footer. My main report has one page and my subreport has 9 pages - they will always be this length. For some reason, I get a page 11 that only...
  3. aradia926

    Server Timeout Accessing a Formview

    I set the Query Timeout on the sql server to 0 (unlimited). I wouldn't say the server is very busy. It is an internal application that is only accessed by 25 people and maybe an average of 7 concurrently. When the user performs a search to determine if the contact record that they are trying...
  4. aradia926

    Need help with Publishing my website

    I'm not sure what you mean by "opened the intranet server to the internet." Shouldn't the redirect take care of that? I'm sorry that I'm a little clueless, I'm a self-taught programmer and I'm still learning!
  5. aradia926

    Need help with Publishing my website

    I've built a custom web-based CRM in ASP.NET 2.0 on Sql Server 2000. I would like to make the CRM available on the internet, right now it is only available through the intranet. To do this, I want to have the main web server simply redirect a user to the server where the CRM resides rather...
  6. aradia926

    Server Timeout Accessing a Formview

    I've built a custom web-based CRM in ASP.NET 2.0 on Sql Server 2000. Currently updating a contact is very inconsistent. If I go into a contact through http://MyServer/secure/allcontacts.aspx or http://MyServer/secure/allcontacts.aspx?contactid=6151 then the updatecontact() sub that I have...
  7. aradia926

    Selecting a Drop Down List Value Based on a Text Box Value

    I would have to store every postal code for the US and Canada. I'm not sure what the exact number would be, but it seems like it would be a large one...
  8. aradia926

    Selecting a Drop Down List Value Based on a Text Box Value

    Thanks, dvannoy, I guess I could do that but would it slow my application down at all? Also, I'd rather avoid a postback, knowing what I know now, which brings me to... Ok, so I've been doing some research and determined that since I'm using asp.net 2.0, a client callback should work...
  9. aradia926

    Selecting a Drop Down List Value Based on a Text Box Value

    I have a formview control (.NET 2.0/VS2005) in which users enter company contact information. When a user enters a postal code in the appropriate text box, the territory for that company needs to be calculated and displayed in a territory drop down list. I know how to calculate and retrieve...
  10. aradia926

    Textbox retaining old values

    This is really weird and I just can't seem to get it figured out. I have a page with a formview control. When users insert a record, they type a name into the very first textbox in the form and click a search button. This name is passed via querystring to a search page. After a search is...
  11. aradia926

    Nesting Transactions

    Thanks for the suggestion, ca8msm. What I ended up doing is: Start my transaction Insert into the company table using cmd.executenonquery() Then I ran: cmd.CommandText = "SELECT @@identity"; string id = cmd.ExecuteScalar().ToString(); Use id throughout the rest of my transaction Commit...
  12. aradia926

    Nesting Transactions

    Hopefully someone can point me in the right direction, I've been searching on the net for the answer to this question and can't seem to come up with anything. First, I'm using ASP.NET 2.0 and Visual Studio 2005 with a SQL Server 2000 backend. My SQL database is relational and is used to...
  13. aradia926

    Run code after printing

    Well the problem is that the viewer in Visual Studio 2005 doesn't list a printbuttonclicked event. How can I get to it from Visual Studio?
  14. aradia926

    Transposing rows and columns in a subreport

    Success! So after you said that the approach worked for you, I started to investigate some other reasons why it might not work. I found that a link between two of my tables in my database was wrong. After changing that link, it worked perfectly! Thanks to synapsevampire for getting me...
  15. aradia926

    Transposing rows and columns in a subreport

    I placed a display formula in the report footer of the subreport and not only does it not display the correct codes, for some reason the report in rendered in total jibberish. Most of it is not even recognizable characters. I'm getting really frustrated, I can't even imagine what you're...
See more

Part and Inventory Search

Back
Top