Dattaforit's Q&A profile

• SQL Server Freeze Pane functionality during Export to Excel

  Hi All, I have created a Report using Sql Server 2005 Reporting Services. When I export the report to excel, I want to freeze the pane of the headers in the exported excel. Any pointers on how to achieve this will greatly help me. Thanks, S Suresh Geoff, Thank you so much for your link. Looks like it is for sql sever reporting service 2005. We are using 2003 but I tried anyway. I used the way change the setting through adding render section in xml code but got error. The question I have is where should I put the render section in the xml code Below is the code, please help me out. Thank you very much for your help! <Report xmlns="http://schemas.microsoft.com/sqlserver/repor ...Show All

• Windows Forms On-screen keyboard control

  Hi, I'm looking for a control to display a keyboard to be used on a tochscreen. It would also be nice if i have control over the keys possible, to disable/enable keys (like you see in eg. navigation systems). Does anyone know such a control Kind Regards, Edwin Stoffels There is this one http://www.codeproject.com/useritems/XKeyboard.asp Its not exactly pretty, but it could it seems to have all the basics there ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Error - Spacewar Starter Kit (GSE Beta2)

  Hello, I can't run Spacewar Starter Kit, I get an error: Error 1 Error code: -1 encounted when initializing FBX file loader. The file is either corrupted or it is not a valid FBX file. C:\Documents and Settings\ma o\Dokumenty\Visual Studio 2005\Projects\MySpacewarWin1\MySpacewarWin1\Content\Models\p1_pencil.fbx MySpacewarWin1 Czech language with Slovak interface pack. But in XNA readme is mentonied: "Although XNA Game Studio Express itself is available only in English, it is supported under any of the language settings available on these operating systems." So I suppose that's not the problem. Nevertheless, thanks for notice. ...Show All

• Visual Studio Express Editions IE Plugins

  how can i add my IE plugins to my web browser i'm making popit, Do you mean to add the IE plugins to your WebBrowser control Could you tell me what IE plugins you want to add Actually there are so many ways to finish this task. If you can give the specific question, you will get your satisfied answer. Here I have two links to help you with this problem. One is about the WebBrowser Class as follows: http://msdn2.microsoft.com/en-US/library/system.windows.forms.webbrowser(VS.80).aspx The other is some instance on the WebBrowser control and hope that can help you: http://msdn2.microsoft.com/en-us/library/2te2y1x6.aspx ...Show All

• Visual Basic Problem with GetChanges() from a DataTable Object

  I am trying to find out if a DataTable object has any changes that need to be saved to it's SQL Database using the Update() method. I looked throughout the properties of the DataTable object and can't find a Dirty property. But I did find a GetChanges() method. Problem is whenever I execute the GetChanges() method, which claims to return a DataTable of records that have been modified, I get the following error: MissingMethodException was unhandled No parameterless constructor defined for this object. Does anyone know why this is Or better yet, anyone know how I can accomplish what I am trying to do Ok...here is my code line that crashes... If Me .DataSet.Tables( "tblCodes" ).GetChanges().Rows.Count > 0 Then ...Show All

• Visual C# Manual scroll and hide scroll bar

  I have the AutoScroll property set to TRUE on my panel, but: how do i hide the scroll bar even if the panel contain is larger than the viewport (visible part of the panel) So if I have to turn AutoScroll to FALSE, how do i scroll manually Thanks! tech001, as far as I know, AutoScrollPosition will only work if AutoScroll is set to true. If you want to achieve scrolling without having the scrollbars, you can always play with the position of the content. For instance, if you have a 200x200 Panel containing a 1024x768 PictureBox, you can always change the Location of the PictureBox to scroll it around. If you have several controls in your panel, either you move them one by one, or you just group them into some container. ...Show All

• SQL Server Failed install of December CTP reporting services add-in for WSS

  Upgraded SQL 2005 to Dec CTP sp2. Had previously run Nov CTP and installed the Sharepoint add-in. Had that all working. Now trying to add the Dec CTP sharepoint add-in. But it won't complete. Keeps rolling back and then ending with dialog '.... setup was interrupted' Anyone else seeing problems with this Dec CTP install I setup a repro machine and here are the steps I took to get CTP3 working: - Uninstall Reporting Services Add-in for SharePoint CTP2. - Install Reporting Services Add-in for SharePoint CTP3. This should now run to complet - You may still run into the Server error due to the ReportServer.<culture>.resx files (This is an Add-In setup bug we are working on fixing in the RTM releas ...Show All

• Visual C# Windows Form Applications Run Without Stopping

  I am brand new with C#, so bear with me and don't laugh... I am working through Microsoft's book for C#. The second exercise is to create a very basic Windows form application. After it was completed, and I click "Start Without Debugging", it worked fine. However, after the first time, if I try to run the little application, the form pops up, and then immediately disappears. I loaded some of the other supplied form type applications and they all do the same thing. This has to be simple. Any ideas I've tried running pre-written, supplied code with the same result. The problem isn't with the code, but I don't know where to start looking. ...Show All

