MoonWa's Q&A profile

• Windows Forms c# getting crazy with a simple insert into....

  Hi all :) Here is my problem: myCommand = new SqlCommand("insert into myTable values("@field1")", myConnection); myParam = new SqlParameter(); myParam.ParameterName = "@field1"; myParam.Value = myTextBox1.Text; myCommand.ExecuteNonQuery();   Whatever i write in myTextBox1.Text, in database i obtain ever a "null". If i modify my insert like:"insert into myTable values('" + myTextBox1.Text + "')"; it work...but we know that it isnt a safe way to solve proble, thinking at sql iniection for example... So...a gentleman that show me where i wrong Thx in advance. Have you added myParam to myCo ...Show All

• SQL Server Is there a free DTS Import/Export like tool I can use with SQL Express?

  I am wanting to import my MDB file into SQL Express. Is there some free way of doing this Since the SQL 2000 DTS tool works I imagine there is something out there or could be made that can do the same thing. ...Show All

• Visual Studio Tools for Office Outlook 2003?

  Needed to know if it was possible to use 2 calendars (main and a secondary) and have pop up reminders enabled for both. This would be used for one user. Ex: one calendar for business the other for personal, need both to have pop up reminder enabled. Bob, Are you trying to do this in code with VSTO/VBA or is this a general question about the user of Outlook 2003. If it's the latter then you would be better off looking at some of the links listed in general resources at the top of the forum (Mike's posts). If you're trying to do this with VSTO then write back and we'll try to help. Thanks, Ade ...Show All

• SQL Server Cant reference web service

  Hello, when I browse to this page http://agamenon:90/reportserver/reportservice2005.asmx I can see the xml correctly, when I put this in the add web reference wizard in vs 2005 it asks me user, password and domain, indefintely, I cant be wrong more than 3 times in my password. It keeps asking me user and password and domain, if I click Cancel, I can view the methos, but the Add reference methos is disabled. ...Show All

• .NET Development VS service proxy class generation not handling output parameters correctly

  I am attempting to conusme a third party web service.  When I have Visual Studio(VB) generate the service proxy class, it does not handle the output parameters correctly. Instead of ussing the given parameter, say "Status", it includes it as an input (byVal), and creates a new parameter "Status1" as the byRef output. Is this a problem with the wsdl If this forum accepts this post, I will include the wsdl in another post. Thanks in advance for any ideas. Tracy Spratt Hmm, the wsdl breaks the post.  How can I post it safely ...Show All

• Visual C# can my C# assembly know when it's been loaded?

  I am writing a C# assembly that is completely independent from its host. This assembly doesnt have a single functional point of entry (it has a lot of objects that can be used in various ways). Is there a way i can be notified on the first time, just once, that my assembly is loaded/and or being used I need to know this in order to trigger an initialization of a resource. Thanks. Make the resource available as a property, and then lazy initialise it ( that is, initialise it the first time it is accessed ). ...Show All

• Smart Device Development Can eVC++ 4 SP4 be used for Windows Mobile 5.0 development?

  Hi, As stated in the download page of the SP4 for eVC 4: <<Service Pack 4 (SP4) allows existing eVC4 users to target Windows CE 5.0 based devices. >> but the WM05 SDK is currently only for Visual Studio 2005... Any possibilities to use the eVC4 to develop for WM05 best regards Pietro That's correct, you will need eVC3 for PPC2000/2002, but you can throw away eVC4 as long as you don't need it for other CE4.2 non-PPC devices. We thought about attempting to support PPC2000/2002, but the technical and logistical barriers were too high, and would have required us to cut critical features. Cheers! Jeff ...Show All

• Windows Forms keypreview on combo boxes appear not to work

  Hi all, I have noticed recently that on vb.net window forms that the keypreview appears not to work for combo boxes. However, the keypreview event does work on text boxes. I was wondering what is the best workround to this problem and also what other window controls are affected. kind regards Gladys ...Show All

• Visual Basic Generics and Enterprise Development

  I'm trying to think how to implement Generics into an Application, in the past i'd do something like this: (example) MiddleTier:    - User (class)    - UserCollection (class)          - LoadAll   (populates all users)          - LoadAllActive   (populates all active users)          - LoadFromCountry(CountryID as integer) (populates all users from a given country)          'etc... DataTier:   &nbs ...Show All

• SQL Server What is the ADO DataType for nVarchAR(max)

  I can't seem to get nvarchar(max) to work with ADO 2.8 using sql native client. I am creating a stored procedure and every time i attempt to add a parameter to the command object of type nVarChar(max) I receive the error "Parameter object is improperly defined" here is the code to add the parameter cmd.Parameters.Append cmd.createparameter(@piComments,adLongVarWChar,adparaminput,,me.comments) adLongVarWChar is the ado data type i am using to map to the new nVarChar(max) but it does not appear to be working. Is this supported in ADO I am using the sql native client connection to connect to the database as foll ...Show All

• Visual C# Usage of Custom Attributes

  Could Any Body Let me clear where should I use Custom attribute. I Know I can declare some metadat information to a type let say method or class or ineterface and get that information at runtime using reflection.I find it's one use in O/R mapping. But Why should i declare a attribute For example I have to declare a field for O/R mapping of a field in a table tblEmployee.I make a class Employee and in it make a property EmployeeID.In the property I declare a variable Of type String name fieldname and assign it value emloyee_id. Then Couldn't I get the fieldname variable of the property at runtime using reflection. I Also Want' ...Show All

• SQL Server Re-order table after many inserts

  I have a stored proc that is long and performs many separate intserts into my table. Is there a way that I can reorder the records themselves physically in the table after the inserts are done Hello, http://weblogs.sqlteam.com/tarad/archive/2004/07/30/1834.aspx I think this will help you! Happy coding... ...Show All

• Visual Studio Competitive upgrade license

  If we upgrade from a competitive project, are we still entitled to use the competitive product The license is a little vague. Can you explain what a competitive project and competitive product means in this case ...Show All

• Smart Device Development Popup submenu not working correctly (eVC4 project imported to VS2005)

  I have a popup submenu "Preferences" as an item in the "File" menu in the command bar. The command bar also contains a "Function" menu. In the eVC4 built application, when the user taps on the "File" menu, then selects the "Preferences" popup submenu, a new menu appears alongside, with a set of preference items to select. However, in the VS2005 built application, when the user taps the "Preferences" menu item, the menu that appears is not the preference items, but the "Mode" menu. I have no idea what is going on, and would appreciate some help in finding and fixing the cause of this problem. I haven't made any changes to the menus sinc ...Show All

• Visual Studio Team System Team Project creation fails by failing in task SharePointPortal

  Hi, after migrating a "full functional" installation of Team Foundation Beta3 to Team Foundation Beta3 refresh containing two Team Projects we cannot create new team projects. The existing projects seem to work. The log points to a sharepoint problem while creating the team web site. The installation is a single server box. The migration was done as described in http://msdn.microsoft.com/vstudio/teamsystem/b3rmigrate.aspx The sharepoint services were migrated from SP1 to SP2 with WSS2003SP2-KB887624-FullFile-ENU.exe The useraccount failing to create the team project is TFSSetup (meaning it has all the permissions necessary) The TFSSetup ...Show All