palmirag's Q&A profile

• Visual Studio Express Editions Import Fixed Width Text File

  Hello, I want to import a Fixed Width Text file so that I can display the results in my Datagridview1. The data looks like this for about 97,000 lines: 999999JoeSmith 33 Main St. 123120060000005035 999999JohnSmith 450 Main St. 10212006000000 503R I can break this down with " Microsoft.VisualBasic.FileIO.TextFieldParser" and create a Dataset then use my BindingSource to populate the Datagridview1. The problem I'm having is the R in the 503R is a value representing a negative value(503R is actually NEGATIVE 5039) where the R is equal to 9. Is there a way to change the R to the 9 before it hits my Datagridview1 and make the number a NEGATIVE value I want to be able to Sum up the values 5035 and -5039 to equal -4. Th ...Show All

• SQL Server Problems importing text files with double-quotes as text qualifier

  I have text data files from a third party and they use comma as field delimiters and enclose the text for each column in double-quotes. Not a problem for most of the data files until they start sending files where there is " within the column values. SSIS package fails with the error: The column delimiter for column "Column 1" was not found. Any ideas on how to resolve this issue will be greatly appreciated. Thanks pcp Another question : In 2005 SSIS,  Is there an easy way to import a flat file like "ABC", "EDFG", "123", "10/1/2006" to a SQL database table, with the last two columns as int and date fields   Always errored out for data type mismatch.  I used SQL ...Show All

• Visual Studio Addin Logging

  Hi, I want to add logging to my addin file. we are using standard loggers, so that you can configure them from the application.exe.config file. Of course we are running inside visual studio, and we don't want the users to have to deal with the devenv.exe.config file. Is there another way to do it Is there a config file for the addin dll something like myaddin.dll.config Is there a way to add logging level to the .addin file thanks. Hi Noa, Carlos is correct. Your addin, could make use of the devenv.exe.config, but we don't really recommend that. The only logging facility currently built into the shell is the IVsActivityLog interface. This is an interface defined in the Visual Studio ...Show All

