GustavoPollitzer's Q&A profile

• SQL Server Updating records ina table

  Hi there!! I have a table say Emp with index as (Empid) which is a autoincreament field. How do I update names of already existing rows having identified Empid. Complexity lies with the fact that I cannot use Emp table as Destination table because if i do so then it will insert new rows and empid will change. Thanks and Regards Rahul Kumar, Software Engineer use an OLEDB command transform from within a dataflow (assuming that is where you have identified the employee to be updated). the Command transform will execute a parameterized sql command for each input row. do and UPDATE where empid = and bind your employee id to the parameter. ...Show All

• SQL Server using select statement

  i need a solution for my simple question is it possible to use stored procedure with output parameter in select query i am having stored proc "a_proc @input, @output" i need to get the output parameter in the select statement of the other stored proc here's my example declare @OP as datetime select a,b,c, (exec a_proc tablex.Data1,@OP output) as [MY field name], d,e,f from tablex where 'conditions' but its here giving error .. how to use this stored procedure which returning me a variable and i need assign that O/P value to the fields in the select statement pls its urgent!! Thanks in advance May refer to the kBA http://support.microsoft.com/kb/262499 for a relevant in ...Show All

• .NET Development How do I get a user's domain name?

  I need to provide a UI to get the information to add a windows login to a SqlServer database. The CREATE LOGIN Sql statment requires the user name as "DomainName\UserName". I can get a list of users in XML using the following code: public static XmlDocument GetAllADDomainUsers(string DomainPath) { string domain; XmlDocument doc = new XmlDocument(); doc.LoadXml("<users/>"); XmlElement elem; DirectoryEntry searchRoot; ArrayList allUsers = new ArrayList(); if (DomainPath.Length == 0) { DirectoryEntry entryRoot = new DirectoryEntry(" LDAP://RootDSE "); domain = entryRoot.Properties["defaultNamingContext"][0].ToString(); } else domain = DomainPath; searchRoot = new ...Show All

• Visual Basic Doubt in impersonation

  I tried to develop a web application in my local system(windowsxp Professional) IIS V5.1 in VB.Net. I tried to access a file server from the application,for that i used impersonation. The problem is that when i run the application from my machine it is running fine,But when another person( who is in LAN and having access to the file server ) accessed the application in my local system(server) he was getting error saying access denied to the file server to which he has access and i have given impersonation in my application. Another thing is that when i changed the security settings(Toos-->internetOptions-->Security-->CustomLevel) to prompt for password settings even me from my local system was not able to access the file ser ...Show All

• Windows Forms Default Date - Outlook,Calendar,Look,Feel

  I can not Figure out how to set the default date to Today in the Day View. It keeps coming up as July 21. Any one see this and know where in the code to change. Thanks The problem (if it's the same as mine!) is that when you view the outlook calendar, the selected date is not today. In my case it is 5 weeks ago (25th Sept instead of the 31 Oct). Found the cause of this on http://www.slipstick.com/calendar/wrongdate.htm . Basically it's because outlook always shows the 1st day of the current month and because the month view in outlook displays 5 weeks it can cause this behavior. Follow the link for more details The upshot is I couldn't find a cure but it will only happen a few months of the ye ...Show All

• Visual Studio Excute a task once per solution.

  If I have a solution with multiple projects in it, and I call (from the command line): MSBuild xxx.sln I know that it will start building each of projects in the solution. My question is: is there a way to make a task run only once, say with the first project keep in mind that I do not know which is the first one, meaning it has to dynamic. Hi, That's right once per project. If you wanted to perform some customizations on the solution level you could write a wrapper proj file that could achieve this. Its pretty confusing though, I've written up about how to do this at: Use MSBuild to build Solution files . Sayed Ibrahim Hashimi www.sedodream.com ...Show All

• SQL Server SSAS The system is out of memory

  Hi I have a couple of current problems, for which I've been able to find very little info in this forum, or on the net generall. Hopefully someone can shed some light on them... 1) I am receiving application informational events from SSAS 2005 that "The system is out of memory" (Event ID 2). It seems to happen quite randomly. Having received this error, it appears to slowly grind to a halt, eventually not allowing connections from the Management studio, and cube process requests never return. For example, last night a program requested a complete database to Full Process at 03.44 but was still waiting for a response at 07.45 - the process normally takes a maximum of 20 minutes. SSAS would not allow me to connect vi ...Show All

• SQL Server Report Builder in integrated mode

  Hi, I have an installation with Reporting Services in integrated mode with WSS 3.0, with Reporting Services Add-in for SharePoint. I have a document library in witch I added a data source to an SSAS database and a Report model on top of this. When I click Add a Report with Report Builder, the report builder opens, but it fails to connect to the model. There is a dialog window "Select Site or Server "asking for a URL. I put in there http://localhost , but is not working. I am not able to connect to the report model. I will appreciate any help on what could be the reason or how can I investigate this. Thanks, Dan P.S. I did the same scenario on the development environment it works from start, without an ...Show All

• Smart Device Development about microsoft.windowsmobile.directx.direct3d.Mesh

  Can anybody show me a sample , create a Mesh and only one triangle in it ,which defined by code. Thank you in advance. Hoya Use this MSDN link to view the samples http://msdn2.microsoft.com/en-us/library/microsoft.windowsmobile.directx.direct3d.mesh.aspx Manav ...Show All

• Visual Studio 2008 (Pre-release) Problem getting started w/ WPF

  So I'm trying my hand at playing around a bit w/ WPF. I uninstalled the last WinFx 3.0 CTP I had installed, installed the new .NET Fx 3.0 June CTP and thought I'd try my hand at running the Cube Animation sample app. Following the instructions, the app built just fine using msbuild from the command prompt. When I attempted to open CubeAnimation.exe, nothing happens. I then tried opening CubeAnimation.xbap and was present w/ the error you'll find at the bottom of this post. I saw another post on here w/ a similar exception stating that before the Windows Image Component (WIC) also needed to be uninstalled so I followed this instrucutions (Uninstalled Fx 3.0 June CTP, ran the listed command to uninstall WIC, and then reinstalled Fx 3.0 ...Show All

• Visual Studio Team System Microsoft Certification - I need suggestions

  Hi all, I am thinking of doing Microsoft Certified Professional Developer (MCPD) Certification but I am confused as there are three lanes, Professional Developer: Web Developer Professional Developer: Windows Developer Professional Developer: Enterprise Applications Developer I would like to know which lane is the best and most required. Which type of application (Web or Windows or Enterprise Applications) is most developed in the IT industry so that I can do certification for that lane. Please suggest me. I think this forum needs a space for certifications also. Administrators please think about it. Kannan.B Binary Bits. Hey Vikaram, thanks for replying :) Now I am getting an idea which lane to choo ...Show All

• Visual Studio Editing an existing connectionstring with the DataConnectionDialog at runtime

  Can anyone tell me if it is possible to edit an existing connectionstring with the DataConnectionDialog at runtime in my own winform application I can create a new one at runtime in my own winform application using the following code: Microsoft.Data.ConnectionUI. DataConnectionDialog dcd = new Microsoft.Data.ConnectionUI. DataConnectionDialog (); Microsoft.Data.ConnectionUI. DataSource .AddStandardDataSources(dcd); Microsoft.Data.ConnectionUI. DataConnectionDialog .Show(dcd); Once I have created one, I would like to be able to use the same dialog to edit it by feeding it the existing connectionstring information (the equivalent of the PromptEdit method of the MSDASC.DataLinks object). Any help would be much appreciate ...Show All

• .NET Development Same Problems

  Hello all. I have the same problem that many are reporting here. I am using an access db. It is not related to the copy setting. I have tried all three settings and no go. Here's the scenario: I have a datagridview that is bound to a dataset via a bindingsource object. It was created by dragging the table from the datasources window. I do not want the user to update the data in the grid as I will be doing it programatically. I just want it to display the data in the table. I generated the following sample code to try and debug the problem: Dim rw As CIDDataSet1.CidRow = CIDDataSet1.Cid.NewCidRow() rw.Name = "foo" rw.Number = "foo" rw.DateTime = Now rw.Key = "FOO" Me.CIDDataSet1.Cid.Rows ...Show All

• .NET Development Ftp Upload File

  This is my code snippet for file upload. The problem is after all the bytes are written on the server, while doing requestStream.Close() I get error as underlying connection was closed. FtpWebRequest request = (FtpWebRequest)WebRequest.Create(serverUri); request.UsePassive = false; request.Method = WebRequestMethods.Ftp.UploadFile; request.Credentials = new NetworkCredential("xyz", "xyz"); Stream requestStream = request.GetRequestStream(); const int bufferLength = 2048; byte[] buffer = new byte[bufferLength]; int count = 0; int readBytes = 0; FileStream stream = File.OpenRead(fileName); do { readBytes = ...Show All

• Visual Studio Express Editions Publish V C# 2005 with SQL Server Express 2005 Database

  Hi @ll I published a simple program using visual c# 2005 express beta 2 with database type sql server express edition 2005. Everything work fine inside my PC But nothing work in my friend PC ! I can run the GUI but when I trying to enter data error message coming to me say's "Timeout Expired" I tried to install framework 2.0 beta 2 in my friend PC then I Installed the full version of sql version express ! My Q here Do I need to special file to include the program when I publishing it ( and How ) or I should do something more Or I need third party program to help me Installing the program Or Microsoft made this option only in professional version of c# Pleaseeeeeeeeeeee Help me , please I'm alone here AS SOON AS POSSIBLE and I will be than ...Show All