• Visual C++ Block Images

  Hi, Iam using CHtmlView class (MFC) for displying the contents in a mail........but i have to block the images..........which are getting......dowloaded from websites........how can i do this ...........can tell me the starting point to implement this one.... Thnx in advance, Sudhakar. Hello Re: Block Images Such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 The more appropriate place for your question is probably the MFC newsgroup: http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.vc.mfc&lang=en&cr=US ...Show All

• .NET Development UnExpected reflaction after Updating a table any one face this .............?

  Hi ADO.net Masters, After updating records in a table it updated sucessfully BUT, when i am looking in the crystal report and listView control for same record, it dose not reflect the changes, it shows the data befor updation. Any on tell me what is the issue for this type of error. actully i have take all these data from the MS Acesses. And i am using .net2003 with Sql Server2000 Please any one faced this type of prob.. pls help me thanks in advance.. It isn't clear what could be causing the problem you're seeing without some more details on what you're trying to do. Do you have a code sample of what you're trying to do that you could post to give us a better understanding of the problem -Lance ...Show All

• Visual Basic Print contents of picturebox

  In my application lines and text are drawn in a picturebox.  My problem is that I struggle to print the contents of the picturebox.  The picturebox doesnt contain an image, only text and drawn shapes.    INFO: I am using Visual Studio2005 to create the application (VB.Net) Operating System: XP Pro   Christie I hope my enquiry isnt too late. Actually I am using similar method to draw on Picturebox. Thx nobugz, I managed to print this Picturebox contents. nobugzs, I wondered, do you have the method that you mention here (to print Picturebox) which enable me to specify the print origin I did as you shown here: Private Sub PrintDocument1_PrintPage(ByVal sender As System.Object, ByVal ...Show All

• Visual Basic looping through recordsets in vb.net

  Hi, I am trying to loop through 2 sql tables and update one table with data from the other if a condition is true. I know how to do this with vb but not with vb.net and can't find any help or examples. I have established a connection to the server to get the data but don't know how to loop through it and make the necessary updates. Can someone give an example Here is what my vb function looks like below, I would like to be able to transform this into vb.net and use in a script task in my sql package. Dim db As Database Dim rec1 As Recordset Dim rec2 As Recordset Dim test2 As Boolean Dim AppID As String Dim SortKey As String Set db = CurrentDb Set rec1 = db.OpenRecordset("qryScoresAll") Set rec2 = db ...Show All

• .NET Development VC 8 <-> VC 7.1 compatability, System.TypeLoadException: Method XXX does not have an implementation

  I have a case where I am getting a System.TypeLoadException with a message such as: "Method 'xxx' in type 'yyy' from assembly zzz does not have an implementation". The scenario involves a .NET 1.1 mixed assembly written in MEC++ that defines some value types and some managed interfaces. Then there is a mixed .NET 2.0 assembly (also written in MEC++) that does early binding with the .NET 1.1 assembly and which contains a class that implements the interfaces defined in the .NET 1.1 assembly. When the .NET 2 program attempts to call a method on its own class that implements a .NET 1.1 interface, that is when the System.TypeLoadException occurs. Is this a bug in the CLR, VC 7.1 or VC 8 If so, is there a workaround If it is work ...Show All

• .NET Development Reading file sizes, name, date on the server

  I'm trying to make a program that basically say that every morning run this directory and scan through all the files. Then record the name, size and the date and then compare with the one that already existed in the database. If everything is match then pop up message say GOOD. If something has been changed then pop up a message say NOT GOOD. But aslo if i know that there was an update on the file so the date has been changed, that program should also have an update function to update the database. For instance File1 800kb 7/18/2006 File 2 1mb 7/17/2006 because this is the first time i run this program so i have to insert this into the data base. so after inserting, the database will have a list of file 2 and 1 with ...Show All

• Windows Live Developer Forums Virtual Earth 3D Map View Issue

  Hi, I found a issue to see Virtual Earth 3D Map on my pc. I have: 1. installed the Virtual Earth 3D software 2. NVIDIA GeForce 6200 LE(NVIDIA) 3. OS: Windows xp Pro sp2 4. 1 GB RAM Still I am unable to see the Virtual Earth 3D map. [even on http://dev.live.com/virtualearth/sdk/] I have writen one application using Virtual Earth SDK and used 3D map. [I tried to see 'Seattle' and other major cities in US, but not succeded ] It will be great to get any help. Thanks & Regards, Mahesh Lambe I can't comment on specific release dates, but it's not far off. I also can't really speculate on the ad revenue model, but commercial customers will certainly be able to disable any built in adv ...Show All