MarkShep's Q&A profile

• Visual Basic WriteAllText Method

  Hi guys, I'm a new VB6 user. I'm trying to write text to a file using the reference provided on MSDN ( http://winfx.msdn.microsoft.com/library/en-us/dv_vbalr/html/f507460c-87d9-4504-b74f-3ff825c7d5c4.asp frame=true ) I'm using this code: Private Sub Command1_Click() ' Declaration Public Sub WriteAllText(ByVal file As String, ByVal text As String, ByVal append As Boolean) End Sub My.Computer.FileSystem.WriteAllText("C:\TestFolder1\test.txt", "This is new text to be added.", True) End Sub When I run it, I'm getting the message "Expected End Sub", I tried adding another End Sub down at the end but nothing changed. There seems to be a problem wi ...Show All

• SQL Server SSIS Flat file connection manager not seeing carriage return-line feed

  I have a csv file as follows: "100,002.01","200,00.01",10.98,aaaaaaa,bbbbbbbbbb "100,002.01","200,00.01",10.98,aaaaaaa,bbbbbbbbbb "100,002.01","200,00.01","1,000.98",aaaaaaa,bbbbbbbbbb Note that the third column in the third line is also qualified by quotes whereas the previous two are not. I think this is because of Excel formatting. Is there any way to import this file correctly My main problem is that I never know whether a column will be qualified or not because this depends on the value. I need to loop through and import many of these files so a manual workaround is not a option for me. You should be able to par ...Show All

• Visual Studio Team System Work Items WorkFlow behaviour

  Hi, I'm working on a workflow implementation using workitems. I found the way to restrict the states transitions and the users groups allowed for each transition.   N ow , I want to know if it’s possible to restrict a specific state transition only for one user (not a group) but not a fixed one . For example, only allow to the user assigned to the work item to change the actual state  to "Closed";    or only allow the person who created the WI to approve it.   Is there any way to do that   Thanks in advance  Hi Silvana,    I'm sorry to say that it ...Show All

• Windows Forms Painting over child controls

   I have a Panel with a few controls on it. But I would like to paint over them on my OnPanel method.    Can this be done  If not is there a way to paint over child controls using managed code or even PInvoke   Thank you,   Artur Moreira This book has a chapter on the same topic: http://www.c-sharpcorner.com/Store/Books/0-32 ...Show All

• Visual Studio Tools for Office Problem when opening another excel file after loading a customized one

  Hi everyone, I have been using VSTO 2005 to create some Excel and Word Smart Documents for the last 3 months. When testing my Excel Customized files I have the following problem (I have already searched the forum, but seems like no one else has posted about it): I have my action pane crowded with Databinded ComboBoxes, I fill them up when the Action Pane Control's Load Event gets called. I also use the ComboBox Text Changed Event to fire some code. When I test the solution, it works as it's supposed to... but if I happen to open another Excel file (a normal one, no customization), it loads the typical task pane welcome screen into t ...Show All

• SQL Server Left or Length Command

  I have a field that contains data such as 'ACB00/02'. How would I write into a function that gathers a load of data together for me a peice of code that will grab only the first 2 chars of the afore mentioned value, So the result would be in the new created colum in a temp table 'AC'. This is to occur over 7,000 records but they are not all AC, I just want the first two from every line. Regards Here's an example using the Northwind database USE Northwind CREATE TABLE #MyTempTable(LName2 varchar(2)) INSERT INTO #MyTempTable SELECT LEFT(LastName, 2) FROM Employees SELECT * FROM #MyTempTable DROP TABLE #MyTempTable HTH, ...Show All

• SQL Server Using Unicode in SQL Server

  Hi I'm have big problems trying to save Unicode information into my MS SQL Server 2000 Desktop Engine. Alright, so the problem I'm having now is I'm working with MS SQL 7.0 and PHP5. I've trying to get information to save into MS SQL, however it is storing it all weird. When I save the information and try to view it in Enterprise Manager it shows it has random characters but for some weird reason I can output that information on the page correctly when I do a SELECT query. Here's an example of my problems. < php $insQ = "INSERT INTO my_tblBusiness ( pkID, fkbusinessID, ntitle, ...Show All

• Visual Studio "Microsoft.Sdc.Tasks" project is not getting recognized

  I have created a web service with default settings. Copied the contents of the Install folder <from the GDN2[1].0.051004.000.zip file> onto a new folder called Build. I created a DevBuild.proj file with the following contents: < xml version = " 1.0 " encoding = " utf-8 " > < Project DefaultTargets = " Full " xmlns = " http://schemas.microsoft.com/developer/msbuild/2003 " > < Import Project = " Microsoft.Sdc.Tasks " ></ Import > < PropertyGroup > < BuildConfig > Debug </ BuildConfig > </ PropertyGrou ...Show All

• SQL Server Reporting Services setup and permissions - UPDATE

  I have Reporting Services set up on a SQL Server machine separate from the development machine.  I have used Reporting Services configuration to set up ReportServices as the virtual directory.  This did place a new web instance under the Default Web directory in IIS (I am using 5.1), however when I got into the c:\inetpub\wwwroot directory, there is not a ReportServices directory.  I thought this is where I would set user permission for the ASPNET account. I have set the permissions to the Reporting Services folder in the C:Program Files\...\ReportingServices directory, however I still am getting an error message about the ...Show All

• SQL Server send mail task

  hi. i want to use the send mail task but i want the recipient's address to be a parameter and the content of the body as well to be based on parameters. is it possible to do that using the dts   if not what is the equivalent procedure in sql server to do this Thanks Make sure the value is being passed to the variable (create one) and then pass it to the send mail task using the expressions by setting the SMTPconnection equal to the variable or through the script command. It should work. ...Show All

• Visual Basic How to use DataGridViewControlCollection in place of Control Array of MSFlexGrids

  Hello, I am learning VB2005 by rewriting a large VB6 program. My VB6 program used loads of MSFlexGrids in a single Control Array. Control Arrays are out with VB2005 so I was looking at a way of using DataGridView controls in the form of a collection. The MSDN documentation points in the direction of DataGridViewControlCollection but I cannot decifer how to add DataGridViews to form a collection and then how to access each one in a similar fashion to my VB6 Control Array. My VB6 program loads the MSFlexGrid's in this simplified fashion: For I=0 to MaxFlexGrid With MSFlexGrid1(I) Code to load cells Next I Is the D ...Show All

• SQL Server SCD component in SQL2005

  Hello, I have problems specifying my historical attribute in the SCD component. Regardless of wich option I choose on the Historical attribute options I cannot choose a field in the table, it is simply empty, nor can I write in the information... I am using the 1st release version so I suspect that this function should be fully functioning. What am I doing wrong and how should I go about this Hanna,  The scenario works for me and it should also work for you on your RTM build(1399). I am not sure at this point why you saw date got set at the enddate column, when inserting a new ...Show All

• Windows Forms Obtaining a bitmap

  Hi, I have a System.IntPtr to an image that has been obtained from a Twain Datasource. I wish to take this and create a bitmap image that I can then put into a picturebox, the code I have used is; dim img as image img = Image.FromHbitmap(Pics(0)) 'where pics is an arraylist of System.IntPtr that is returned from the twain DS. When this runs I get the following exception; An unhandled exception of type 'System.Runtime.InteropServices.ExternalException' occurred in system.drawing.dll Additional information: A generic error occurred in GDI+. Not having too much experience in GDI+ can anyone see what I'm doing wrong TIA Terry. ...Show All

• Visual Studio Express Editions how do you find the friendly name of an application???

  Hey guys, all new to this VB stuff and cant seem to find this anywhere else... I need to find a way to shut down my applications within a time limit... i got the timer and the time stuff to work, and i looked at all the other ppl tellin about how to shutdown an application, now my only problem is that when i create that code snippet for closing the application... For Each proc As Process In Process.GetProcessesByName( "Counter-Strike Source" ) Application.Exit() then it only comes to the first line, checks the name, and then stops... doesnt actually quit counter strike, lol... i play too much n cant stop, this is my way of sto ...Show All

• .NET Development DataTable.Merge but preserve changed rows

  I have a pretty simple question here. I have two data tables that I am attempting to merge. The merge is happening beautifully. However, I need to know what values have changed. It is my understanding that if I were to call .GetChanges() after a merge, I would get nothing, as if .AcceptChanges() had already been called. Basically, I need the exact funtionality of a .Merge() without the changes being accepted. Is there some way to do this, or will I need to go through the columns of each table and compare them manually I already have some functionality in my code to compare the columns of my datatable to see what has changed, however it ...Show All