• SQL Server Cannot connect to the SQL 2005 Express

  I created test project and want to use SQL 2005 database inside. 1. I created Test database with DEFAULT rights 2. I go into server explorer, press Add Connection. Shows message box for connecting to the server: <PCNAME> using windows authntification. But NO database allowed to view :(. Which setting should be set for SQL server database to i could connect and work with it The list is for server, a server can host multiple databases. In order to see your local server in the drop down list, you need to have your SQL Browser running. Did you try to type ".\sqlexpress" ...Show All

• Visual Studio 2008 (Pre-release) Could i generate web pages using XAML

  Hi all, I am new to winfx stuff, i have a question about wpf and XAML... which is If i have a xaml file, could i using the information in this file generates many web pages according to the information stored in the file Thanks a lot Michael Ok, I have another question. I need to develop an application in .NET but I have to provide some UI's for winforms and others for web. Some of those interfaces are equally the same for winforms and web. How could I reuse the development of the UI so I don't have to code the same interface for design for web Could someone please help me or recommed something on how to avoid coding twice for UI. Thanks in advance. ...Show All

• Visual Basic How to upload files

  Hello I got a problem with uploading files. Look at the code: My.Computer.Network.UploadFile ("D:\file.txt", " http://www.onh1986.com/file.txt ", username , password ) And I set permission to "777". And it couldn't to upload the file. What's problem, please Thanks & Regards Okay...is the reason why a secret Do we need to guess I've had success using FTP uploads, as long as the server allows it, which presumably it does since you say you can upload the file using some other FTP program. ...Show All

• .NET Development Multiple Active result sets

  Hello there, Is there any handicaps using MultipleActiveResultSets option in a connection string if needed to work with nested datareader operations Why ADO.NET 1.0 did not implement and why 2.0 has this option Hi, I don't think that there are any handicaps. Currently it is only supported on SQL Server 2005. http://msdn2.microsoft.com/en-us/library/ms131686.aspx Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• Windows Forms serialize TreeNode-derived classes

  Hi, I want to serialize my custom class derived from TreeNode. After searching on Internet I found many answers that confused me so I'm going to as many questions hoping to get the right answers from you. 1) TreeNode is inheriting from MarshalByRefObject so it's not possible to serialize it. but I can do it like this so what are they talking about Code : TreeNode treenode = new TreeNode(); treenode.Nodes.Add("1"); treenode.Nodes.Add("2"); treenode.Nodes.Add("3"); treenode.Nodes.Add("4"); System.IO.FileStream file = new System.IO.FileStream(@"c:\test.dat", System.IO.FileMode.Create); BinaryFormatter serializer =new BinaryFormatter(); serializer.Serialize(file, treenode); ...Show All

• Visual C++ Spy++ hangs getting properties of a window

  In trying to troubleshoot difficulty creating a toolbar, I used Spy++ to look at the attributes of the toolbar window. When I select the window from the list in Spy++ and right-click it, select Properties, Spy++ hangs indefinitely. The toolbar is being created by the following code, in a class derived from CFrameWnd. CFitToolBar is dervied from CToolBar: pFitToolBar= new CFitToolBar; pFitToolBar->Create( this ); pFitToolBar->LoadToolBar(IDR_FitToolBar); pFitToolBar->ShowWindow(SW_SHOW); The result of this code is nothing, although both Create and LoadToolBar return 1 (success). IDR_FitToolBar is a toolbar resource created by the toolbar editor (i e, a set of images for the buttons). Q1) How to use Spy+ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Port asm to HLSL help please

  Could someone who is more intelligent than me please convert the below asm code to HLSL. You will have a place in heaven if you do this ..... :O) Thanks, Dave PixelShader = asm { ps_1_1 tex t0 tex t1 // Specular dp3_sat r1, t1_bx2, v1_bx2 // r1 = (2.0 * (NormalMap - 0.5)) * (2.0 * (vSpecular - 0.5)) dp3_sat r0, t1_bx2, v0_bx2 mul_sat r1, r1, r0 mul_sat r1, r1, r1 mul_sat r1, r1, c2 // Diffuse + Ambient dp3_sat r0, t1, v0_bx2 mad_sat r0, r0, c1, c0 mad_sat r0, r0, t0, r1 }; PixelShaderConstant1[0] = (cAmbient); PixelShaderConstant1[1] = (cDiffuse); PixelShaderConstant1[2] = (cSpecular); I have managed ...Show All

• SQL Server Merge Replication - Setting Identity Range Management.

  Hi All; I am trying to set up Merge Replication on a database and want to set the IdentityRange Management to Auto for all my tables which use a Identity column. In the wizard, on Article Properties Page, I can do this by selecting a Table, and going for its properties, but this is a tedious task as I have ~300 tables to set this property on. Is there another way or a global location where I can set the property to true and even mention the ranges and the threshold, so that I dont have to pick each table and set it individually. I am also aware of the fact that I can Generate a Script and modify it and run that, but I was looking for some way to do this in the wizard. Thanks! Sorry, but you ...Show All

• Visual Basic Check for encrypted match.

  Have reposted as I have an idea what is wrong, below is the encryption routine that I am using, my problem is that every time text is encrypted it uses a different Key. So how do I use the same key so that when the scrambled password on file, is compared to the scrambled password entered they will match Function encryptStringToBytes_AES(ByVal plainText As String, ByVal Key() As Byte, ByVal IV() As Byte) As Byte() ' Check arguments. If Key Is Nothing OrElse Key.Length <= 0 Then Throw New ArgumentNullException("Key") End If If IV Is Nothing OrElse IV.Length <= 0 Then Throw New ArgumentNullException("Key") End If ' Declare the streams used ' to encrypt to an in memory ' ar ...Show All

• Visual C++ _CRT_SECURE_NO_DEPRECATE problem

  I ported my project from Visual Studio 6.0 to Visual Studio 2005.I was able to compile perfectly in debug mode using the _CRT_SECURE_NO_DEPRECATE definition. Unfortunately when i ran it in release mode i got many errors like this:  Error 5 error C2664: 'strcpy' : cannot convert parameter 1 from 'TCHAR [260]' to 'char *'  When i didn't use the _CRT_SECURE_NO_DEPRECATE definition then the above was a warning in debug mode but these dissapeared after i inserted that definition. I put this definition in the Project Properties->Configuration Properties->PreProcessor->Preprocessor Definitions. My preprocessor options are the following: WIN32;NDEBUG;_WINDOWS;_CRT_SECURE_NO_DEPRECATE;_CRT_NONSTDC_NO_DEPRE ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Tool for auto HLSL Generation?

  Are there any tools out there to enable the graphical building of a shader network, such as in Autodesk Maya's Hypershade tool or Softimage XSI's RenderTree tool, which can enable you to use a GUI to set up an object's basic material properties and then automatically generate the appropriate HLSL shader fragments needed to reproduce the material effect in your game without having to manually write HLSL files Certainly, if you want to create complex shader effects, you would need to be able to edit the HLSL or manually create new custom HLSL files, but for creating HLSL files to render basic, standard material properties, there really should be a graphical tool to take some of the work and difficulty out of it. Such a tool should allo ...Show All

• SQL Server Moving databases

  I have a number of questions regarding moving databases off of a sql 2005 server and onto a new sql 2005 server. The new server will have the same name and the same IP as the old database. 1. What is a better method of moving the db's, backing up and restoring to the new server or detaching and re-attaching. Are the rights kept when either of these methods used Or will orphan logins be created. 2. Is there a way that I can keep all the permissions intact when I move the databases to the new server If not, is there a tool for doing so 3. We use reporting services which has two databases, Reportserver and ReportServertempDB. Will there be an issue detaching and re-attaching these databases 4. What other problems could I encounter ...Show All