krollenhagen's Q&A profile

• SQL Server SSRS Slow waking up on first report

  Greetings, I continue to see this similar post all over the place, but no resolutions. We have SSRS installed and operational in production. There are reports that get accessed from either an aspx page or from the built in IIS site for SSRS. First time access is the performance problem. Here are two scenarios: 1) from your browser, pull up the front page to SSRS: http://myserver/reports . This simple operation will take about 2 minutes to come up. Drill to the report in question and it runs fairly well first time through. Throw a different query at it and it runs faster. If you wait a while (maybe 15 minutes +) the whole thing will spin back down and take 2 minutes to come up again. If you exit the website and come back ...Show All

• Visual Basic how to read all file name in a folder

  i want to read all file names in any folder and store in the excel file so how i can do this The easiest solution would be reading all filenames in a folder than write those in a separate .csv file so Excel could easily read it: Dim files() As String = System.IO.Directory.GetFiles( "c:\myfolder" ) Dim text = String .Join(Environment.NewLine, files) System.IO.File.WriteAllText( "c:\files.csv" , text) Andrej ...Show All

• Visual Basic Progress Bars

  I am wanting to display a progress bar while my program is loading data from and access Db using the DataAdapter.Fill method. Does anyone know if this is possible thanks tattoo Dear All,                  I am using .net framework 1.1 (C# web application) but backgroundworker component is available only for .net framework 2.0.  How will I calculated background work using .net framework 1.1   I just want to display some image or animated pic(% is not required for me) while some work is going on. Can any one help me to solve the problem Thank you, Regards CT ...Show All

• SQL Server Advanced lookup transformation

  Hi, Here is my problem for a lookup transformation: I have an input flow with dates and fields like this : ID BEGINNING_DATE ENDING_DATE 1 12/01/2006 12/16/2006 and a reference table like this: ID PRICE BEGINNING_PRICE_DATE ENDING_PRICE_DATE 1 400 11/28/2006 12/03/2006 1 500 12/03/2006 12/06/2006 1 600 12/06/2006 12/09/2006 I have to get the intersection periods between the two tables joining on ID. I would like to have this result flow : ID BEGINNING_DATE ENDING_DATE PRICE 1 12/01/2006 12/03/2006 400 1 12/03/2006 12/06/2006 500 1 12/06/2006 12/09/ ...Show All

• Visual C# how to set the system time using WIN32 API Dll calls?

  hi all, i have written a code for setting the system time. the server will send the time to the client and that time is collected at the client side and the new time is set in the client side... server side code: using System; using System.Collections.Generic; using System.Text; using System.Net.Sockets; using System.Collections; using System.Net; using System.Timers; using System.Threading; namespace Server { class Program { static ASCIIEncoding ASCII = new ASCIIEncoding (); static Byte [] outstream = new Byte [256]; static TcpListener tcpl = null ; public Program() { } public static void Main( string [] args) { tcpl = ...Show All

• SQL Server Page breaks in subreport do not work in main report

  I have a report containing a table that is grouped on a certain value. After each grouping, it is supposed to generate a page break. This works fine in the stand-alone report, but if the report is used as a subreport to another report, the pagination completely fails. I really need the page breaks to filter up to the main report. Is there a solution to this ...Show All

• Windows Forms How to detect each keystroke in datagridview cell

  Hi, I need to detect each keystroke in datagridview cell. I found a class called DataGridViewTextBoxCell with its protected OnKeyDown method. I thought the pseudo - code might be something like this: DataGridViewTextBoxCell c = this.datagrid1[column, row] c.KeyDown += KeyDown(); then protected override void KeyDown(object sender, KeyEventArgs e) { //detect it over here } I might be wrong though. Help anyone The DataGridViewTextBoxCell class is a specific type of DataGridViewCell. If you are sure that the cell you are referencing is a DateGridViewTextBoxCell, your code will probably work. However, I think you use the DataGridViewCell class to detect the keystroke. Just remember that KeyDow only detect ...Show All

• Internet Explorer Development showModalDialog - displays white space at the bottom of the dialog

  I have dialog pages that are displayed with a grey background.  They displayed fine in IE6 but in IE7 they show with a white space at the bottom that's approx. 20-22px high.  Our app is used in a trusted zone in IE and we don't display the status bar at the bottom of the dialog and the IE7 dialog address bar is not displayed at the top. How would I get this to display correctly in both IE6 and IE7   I realize that I can probably get rid of the white space at the bottom by just stretching the background down farther but that will add blank space at the bottom of the window and make it look bad. Any info is appreciated. Jeff After more research I found that in IE7 the size setting of a ...Show All

• Visual Basic Field Behaviour Combo/Textbox Show/Hide

  Hello all, I am currently building a small program using VB with a SQL database. I would like to start the form with certain combos and textboxes hidden ( I can do this) Then as a result of another combo I would like the boxes to re-appear. I can get this to work at a basic level using the following code: - If cmbErrorCat.Text <> "No Errors" Then ErrorDetailsTextBox.Show() End If However I want this to be record specific so when you scroll through to records the combos/textboxes either show or not. What is the best way to achive this Use a binding source control...bind your controls...and then use a binding navigator to scroll through the records. Then use the binding sources "Positio ...Show All

• Visual Studio 2008 (Pre-release) Problem with generic list nested

    I have a SOA type WCF application with netTcpBinding that uses messages (request, response) to communicate client with Server, I use entity classes (Entity) and a collection ( EntityCollection ) that inherits from a generic list ( List < Entity > ).       [ Serializable ]     public class Entity     {         private int id;           public int ID         {             get { return id; }             set { id = ...Show All

• Visual C++ a++++;

  hi i hav this problem. int a; a++++; gives an error.. ' operator ' needs l-value but ++++a; compiles properly. plz help me... That's the beauty of C++... it's possible to write valid (in the sense that it compiles without warnings or errors) code that does strange and often unpredictable things. ...Show All

• Visual C# how to overload a native function

  Is it possible to overload a function from VS2005 IDE If so, I want to overload graphics.drawline() which signature in CF is drawline(pen, int x1, int y1, int x2, int y2). I want to change it to drawline (pen, point A, point B). Any help No, you cannot modify this class in any way. You have to write some sort of a wrapper/helper class. For instance: public static class ExtendedGraphics { void DrawLine (Graphics graphics, Pen pen, Point start, Point end) { //Implementaion using the available overloads... } } ...Show All

• SQL Server “AcquireConnection method call to the OLEDB Connection Manager for SQL Server failed” Error

  I have an SSIS package which takes input from Flat file and transfer the data to SQL Server using OLEDB Destination Data Flow Item. The OLEDB Connection Manager used for the destination is configured to use SQL Server Authentication for the user ‘sa’. The package works fine without enabling the configurations. But when I enable package configuration and save the configuration of the various connection managers in an XML configuration file and then run the package it gives the following error in the validation phase: [OLE DB Destination [21]] Error: The AcquireConnection method call to the connection manager "<Connection Manager Name>" failed with error code 0xC0202009. And after the validation phase is comp ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. No ID3DX10Line?

  I do not see any documentation for a D3D 10 version of ID3DXLine. Granted the DX9 ID3DXLine interface is a complete joke -- both in performance and quality, at least there is a way to get a few stylized lines in the 3D view. While games don't use stylized wireframe, this is a cornerstone for profession graphics packages (e.g., modelling and drafting). Current hardware supports accurately rendered, deterministic zbuffered, accelerated lines with widths up to 5 pixels wide. Common screen space dash patterns are sufficient for 90% of all display purposes. There are also several hidden line algorithms that only function correctly if the wide lines are rendered with correctly depth buffered Bressenham step patterns. Until Direct3D provides acce ...Show All

• SQL Server Need HELP Determining version

  First off...I have NO experience with SQL. I need to determine the version we are running. I am not even sure if we are running MSDE or full blown SQL Server. It was installed as part of our accounting software. When I go into services, there are several MSSQL services running. They are... MSSQL$JURIS MSSQL$SOPHOS MSSQLServerAdHelper Can someone please help me figure out WHAT we have installed and the VERSION Thanks in advance! Dave G. To identify if you are using SQL Server 2000 or 2005, check your Services applet. A SQL Server 2000 instance will have a service name in the form of MSSQL$InstanceName while SQL Server 2005 will have a service name in the form of SQL Server (SQL2005) To ...Show All