efarook's Q&A profile

• SQL Server MS Office Integration & SSIS

  Using SSIS, every month/week I have to generate serveral excel files. I need to find a way to automatically format these excel files (Bold, Headings in Different color etc.). Is there a way to integrate MS Office excel task in SSIS Thanks Shafiq shafiqm wrote: Using SSIS, every month/week I have to generate serveral excel files. I need to find a way to automatically format these excel files (Bold, Headings in Different color etc.). Is there a way to integrate MS Office excel task in SSIS Thanks Shafiq The only way is to use the Office Primary Interop Assemblies (PIM) and do this programatically from a script task. -Jamie ...Show All

• SharePoint Products and Technologies How do i get my web part to remember input when it reloads ???

  Hey i've made a simpel little web part with a few text boxes, a calendar and some buttons, but when i change the date, the whole web part reloads and everything written in the textboxes is lost...  HOW CAN I PREVENT THIS   im using VS 2005 C# and sharepoint 2007, and have tried using ViewState, but it doesn't work >< pleeease help  mads Are the controls going back to their default values If so try the below... try: protected override void Load(EventArgs e) { if(!Page.IsPostBack) { // set control values in here... } } ...Show All

• Smart Device Development two-state icons on Windows Mobile 5.0 start menu (grid view)

  Some shortcuts on the start menu of a Windows Mobile 5.0 Smartphone show a different icon when they're selected. The Messaging icon shows the slip of paper poking out of the envelope, for example. Has anyone managed to recreate this with their own applications, and if so, how Is there a convention for how the icons have to be ordered in the .rc file or is there a naming convention Is there a URL talking about this in MSDN Thanks in advance, Matt Thanks for the reply Matt. That page is sort of a great example of why I asked the question - it doesn't mention the " <full path of icon or DLL file containing icon>,<index of icon>" bit at all, so does that mean it's an undocume ...Show All

• Software Development for Windows Vista In Vista a shared file lock up Applications

  When I share a folder in Windows Vista and open a MS word document in the shared folder on the host system and then attempt to open the same document from another Windows Visa system MS Word locks up until I close the document on the host system. I checked my sharing settings and they all seem to be correct. My Access Jet Database program has the same problem. This is my real problem. Does anybody know what could be the problem I have the same problem too. To me this is a major bug in Vista and needs to be reported. Does anyone know how to report this type of bug to Microsoft ...Show All

• .NET Development Write Permission

  Hi.... Is there away to set the write permission to any folder programtically Thanks in advance... indeed there is. simply do this... System.IO.DirectoryInfo theInfo = new System.IO.DirectoryInfo(" pathToDirectory\\DirectoryName "); theInfo.Attributes = FileAttributes.ReadOnly;   you can also set multiple permissions to the folder such as making it hidden or a system folder by OR-ing:   theInfo.Attributes = FileAttributes.ReadOnly | FileAttributes.Hidden; ...Show All

• SQL Server Search Stored Proc

  Does anyone know a way to seach through all databases on a SQL 2000 server looking for a particular stored proc by name Change the part that says "targetObject" to "ProjectUpdate" like: exec sp_MSforEachDb 'select ''~'' as [Database Name], [name] from ..sysobjects(nolock) where [name] = '' ProjectUpdate '' ', '~' ...Show All

• Windows Forms Navigating by Year on the Calendar function?

  Is there a way to navigate by year as well Having to click on each month to get several years ahead is awfully inconvenient. Okay, I've figured out how to navigate by year, but I need to know how to put a << and >> inside the Calendar class itself (again still using VB) to navigate by year instead of having two external buttons. Anyone have any ideas on how to do this ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. loading textures on array

  Hi i am making a simple pool game and have my balls in an array (each ball runs through a class to set the properties. i have a Texture2D property to set the texture so i can set the white ball colour and yellow and red ball colour. however i have set up the array and try to draw but it will not accept the array property as a texture it keeps saying it is of null value even though i have set each of the balls here is the code below as you may understand a little more. //ball class for each ball public class balls { public Texture2D tex; public float x; public float y; public Vector2 v = new Vector2 (); public float r = 12.5f; public float m = 10; } //array of ball ...Show All

• SQL Server access denied to RSReportServer.config

  Hi, I've just installed the new SQLSRV 2005 Express Adv Ed (ASP.NET 2.0.50727) and also installed the reporting services. Trying to browse the ReportServer website (via inetmgr or //localhost/ReportServer/) returns the following error (using Windows Credentials): >>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is denied. << How can this be fixed All hints appreciated. Thanks ...Show All

• SQL Server Your login attempt was not successful. Please try again

  I have a standard Login ASP.NET 2.0 control on a login Page, a LoginName and LoginStatus controls on the member's page. once the user login successfully I am redirecting the user to Member.aspx page. The following is my machine configuration Windows XP Pro Service Pack2 IIS 5.1 SQL Server 2000 visual Studio 2005 DISABLE ANONMYOUS ACCESS IN IIS ENABLE WINDOWS AUTHENTICATION I am Using form authentication, and I am getting following error "Your login attempt was not successful. Please try again". To debug,I am displaying the follwoing properties Membership.ValidateUser(Login1.UserName, Login1.Password) : - True HttpContext.Current.User.Identity.Name : - // is blank FormsAuthentication.FormsCookieName : - SqlAuthCo ...Show All

• SQL Server Cannot create a report - VS 2005/SQL 2005

  I cannot seem to create a Report based on an SQL Server 2005 database. The IDE and the database server are on the same machine. The reports server is installed and running. During both installations (VS and SQL Server 2005 ) I opted for the complete install. I create a reports project - when I right click the reports folder and select Add New Item > Report - nothing happens. When I invoke the Report wizard and continue till the last step - pressing finish generates the following exception : =================================== Exception of type 'System.Runtime.InteropServices.COMException' was thrown. (Microsoft Visual Studio) ------------------------------ Program Location: at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FilePr ...Show All

• SharePoint Products and Technologies After deleting and recreating a web application, SSP administration is gone

  I'm currently trying to work with MOSS 2007. I tried some stuff out and messed the web application up. So I deleted the web application, created a new one and worked with it. I used the SSP "SharedServices1" for this. After 2 days of implementing some stuff, I realized that I need to configure automatic AD import, what you do in the configuration of the SSP. But in the central administration, the button for accessing and deleting the SSP is grayed out. Most likely because I deleted the web application where the administration of the SSP was running on. What should I do now Is there a way to recreate the administration page without loosing all data of the web application and the site collections in there I looked at wh ...Show All

• Visual Studio App_Web_u6yfrc-g assebly compile error

  Hello, I am getting the following error. My website was working fine with these settings. However, an attempt to republish the website rose this error and ever since it has prevailed (even with attempts to republsih it !). Website gets successfully published but this error prevails when accessing from the webserver, IIS 6.0. The project works fine from .NET environment.. Is there a way to cure it I appreciate the help. Regards, Abhijit. ------------------------------------- Server Error in '/PEReports' Application. Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parse ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Globtrotting and Creators Club and DreamBuildPlay

  I've been working on a windows version of an XNA game for a while now. I'm to the point where I want to get a creators club membership and move it to the 360. I've also been waiting for the details of the DreamBuildPlay contest, so I can plan the rest of the project. Also depending on the contest details I've been waiting to buy tickets to Japan and Australia. To my question: If I get a creators club membership and get my game going on the 360 here (US) then go to Japan for 1 month and bring my laptop/360 can I use my creators club over there Same with Australia Also are the ethernet connections the same in all 3 countries How about the power Today is the last day I can get cheap tickets to Japan, so I'm going to get them, but if the ...Show All

• Windows Forms Weird Behavior in VSTO

  Hey all, I had this problem when I was using the Express Editions of VSTO, so I purchased the full version thinking that it would fix the problem. It didn't!!!! Here's the deal: I have a nice winform project using C++/CLI. I go to add a new Windows Form to the project (also happens if i add a new User Control). When I add any control to the form, or I even try to save the form, I get a series of error messages: "The file C:\~~~\Form2.resx" could not be loaded" Then: "File C:\~~~Form2.resx" already exists in the project" Then: "Error HRESULT E_FAIL has been returned from a call to a COM component". So I can never save the form. Is this a known bug I've tried reinsta ...Show All