Recent content by aradia926

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...

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...

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...

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!

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...

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...

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...

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...

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...

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...

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...

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...

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?

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...

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...