Visual Basic Expert's Q&A profile

• .NET Development ExecuteNonQuery returning -1

  I'm executing my update method successfully, and the record is being updated in the database, but the ExecuteNonQuery is still returning a -1. If thats the case then I won't know if the update was really successful or not. Here's a piece of the stored procedure: ALTER PROCEDURE [dbo].[Table_Update] ( @ContractID BigInt, . . (A lot of code) . @Updated DateTime ) AS SET NOCOUNT ON UPDATE [ContractMaster] SET [ContractType] = @ContractType, . . (A lot of code) . [Updated] = @Updated WHERE [ContractID] = @ContractID Here is the method: public static int Update(Int64 contractID, ...) { try{ using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand()) ...Show All

• Smart Device Development Problem with class library on Smart Device

  I create a class library for my PC and use it in a C# applications ant it' s right. After I use it in a C# smart application but it don't work, I receive an method exception, but the method there is. I decide to recompile the class library for smart device (PocketPC 2003 ARM processor), whene I build the project I receive this error: Error    3    error C2871: 'System' : a namespace with this name does not exist    c:\Documents and Settings\Golem\Desktop\Projects\SmartKey\SmartKey\AssemblyInfo.cpp    3    Error    4    error C2653: 'System' : is not a class or namespace name    c:\Documents and Settings\Golem\Desktop\Pr ...Show All

• Smart Device Development troubles from a begginer

  hi people ! i'm really a begginer with VS2005, and of course with device programing . My question is: working with NOTES.exe, I can move the text file .pwi from main memory to server path, using the device’s commands cut, copy, delete and refresh mannually. Is it possible to made it using a windows form , to move files from device to server’s path by clicking a command button and is it possible to use wild chart like *.pwi to move various files at once or : HELP , HOW CAN I DO IT sorry about poor english I’m a brazilian guy and thanks for your consideration ! Take a look at the functions in System.IO.File. Copy will make a copy, then delete the original. For handling wild cards, yo ...Show All

• Windows Forms how to make form Visible in a "WORD" event handler?

  when i open a word document use Word.Application WordApp = new Word.ApplicationClass(); and then make the form invisible this.Hide(); but i can't make the form visible after the document be closed. private void WordApp_DocumentBeforeClose(Word.Document doc, ref bool cancel) { this.show(); } the whole code like this: private void button15_Click(object sender, EventArgs e) { Word.Application WordApp = new Word.ApplicationClass(); openFileDialog1.FileName = "*.doc"; if (openFileDialog1.ShowDialog() != DialogResult.OK) return; object fileName = openFileDialog1.FileName; object readOnly = false; object isVisible = true; object missing = Syst ...Show All

• Visual Basic Defining a class so that an equals operator works

  Given Class A Inherits somestuff Adds someMoreStuff Public Overloads Shared Function Equals( ByVal objA As Object , ByVal objB As Object ) As Boolean ' does some checks and calls equals End Function Public Overrides Function Equals( ByVal b As Object ) As Boolean Takes some short cuts to see if we need to do more work i.e. if b is me then return true locks for value equality of parts of someStuff and someMoreStuff End Funtion End Class First my apologies for the terrible look above. I copied out of the IDE, and I've made my feelings known before about this blankety blank user interface. QUESTION: What else do I need to add so that dim aaa as new A,bbb as new B if A ...Show All

• Visual Studio Express Editions Link errors : InterlockedBitTestAndComplement, MemoryBarrier, RtlSecureZeroMemory

  Well, I rarely ever post for help but I am at a complete loss, and am not sure if anyone can really even help with this problem. Anyways, here it goes: I have written a ruby extension which compiles and runs fine on Mac OS X and several *nix systems. I have been working on porting it to a windows system. It currently compiles fine, but completely craps out on the linking stage. Here is a paste of what happens: (using Visual Studio Express command line tools) Compilation: straightforward, no issues, but here it is anyways: [code] Z:\rubysound\ext\rubysound>nmake Microsoft (R) Program Maintenance Utility Version 8.00.50727.42 Copyright (C) Microsoft Corporation. All rights reserved. cl -nologo -I"C:/Program Files/FMOD SoundSystem/FM ...Show All

• SQL Server Writer role: db_dtsadmin but where and how?

  I'd like to grant this role to a domain user. But I don't see how. tia enric vives wrote: I'd like to grant this role to a domain user. But I don't see how. tia this is a guess: add the user to the db_dtsadmin group ...Show All

