yanivpinhas's Q&A profile

• Visual Basic How to retreive network adpater information from remote machine

  Hello, I am completely new to the Visual Basic langauge -although I know VBScript pretty well. I am working a making a tool that connects to a remote machine and gathers some statistics from the network adapter. However, I have no clue as to how to connect to a remote machine. I tried looking for code examples, but I couldnt find anything (which doesnt suprise me because I dont really know what to look for) In VBScript I would probably use WMI -is that also true in VB If so, how do I use it in VB If not, what should I be looking at Any code examples or help that you can give would be very appreciated Regards, Jeremy Hello, Thank you. I think I am finally beginning to catch ...Show All

• Software Development for Windows Vista Sub-workflows

  Hi! I am re-hosting the designer and I want to have sub-workflows. By clicking on an activity in the root workflow, I want a new form to pop up with a sub-workflow. This is implemented. My question is how I can save the sub-workflow to the root-workflow when I close the sub-workflow form Here is some of the code for a customActivity in the root-workflow: protected override void OnMouseDoubleClick( MouseEventArgs e) { base .OnMouseDoubleClick(e); DesignerShell subWorkflow = new DesignerShell (parentActivity); subWorkflow.ShowDialog(); } When double-clicking, a new form will open with the customActivity (as a root activity). When I close the sub-workflow form I seem to loose eve ...Show All

• SQL Server Capturing Execution Results

  Hi All When running an SSIS Package from BIDS, we get to see the "Progress" tab which explains us the progress of the SSIS Package. During production, is there any way to capture this log. I am interested in using this as a log file for each run of my SSIS package. Thanks, S Suresh Suresh S wrote: I tried loging. But I want some Progress Reporting similar to one we see in the Execution Results. Any thoughts on this Thanks, S Suresh The information in the logfile is exactly the same as in teh Prgress tab. ...Show All

• SQL Server Trigger

  hello team: i have two tables order and orderdetial, i want from the orderdetail the sum of the quantity of products  for each order and then insert this sum in order table infront of each order this is the first part: declare @s decimal select @s=sum(f.quantity) from orderdetails as f inner join orders as a on a.orders= f.orders group by f.orderdetails any one have advise, thanks lot Re ask :     my question is :    i have master and detail tables , the pk of the master used many times as fk in the detail table, i want to make for ex a trigger to get the sum for a feild of the fk then insert this sum in the master table in feild total like productid and store ...Show All

