Manuel5's Q&A profile

• Windows Forms retrieve text into WebBrowser control

  Hello! May be You know how to retrieve text into WebBrowser control I'm using WebBrowser for to show some files like jpg, doc.. and I'd like to add my comments. Thank You ...Show All

• SQL Server OLE DB Source using table name variable

  I have a package-level variable [User::viewName], type = string, containing a view name. I want to setup an OLE DB source to use this variable value as the source, so Data access mode = "Table name or view name variable". The Variable name dropdown contains [User:viewName], so I select it. When I click OK to leave the edit dialog I get the error: The variable User::viewName is required to be of type "VT_BSTR". Only variables of type String occur in the Variable name dropdown; if I try changing it to a type other than string it doesn't occur in the dropdown. What is VT_BSTR and how can I change the variable type to it In my original package Data Flow I had an OLE DB Source with Da ...Show All

• Windows Live Developer Forums When will Live Spaces come out of beta?

  It is awfully S-L-O-W now. When will it become useable for regular users ...Show All

• Windows Forms Vertical Label

  Hi Guys, First of All: Merry Christmas :) Well, I have only one, I guess not so easy, question. How to get a textlabel with vertical text and 45 ° rotated letters I know to get vertical text like H E L L O simply set the AutoSize to false and drag the label to a vertical one. But how to rotate the letters Thanx 4 help Check this thread ... ...Show All

• SQL Server Trigger- dump 'inserted' table to temp table

  I want to pass the 'inserted' table from a trigger into an SP, I think I need to do this by dumping inserted table into a temporary table and passing the temp table. However, I need to do this for many tables, and don't want to list all the column names for each table/trigger (maintenance nightmare). Can I dump the 'inserted' table to a temp table WITHOUT specifying the column names Great! Could you email your code to yshteyman@hotmail.com I greatly appriciate your effort! Yulia ...Show All

• Visual Basic How do i use enums from a parent class in a child class. 'Reference to a non shared member requires an object reference.

  Public Class EmailParser Dim SQL As New SQLCommunication Dim pEmailMessageEnumerators As [Enum] Dim pEmailReplaceStringIdentifier As String ' define a class or a property to set the emums of the mail types to be used in this parser ' the enums must be in a certain format ie: ' EmailType = Value ' this is used to recover the email message from the database using its value Public Property EmailReplaceStringIdentifier() As String Get EmailReplaceStringIdentifier = pEmailReplaceStringIdentifier End Get Set ( ByVal Value As String ) pEmailReplaceStringIdentifier = Value End Set End Property Public Class EmailMessage Pu ...Show All

• SQL Server Connecting to multiple SQLserver

  Hello, I am working on to design SSIS package which need to run scripts against multiple sqlserver and need help. Basically I need to connect several SQLserver machine to get a data and insert to our central respository. Any help or tip appreciated. Thanks -- Farhan Thanks for the help. Just wondering how to setup SQL task to update the connection for the second package TIA -- Farhan ...Show All

• SQL Server Attaching a db - missing log (ldf)

  Hello, I'm trying to re-attach sqlserver 2005 db. I have the mdf file but I don't have the log file. When I try to attach, I get the appended error. Is there anyway, around this Thanks Houman TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'SERVER'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Mic ...Show All

• Visual Studio Can I make two DSL models interact ?

    1. I want to create Relational model  DSL and Object model DSL, and I want that Relational model produced code dependent from object model. Can I do it if possible - Please point to some related sources. ___________________ 2. I want to create visual relationshop between two models, can I do it To place DSL' on two Winforms panels and draw connecting graphics around them   Or can I add visual artifacts to generated DSL deisgner this way as for team designers: picture: http://msdn.microsoft.com/library/en-us/dnbda/html/softwarefactwo_fig4thumb.gif from: http://msdn.microsoft.com/vstudio/teamsystem/workshop/sf/default.aspx pull=/library/en-us/dnbda/html/softwarefactwo.asp#softwarefactwo_topic6 _____ ...Show All

• Visual Studio Team System Team Foundation caches virtual image workspace location

  Hello! We have a new development team (.net2.0 technology) that created a virtual image with a bunch of softwares on it along with Team Explorer. This image was created by one developer (domain account: dev1). In Source Control Explorer, he created a workspace called dev1WS and mapped the team projects to local folders on to D:\Development (D:\Development\TeamProject1 and D:\Development\TeamProject2). After everything was tested, the VM Ware image was distributed to all his team members. All team members got Team Explorer and VS2005, but Source Control with No workspace mappings. But, the local folders D:\Development\TeamProject1 and D:\Development\TeamProject2 were created with all the source code. Problem: The new user goes ...Show All

• Visual FoxPro How do I creat a print button?

  How do I create a print button in Form of VFP9 that will print only the current record Will appreciate and thanks in advance... This is a very generalized question. Here's a generalized answer: First, drop a command button on the form. Set the caption of the button to 'print' or put a little printer icon on it. In the click method you would put whatever commands you need in order to print the current record. The method of printing the current record will vary, but I think you would use a report form (Which you have to generate first). So your command in the click method you would have something like this: report form someform next 1 to print preview Again, there are diffe ...Show All

• SQL Server Selling my software and SQL server 2000 as part of the package

  Hi everyone, I have developed a VB6 application that works with SQL server 2000. My client does not have a SQL server installed on their machine. I wonder do I have to purchase a copy of SQL server 2000 and install it to client's computer How much would a basic version of SQL server 2000 cost I am new to the softwarel world. Please give me some advise. Thanks Hi there I have a similar question - but my database is likely to be for 15+ users with a server-based network as well as being web-based at some future date. It is also likely to be too big for SQL Server Express. So I presume I will have to load SQL Server 2003 onto my customer's server. Is that right Thanks Steve ...Show All

• Windows Forms Enabling/Disabling ToolStripMenuItem objects

  Hi, I have a big MenuStrip and I want to create a Sub to enable or disable each ToolStripMenuItem, where the Item name and the status are parameters for the Sub. The Sub can be something like: Sub SetMenuEnable(ByRef MenuName As String, ByRef Status As Boolean) myMenu.Items(MenuName).Enabled = Status End Sub Any idea how to do it in vb.net 2005 Thanks Cristian That was great saved me a lot of pain while programming for setting user menu priveledges. Thanks. Great Work. ...Show All

• Microsoft ISV Community Center Forums Highlight Row depending on cell - Excel VBA -

  Hi All I need some help with this code ...... I have a sheet full of data, Col A , B & C full of data and col D is 1 or 0 ... I need to highlight all rows in red whenever there is a 0 in Col. D when i press a button (that i know how to create !) I don't want to use conditional format as the sheet slows down drastically using this method !! Thanks Try this Sub Hilite() Dim lngRow As Long Application.ScreenUpdating = False lngRow = Range("D1").End(xlDown).Row Do While lngRow > 0 If Cells(lngRow, 4).Value = 0 Then Rows(lngRow).Interior.ColorIndex = 3 ' red End If lngRow = lngRow - 1 Loop Application.ScreenUpdating = True End S ...Show All

• .NET Development insert rollback

  I am looping through a directory to retrieve the xml files. For each xml file, I loop inside it to retrieve the values of the elements... For each record that I am retrieving inside the xml file, an insert query is called to populate a sql server table. For example; lets say there are 30 records inside an xml file. Each record gets retrieved and inserted into the sql server table until the last record is done. What if as you are inserting into a table, then suddenly say record number 6 fails to insert. How and when do you cater for the rollback I ask because I am not sure when to rollback becuase in the mentioned example the first 5 records have been commited anyway. Any thoughts please Thanks you can use ...Show All