• Architecture Internal classes

  Can anyone tell my where I find information about implementing classes inside other classes For example: Class Outer { Class Inner_1 { } Class Inner_2 { } } How to let the outer class use the inner classes How to let the inner classes use the outer class How to collaborate between inner classes On beforehand thank you - dampbarn I found a place to start: http://en.csharp-online.net/Nested_Classes If othters have links to more extended examples, they are very welcome. dampbarn ...Show All

• Visual Studio Tools for Office Is there a new product.xml file for the VSTORuntime bootstrapper directory for VSTO SE?

  I have gone through "the" two articlaes on deploying a VSTO application. In the first article, it mentions sample files that I have downloaded and copied over to the bootstrapper packages directory. However, I get a warning about the public key not matching when I build the solution. When I run the instal package, the client machine says that there is a newer version of vstor. It tries to locate the newer version but never does. (I keep getting the same installation error message over and over.) What I think is wrong, is that the sample files were created with the previous version of vstor not the new vstor se. How do I either get the updated product key for the new vstor se or get/create a new product.xml file Or - do I have ...Show All

• SQL Server Recompile SQL Task with Data flow task

  Hi, I created a package with SQL 2005. The package gets the Access DB and then inserts it into SQL Server. If I open the package in .NET, I can see the SQL Task and Data Flow Task. The SQL Task has a property sqlstatementsource, which has the necxessary SQL code to create the tables. How can I tell the SQL Task to recompile the SQL code if I give it another DB name, because the tables differ and don't map in the Data Flow Task Thanks Does your new Access DB have different tables If so then no, you have to rebuild. SSIS is not an automated import tool. If you access tables change structure then how do you know the mappings SSIS is data transfer from oe table to another, both must exist, or you must supply ...Show All

• Visual Studio Express Editions Security Warning Running VB Program

  Hello I have written my first a short VB program but each time I run it I get security warning box. How do I correct See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.CodeAccessPermission.Demand() at System.Windows.Forms.SystemInformation.get_UserName() at AutoBackup.Form1.Bu ...Show All

• Windows Forms ClickOnce Workaround.

  hey guys, I need help from you guys. Just a few questions if these can be dealt with. 1. Is it possible to use click once without its backward compatibility I mean would want the newly published files(all files) overwrite the old ones. Would it be possible 2. Just wanna hear your ideas on this guys. For example, we have multiple servers running. Considering a multinational compay that has employees on North America, Asia and Europe. Each continent is being represented by a server. The purpose of which is that every time theres an update, those employees from europe would just connect to the server on europe and so is USA and Asia with their assigned servers respectively. Would it be possible for ClickOnce to deploy to multiple servers ...Show All

• .NET Development Create table access database?

  I have access database,one table Table1 and I wont to create another table but with the same structure as the table Table1 (columns: Broj iksice,Prezime,Ime,Broj indeksa,Broj pohadjanja). I used this code: Dim veza As OleDb.OleDbConnection = New OleDb.OleDbConnection(Global.Diplomski1.My.MySettings.Default.Studenti1Connection) Dim comm As OleDb.OleDbCommand = New OleDb.OleDbCommand("CREATE TABLE Marko ([Broj iksice] DOUBLE PRIMARY KEY UNIQUE, Prezime TEXT(30) NOT NULL, Ime TEXT(30) NOT NULL, [Broj indeksa] TEXT(20), [Broj pohadjanja] INTEGER)", veza) comm.ExecuteNonQuery() for creating table in the database. Code for creating table in the dataset Studenti1Data Private Sub Button6_Click(B ...Show All

• .NET Development How to perform wildcardsearch on ou in DirecotrySearcher?

  Hi! I want the user to be able to to perform wildcard search on both full names and and ou's, the result shoul be like 'all users that start with an e and belon to firm.lan.users.department'. I've tried search 'ou=', 'memberOf', 'organizationUnit' etc. but they all return zero results... can anyone help me I'll send sith it my code.... DirectoryEntry entry = new DirectoryEntry (); entry.AuthenticationType = AuthenticationTypes .Secure; DirectorySearcher entrySearch = new DirectorySearcher (); entrySearch.SearchRoot = entry; //entrySearch.Filter = "(&(&(&(objectCategory=person)(objectClass=user))(cn=e*))(ou=p*))"; This is the line that does not work! entrySearch.Filter = "(&(obje ...Show All

• SQL Server Move .ndf file to a different drive

  I have a several indexes on a filegroup that I would like to move to a different physical drive. I am aware of the sp_detach...sp_attach routine which allows moving the .mdf and .log files to a different location. How would I go about moving a .ndf file though TIA Thanks Simon...that worked! I just wasn't sure if that's how it was done. Needed some reassurance! And...I'll definitely consider giving my next DB a .simon extension! :) ...Show All