RookieDBA's Q&A profile

• SQL Server Is it possible to create a cover page in SSRS 2005?

  Very simply, I need to add a cover page to my SSRS 2005 report. I've tried this using the Page Header region, but the cover page will not show up on Preview or Export. How and where do I create a cover page Hi, Bibble, Whatever you place first on the Report Design surface (the dotted white area), renders first. So try adding a rectangle which will act as a container, put whatever you want in the rectangle, and set a page break at the end of the rectangle. ========================================================== This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• .NET Development How to decode chunked transfer encoding using HttpWebResponse

  Hello All, I'm calling a cgi script that returns a zipped file using the HttpWebRequest class. The web server sends chunked response. Response captured in Fiddler: HTTP/1.1 200 ok Date: Thu, 30 Nov 2006 10:09:47 GMT Server: Apache Set-Cookie: sessionID=1164881387; path=/; expires=Thu, 30-Nov-2006 15:09:47 GMT Transfer-Encoding: chunked Content-Type: text/xml; charset=ISO-8859-1 c13 PK Here's how i process the response byte[] data; response = request.GetResponse() as HttpWebResponse; responseStream = response.GetResponseStream(); reader = new StreamReader(responseStream, Encoding.UTF8); data = Encoding.UTF8.GetBytes(reader.ReadToEnd()); This returns me only the first chunk. How do I read the remaining data thanks, Siwi ...Show All

• .NET Development How can I detect muliple rows in dataset using XSL ?

  Hi I have the follwing dataset(Tbl1 and Tbl2 with two rows).I have xsl file(given below) to restructure the xml file. Tbl2 may have more than one row and the dataset may change time to time(Tbl2 will be 1 or more rows) If Dataset with 1 row of Tbl2 I can handle xsl file to manage it. But If Dataset with more than 1 row in Tbl2 (please look at the xml file below) How can I write the code(xsl)to detect the rows and place the data in between the elements in the output(look at output xml file) Scenario Dataset <Dataset> <Tbl1> <A>aaa</A> <B>bbb</B> <C>ccc</C> <D>ddd</D> <E>eee</E> </Tbl1> <Tbl2> <1>one</1> <2>two</2& ...Show All

• SQL Server Cube Partitions

  I deleted default partition that is created while cube processing. and after that I have created 2 new partitions for different date ranges. even after processing i am unable to see any data in the cube. I am following right process of using partitions Please let me know how i can get data Thanks in adv Everything you've done sounds fine - so it should work. Can you check how you specified the data ranges for the partitions During processing, how many rows do you see being read into the partitions How did you check that the cube is empty Perhaps you were looking at different slice ...Show All

• Visual Basic Identifier Expected

  Hello: i'm making a VB 6.0 project to copy files to WCE 5.0 Device. i copied a code i found in msdn but when trying to compile it send me an error: Expected: Identifier http://support.microsoft.com/default.aspx/kb/307256 Private Declare Function WaitForSingleObject Lib "kernel32" ( ByVal _ hHandle As Long ByVal dwMilliseconds As Long) As Long anybody have an idea what could be... Vb_2007, When you see the Expected: Identifier Error message, it means that you use the reserved words in Visual Basic and it is forbidden to use the reserved words as the name of consts or variables. According to your description, I suggest you to follow the steps as the KB articles tells you. Afte ...Show All

• Customer Care Framework security error when trying to host asp.net application, please help

  security error when trying to host asp.net application A potentially dangerous Request.QueryString value was detected from the client (_ccfData="<root><ApplicationDa..."). Description: Request Validation has detected a potentially dangerous client input value, and processing of the request has been aborted. This value may indicate an attempt to compromise the security of your application, such as a cross-site scripting attack. You can disable request validation by setting validateRequest=false in the Page directive or in the configuration section. However, it is strongly recommended that your application explicitly check all inputs in this case. Exception Details: System.Web.HttpRequestValidationException: ...Show All

• Visual C++ Problem loading dll created by VisC 2005

  Hi, I converted a C++ project from VS .NET 7.1 to VS .NET 8. The project uses old fopen methods and similar. Under 7.1 the project compiles and runs, but under 8, I am unable to run. First, when running the application, it complains about missing msvcr80.dll. Then, when I locate it (somewhere) on the computer, I get the error that the application tried to load the dll in an illegal manner. When searching for info on this, I stumble into manifests, and I see that the manifest should contain some lines about the msvcr80.dll, version etc. But my manifest file is empty. It only contains this information: < xml version="1.0" encoding="UTF-8" standalone="yes" > <assembly xmlns="urn:schemas-microsoft-com:asm.v1" manif ...Show All