• SQL Server Oracle 9i -> SQL Server 2005: Violation of PRIMARY KEY constraint

  Hi there, When the distribution agent runs trying to apply the snapshot at the subscriber I get the following error message Message 2006-06-24 12:41:59.216 Category:NULL Source: Microsoft SQL Native Client Number: Message: Batch send failed 2006-06-24 12:41:59.216 Category:NULL Source: Microsoft SQL Native Client Number: 2627 Message: Violation of PRIMARY KEY constraint 'MSHREPL_1_PK'. Cannot insert duplicate key in object 'dbo.ITEMTRANSLATION'. 2006-06-24 12:41:59.216 Category:NULL Source: Number: 20253 What could possibly cause this error And how can I possibly fix it Best regards, JB i have the same problem with with Oracle 10g -> SQL Server 2005 (see Link ). I use replication (merge ...Show All

• Microsoft ISV Community Center Forums Live Communications Server tab does not show up

  I have just installed Live Communications Server 2005 Standard in my test enviroment. I have a seperate server as a Domain Controller (all servers are Virtual Servers on one physical machine). When I followed all the steps during installation, no errors show up. Also, the HTML log files only display green 'success' items. However, when I open the User Properties window on my DC, there is no Live Communications Server tab. It should show up there, but it isn't. Also, when I open the Live Communications Server Management Console, I only see an empty screen and no 'tree-view' of possibilities. When I manually add the snap in after running mmc, it works and I can see the Forest, Domain, etc. Nothing, except the Management Console, di ...Show All

• .NET Development 8 byte Guid’s with .NET

  Hello folks, is there a possibility in .NET to generate 8 byte Guid’s Or do i have to generate them on my own Thx for your replies. Kris Hi, the first reason ist the security. They must not be predictable. The second reason is, that, with for example a range from A to Z and 0 to 9 and 20 digits i have a bigger range (more combinations) than with auto increment from database. I think so at least.. and my database table will have many records. Greeting from Germany, Kris ...Show All

• Visual Studio Express Editions Focus

  How do I remove focus from a textbox programmaticly please Thanks for the answers ! Now I am more convinced there is a bug in VB Express as I can't even force the focus away. I am referring to this issue http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=919504&SiteID=1 ...Show All

• Visual Studio Express Editions Embedded fonts doesn't work in printing controls ?

  Hi, i'm writing a .Net application for printing barcodes to my climbing club. For simplicity reasons, i've embedded my barcode font as a ressource file. When loading my font as a private font i am able to use it in labels, textboxes, etc... but not in printing controls, like printpreviewdialog Could you please help me Here is my code for loading my font : Imports System Dim MyEmbdFonts() As String = {"code25I.ttf"} Dim FntFC As Drawing.Text.PrivateFontCollection = GetFont(MyEmbdFonts) Public CBFont As New Font(FntFC.Families(0), 42) Public CFont As New Font("Arial", 10) Private Declare Auto Function AddFontMemResourceEx Lib "Gdi32.dll" _ (ByVal pbFont As IntPtr, ByVal cbFont As Integer, _ ByVal pdv As Integ ...Show All

• SQL Server Error when using 'LIKE'

  I am running the following query using Query Analyzer against an MSDE version. The query seems like a textbook use of 'LIKE', so the error makes to sense to me. Thanks for any help. SELECT _FAX FROM _IRISH_BNB_DETAILS WHERE _FAX LIKE "[A-Z]%" Error: Server: Msg 207, Level 16, State 3, Line 1 Invalid column name '[A-Z]%'. Thank you! I was following an example in "SQL Server 2000 Administrator Companion" on page 309 that uses double quotes. ...Show All

• Visual Studio Express Editions Problem with PictureBox >? If i tested?

   I want this photo Usa.jpg to show in picturebox .              if TextBox1.Text = "Usa" then           PictureBox.Show This --> Usa.jpg How  ::In Visual Basic 2005 Express Edition:: Ok... I see your code currently works only if UK is entered in the TextBox1. Modify the code so it will try to load whatever is entered in the textbox: Dim imageFileTemplate As String = "C:\Documents and Settings\Kastriot\Desktop\Test 04\Test 04\MyPicture\{0}.jpg" Dim path As String = String .Format(imageFileTemplate, TextBox1.Text) If ( My .Computer.FileSystem.FileExists(path)) Then PictureBox1.Image = Image ...Show All

• SQL Server Freeze Pane functionality during Export to Excel

  Hi All, I have created a Report using Sql Server 2005 Reporting Services. When I export the report to excel, I want to freeze the pane of the headers in the exported excel. Any pointers on how to achieve this will greatly help me. Thanks, S Suresh There is no way to tell the Excel renderer to freeze an arbitrary pane. However, the renderer does set a freeze pane for the page headers (not the table headers), so that might be a possibility for you. ...Show All

• SQL Server An Unknown error has occured in WMI provider

  Hi All, I am new to sql server 2005. I tried to connect to reporting services configuration manager. it gives an error An Unknown error has occured in WMI provider. error code 80040219. so please help me out regarding this issue. Hi, I also have this message <<An unknown error has occured in WMI provider>> when I run <<Configuration de Reporting Services>> from the <<Start Menu>>. I moved some directories and configured some rights and it may not have liked it. I am deleting all reference to MS SQL Server on my hard drives using Unlocker and CCleaner, I will then reinstall and see...... Configuration : Microsoft Windows XP Pro SP2 Microsoft SQL Server 2005 ...Show All

• Visual Studio Express Editions String resources

  I have about 100 string stored in string resources. I need to go through them all and select various ones based on other criteria. In vb5 I could sequence the resource identifier and use a for next loop. Example: For i = 1000 To 1100 If S omeValue > SomeOtherValue Then msg = msg & LoadResString(i) End If Next I'd like to know how to do something similar in VB Express. I appreciate your response. Unfortunately, I don't know how to do what you suggested. Ten hours of research and I'm more confused that when I started. I found lots of sample code but none that explained how to make the code work. More help would be appreciated. ...Show All

• SQL Server Which tool can be used to format the codes?

  Hi all, Which tool can be used to format the codes for example: I write the codes like this: select column1,column2,column3 from mytable where column4='test' expecting results: SELECT column1,column2,column3 FROM mytable WHERE column4='test' also, some indent can be added to make the codes more readable. Thanks, Here's a great product from Red-Gate that will do the trick: http://www.red-gate.com/products/SQL_Refactor/index.htm Chris ...Show All