GB_2007's Q&A profile
Visual Basic know a file size
Im trying to know which is the size of a file in my hard drive but i cannot find the way to do it. Can anyone help me Thanks Dim fi As New IO . FileInfo ( "FullPathAndName" ) Dim FileSize As Long = fi . Length ...Show All
SQL Server Someone have any idea about it?
I have a table call CLIENTE and another table call ENDERECO where the CLIENTE table has the FOREIGN KEY of the ENDERECO table. When I try INSERT COMMAND in C# this message is show. The instruction INSERT conflicted with a constraint of FOREIGN FUNDAMENTAL "FK_CLIENTE_ENDERECO." The conflict happened in the database "E:\ARQUIVOS DE PROGRAMAS\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\DATA\LINETEC.MDF", table "dbo.I ADDRESS", column 'IDENDERECO.' The instruction was concluded. I am a "little" lost. Thanks. This is a confusing error message. Apparenly there is a table [I ADDRESS] that has column IDENDERECO with a relationship to one of the tables also. Can you go into Enter ...Show All
Visual C++ Is this bug fixed - "Add/Remove operation is impossible"
I very recently bought VS2005 and came across this bug while developing MFC apps (c++). "Add/Remove operation is impossible, because the code element XXX is read only" I have seen this bug discussed in the msdn forums dating back to well over a year ago. Has this bug been fixed yet If so where do I download the fix from Whats the point of developing an MFC application in VS2005 if the wizard does not work Its absolutely insane!! I might as well go back to using VC++ 6. (This is the second fustrating bug I've come across in VS2005, if you see my other thread). Yes, the issue described in the referenced product feedback issue ( http://connect.microsoft.com/Vis ...Show All
Visual Studio Express Editions How to find missing numbers
I am trying to figure out code to determine which numbers are missing from a column within a datagridview based on a number entered by the user. In other words, if the user enters 10 into a textbox and there are 3 rows of data in a datagridview that contain 2, 5, and 7 in a column named Number, then I need a string result to be "1 Or 3 Or 4 Or 6 Or 8 Or 9 Or 10". Can anyone help me I'm sure it has to involve For, Next statements and possibly some If, Then statements, but I can't follow the logic and put it to code. For an added challenge, The "numbers" in the column are actually strings, with the number 1 displayed as "001", the number 10 as "010", and the number 100 as "100". But, ...Show All
Visual Studio Tools for Office Importing Text File into Datagrid View
Hi everyone, I want to import the details from Text File. The Text File Contains Name,Idno Raja,101 Siva,102 I want to set Name,Idno in the Column Headings and the below details are intserting the rows. Previously I used some Steps They are In Datagrid View Task ---> Add Project Datasource Select Database Click New Connection Click Change to select Datasource Type Select Microsoft ODBC Datasource Select use Connection String and Build Create a New File DSN for Text Driver and Next Save the connection Select Table in Database Objects But when I Click Finish that time <`C:\`..`Nandhu.txt`> Could not get column information for database object named '`C:\`.. ...Show All
Visual C++ Decimal code
Hey guys, I am new with this whole Visual Basic program and I am new with the C++ world. I am trying to make a program and I was wondering how you make decimals I am making a little calculator for my brother and I was wondering how to make it desplay and calculate decimal numbers. Thanks! Burgz wrote: I am new with this whole Visual Basic program and I am new with the C++ world. Are you writing this in VC++ or VB Burgz wrote: I am trying to make a program and I was wondering how you make decimals In VC++, that would be e.g. " float n = 0.5; " ...Show All
Software Development for Windows Vista How to get the value of the Property in statemachineworkflow
I registered some properties in my statemachineworkflow When my workflow is running, I have the instanceID of the workflow, How can I get the value of the property Thank you very much. I tried following way,but failed. StateMachineWorkflowInstance smwi=new StateMachineWorkflowInstance(WorkflowRuntime,instanceID); return ((myWorkflow)smwi.StateMachineWorkflow).myValue; You may want to look at a simple tracking sample I created for just this purpose. It allows you to easily get the current property values for a workflow at runtime. http://pluralsight.com/blogs/matt/archive/2006/11/25/42637.aspx Matt ...Show All
SQL Server Merge Replication using SSL on a Windows Mobile 5.0 device
Dear ppl, I have a windows mobile 5.0 application that syncronises with SQL Sever 2005 (Merge Replication). The replication works fine without SSL. But when using SSL it doesn't work .On the device i get an error 28037, A request to send data to the computer running IIS has failed . I have created a a Wild Card Certificate (*.domain-name.net) using Microsoft Certificate Services (Stand Alone) and setup the replication website with replication virtual directory under it , in IIS, to use this certificate. The host header for the replication site is set to "sql.domain-name.net". I have binded the host headers to the port as well. I can access the https://sql.domain-name.net/replication/sqlcesa30.dll fro ...Show All
Microsoft ISV Community Center Forums When sending a worksheet to the USB port …
Hey, When sending a worksheet to the USB port … (memory stick). How do I detect if the memory device is not in the USB port …. and how do I handle the error if its not there Best Regards Cathrine Hey Derek Thanks for your reply. I have a workbook that I want to save to a memory stick. How can I write the code so it will detect witch drive letter the USB have Cath Dim fsoObj As Scripting.FileSystemObject Set fsoObj = New Scripting.FileSystemObject With fsoObj If .Drives("E:").IsReady = True Then 'code goes here End If End With Set fsoObj = Nothing ...Show All
SQL Server Can you use Rank to get rows 51 to 60 of a query?
I have not installed SQL Server 2005 yet (hopefully this weekend), so I have not been able to experiment yet. One of the things I had hoped would be added to T-SQL is a way to get a range of rows out the middle of a query to populate a table, e.g. when you are showing the user page 6 of many. I had been hoping for a variation of SELECT TOP something like: SELECT ROWS 51 TO 60 * FROM MyTable WHERE State = 'CA' ORDER BY CustomerNumber I don't see anything like that. Is there a way to do that I have not seen Can I use RANK in the where clause to do this My backup plan would be to do a subquery with rank in it, and put the where in the the outer query, but it seems like the same logic that returns top 10 could ju ...Show All
SQL Server MS Access SQL server 2005
I'm able to connect to SQL Server 2005 express using SQL Native and see the data and create reports in MS Access 2003. But I cannot change the data, is there an option or permission I forgot I seen multiple posts that MS Access is not the best tool for doing simple reports. What would be better I don't want to create a Web Page etc, InfoPath Also, I would like to stick with SQL Server Express... Make sure you have a Primary Key on all your tables before you link them to Access. As long as the user you are logging into SQL as has permissions to change the data you should be able to change the data from within Access. Personally, I think Access is the best tool for doing simple reports, but that's m ...Show All
Windows Forms Microsoft Browser Component INCOMPATIBLE with Internet Explorer 7 In Certain Cases
I have a discovered another bug :( . Microsoft Browser COM component does not work with .swf files with IE7 installed. Two users of my program have complained that it hasn't work, they both have Internet Explorer 7. I don't use webbrowser becuase...ITS BUGGED TOO (stupid Windows bugs)....flash buttons dont work in webbrowser so I am forced to use Microsoft Browser... What can I do to fix the problem Embedded swf files do work, but the the swf file directly does not work... This blog entry seems relevant... ...Show All
Visual Studio Tools for Office Calculating the height (in mm) of a text line in Microsoft Word
I'm making a program, in VB.NET, that creates and fills a table in a Microsoft Word document. Therefore I need a method to calculate the exact height, in millimeters, of a text line written with a certain font, at a certain size. Searching the Internet I've found this: Private Function GetFontHeight(ByVal FontName As String, _ ByVal FontSize As Single) As Single Dim myGraphics As Graphics = Me.CreateGraphics() Dim myFont As Font = New Font(FontName, FontSize) myGraphics.PageUnit = GraphicsUnit.Millimeter Return myGraphics.MeasureString("Ag", myFont).Height * 0.9 ' <<< STRANGE!!! End Function The result was so imprecise that I had to add that 0.9 coefficient (I calculated it with several attempts ...Show All
Windows Live Developer Forums contact control and activity
Hi is it possible to use the gadget in an MSN activity window Thanks Danny, keep in mind that Messenger blocks quite a few things (certain JavaScript features) so it could be hard to accomplish in an activity, but I am sure it should be possible (have seen it working). I will try to find it out and I will post the results here as soon as I know more. ...Show All
Smart Device Development Secure password storage
Hi, I'm making a business PDA application which gets and sends data from and to an Axapta database. For this i'm using SqlCE3.0 The problem I have now is that I have quite some bits that are sensetive information, namely the username/pass of the IIS folder where the SqlCE dll resides and the username/pass of the Axapta database. if possible i'd like to store the passwords in a secure storage on the device, does this possibility exist and if not, is it safe to store the key to decrypt/encrypt a password in code (I assume not, but where else if no secure storage exists) Thanks in advance, Ben. Or you can ask user for a password on your application startup and authenticate on the server ...Show All