• Visual Studio Team System Date Time Field in Source Control Explorer

  One thing I really miss is a date time modified field next to the files in the source control explorer. In VSS I used this all the time to find files that have recently changed. Or just to know if a file was really old. Is there any way to add fields in the Source Control Explorer for TFS Thanks for your help, Nate There's no way to add a column to Source Control Explorer, but it will tell you what files in your workspace are out of date. Unfortunately, the date is not shown in the Properties dialog either. You may want to file a suggestion on the MSDN Product Feedback Center ( http://lab.msdn.microsoft.com/ProductFeedback/ ). Buck ...Show All

• Visual C++ Adding a window within a window.

  Hi all, I have created a window(without title bar) class with image manipulating functionalities. Just I want to show this window as part of another window, that is with in a window just like controls. I know to display as a separate window. But I just want to show as part of parent window, like a control. I hope my question is clear. I am using Visual Studio 2005. :) Purusothaman A child CWnd, got shown in dialog box as a child control. myCWnd.h file: ============ #pragma once // myCWnd class myCWnd : public CWnd { HBITMAP hBmp; CBitmap ObjBmp; DECLARE_DYNAMIC(myCWnd) public: myCWnd(); virtual ~myCWnd(); afx_msg void OnPaint(); protected: DECLARE_MESSAGE_MAP() }; myCWnd.cpp file ========= ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Issue with XNA Tutorial and scrolling backgrounds

  Greetings, I followed the second XNA tutorial, and got to creating a scrolling background for the space ship program. My problem is that as soon as I added the code from the tutorial for the scrolling background, the space ship became somewhat transparent, meaning that I am not seeing it like a solid rather a sum total of spheres and other geometries. For example, I can now see the 4 spheres on the surface of the ship in their entirety, and also the scrolling background behind it. Can someone help me out here Thanks! Pange wrote: SpriteBatch.Begin() also has an option to save the render state That's the ticket. ...Show All

• Visual Studio Express Editions textbox and the user

  how do i get the user to enter text in the textbiox, and use that value to use the msgbox to confirm its correct. Public Sub TextBox1_TextChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles viewart.TextChanged viewart.Show() newtext1 = viewart.Text If newtext1 = "" Then Exit Sub End If MsgBox(newtext1) with this as soon as i press 1 character the msgbox shows. not sure I follow however why are you implementing the TextChanged events remove them...they are not needed from what I have seen. What is "dfo" What exactly are you trying to do You should place the validation on the other form, not from the caller form....thats not ...Show All

• Visual Basic Getting a list of forms open

  I want to get a list of forms open. My application opens a form, which in turn can open a modal form, which in turn can open yet another modal form, and so on. When the last opened form is closed, I need to enable the previous form. How can I obtain a list of open forms As you are opening the forms modally the previous one should be displayed automatically as you close them. If you want to list them use Application.OpenForms For Each F As Form In Application.OpenForms MsgBox(F.Name) Next ...Show All

• .NET Development Newbie question timing of update and how it affects database ID columns

  Hi all, My scenario is an extremely simple database table (for now) which has an ID field (SQL Server 2005), ie auto-generated from a sequence. I've tested that this works by adding 50 rows, not setting the ID on each and then updating. Reading the rows back shows the auto-generated keys. I'm encapsulating the posting of a row into a web service, all working fine except I want to pass the generated ID back as the response. The following line ... int newID = newRow[ "RunID" ]; throws the following exception at runtime ... System.InvalidCastException: Specified cast is not valid. The column is an int in the table definition. I suspect it's coming back null, because the update has commited the rows and I suspect emp ...Show All

• Software Development for Windows Vista Problems when designing Workflows "top down"

  Over the last few days I have been getting to grips with windows workflow foundation for some "non trival" business workflows. I tend to take a top down approach, creating some stubbed out activities, dropping them into workflows then continuing to update the workflows and the activities that they contain at the same time. The trouble is, WF in visual studio doesent seem to like this approach. I get some particularly nasty errors if I do things like rename the workflow file or add new dependency properties to an activity after I have dropped it onto a workflow. I have had to resort to hacking thew xoml to try and delete activities from the design surface (which is no doubt making my problems worse). At the moment I am struggl ...Show All

• Visual C# Empty path name is not legal.

  I'm not really sure I'm going about my problem the right way or not. What I want to to is have a save button, bring up the save dialog, and save a report from reportViewer(.rdlc) in .pdf format. The only this is, I don't show the user the dialog for previewing the report, so I can't access any of that functionality, and I know that already has an export to pdf function. I need to do this without the use of those features. Any suggestions or ideas would be a great help! Here is some code, which I know is not right at all.. private void saveButton_Click(object sender, EventArgs e) { Warning[] warnings; string[] streamids; string mimeType; string encoding; string fileNameExtension; ...Show All