AlexBB's Q&A profile

• Visual FoxPro SQL order by - anyway to use string operations?

  Hi all; Is there a way to do something like that The following statement will result in "Order clause is Invalid". SELECT * from SomeTable order by left(somefield,6) Thanks. ...Show All

• Visual Studio Express Editions Installer Help.

  I know this is probably a tough question, but, can anybody give me an example of an installer built from scratch in Visual Basic 2005 Express VB Express provides only the click once way of deploying your application - it doesnt provide any projects to build windows installer applications. For an example of how to publish an application using click once http://www.dnrtv.com/default.aspx showID=8 Its really very simple. ...Show All

• Visual Studio Visual Basic macro not capturing ItemAdded, ItemRemoved or ItemRenamed events

  Hello all, I've written a simple macro that displays a message box each time an event happens. This is working so far for, e.g. OnBuildDone from EnvDTE.BuildEvents. But unfortunately I cannot catch ItemAdded, ItemRemoved or ItemRenamed from EnvDTE.ProjectItemsEvents! This is the content of my EnvironmentEvents-module: Option Strict Off Option Explicit Off Imports System Imports EnvDTE Imports EnvDTE80 Imports System.Diagnostics Public Module EnvironmentEvents #Region "Automatically generated code, do not modify" Private Sub BuildEvents_OnBuildDone(ByVal Scope As EnvDTE.vsBuildScope, ByVal Action As EnvDTE.vsBuildAction) _ Handles BuildEvents.OnBuildDone 'Alert that we finished building! MsgBox(" ...Show All

• Visual Studio Express Editions simple server and client please

  how do i make server and client (but very basic, just to transmit a string...i want to send a string from a textbox in the client to a label in the server (and vice versa-which i suppose i could decipher myself anyway). ...Show All

• Visual Studio Express Editions Combobox of Printers

  Is there a way to have a combobox to show a list of printers installed on the machine Is there a way to print like "I made this up" from VB to a specific printer Davids Learning in the printdialog there is a printername property in the printersettings property: Dim thePrinterDialog as new PrintDialog() Dim theNameOfPrinter as String = thePrinterDialog.PrinterSettings.PrinterName as for saving it into your settings, not sure how to do that... http://msdn2.microsoft.com/en-us/library/saa62613.aspx http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnvs05/html/vbmysettings.asp http://msdn2.microsoft.com/en-us/library/fwc80dzb.aspx to print the text,. ...Show All

• Visual Basic Internationalization. Try setting the Culture .

  Big word, hopefully small problem... I am in the process of internationalizing my application. I have created a string resource file so that I can create all the required language translations but how do I go about changing the shortcut keys on menus etc to correspond to each language Is there an easy way to do this Cheers Mark Hi, See this thread please.>> http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1247101&SiteID=1 Regards, S_DS ...Show All

• Visual Studio Problem Removing Visual Studio Team Suite Trial

  Hi All, I'm having trouble removing Visual studio Team suite trial. I had Visual Studio Team Suite Trial installed on my machine. I decided not to continue the trial and instead install Visual Studio Professional So I installed Visual Studio Professional and tried to run it, but up came the message saying my trial period had expired. Since then I've tried to uninstall/reinstall Visual studio professional, with no change. I then tried to uninstall the team suite trial (its still in add/remove programs list) but it cannot find the setup file to perform the uninstall. I tried to reinstall team suite (so I could the fully uninstall it), but cannot since it thinks there is already a trial version installed on my machine. I tried the msiinv to ...Show All

• .NET Development Who's using .Net?

  I am just starting using VB.Net and loving it. But can anyone point to an example of an application created using .Net It seems as if Microsoft doesn't make many apps with it. I am trying to show coworkers some examples. Thanks, Chris Sql Reporting Services for SQl Server is written in .Net. Sharepoint is .net. Some Microsoft products are written in .Net, but its true they don't advertise it. ...Show All

• Windows Forms datagrid hide row

  I have a datagrid view in a windows form the datagrid is filled with data from a access datatable. eatch row reprecents a order in the program. one of the colums is called (ready) end contains a check box. now i like to hide each order where the check box is true. so that only the Rows(order's ) that are not ready yet are visible and the rows that are ready been hide so that the datagrid only contain open orders how can i do that how do i create a dataview. the dataset i now use is adit to the form and is loaded whit the folowing code Me .Afwijkende_productenTableAdapter.Fill( Me .EK1afkset.Afwijkende_producten) and connected with a binding source to the datagrid. ...Show All

• Visual Studio Major problem with Crystal Reports

  Hi Everyone, I have a major problem with my crystal report function in VB2005. I made a crystal report with the wizard. Everything looked so simple, but I made a new form, put the crystalreportviewer in it. I've choosed my crystal report. but when I open the report when the program is running it doesn't load any data into it. I've looked everywhere on the internet for this problem but I couldn't find any answer. I've downloaded a other source code with a crystal report. There it worked fine. I saw that in that other source I could find a SQL Statement in the field explorer. In my project I can't. I use an access database to store the data, and to recieve the data into the report. Pease help!!! When I press on database fields, the table ...Show All

• Visual Studio Team System Feature request

  When importing database schema from an existing database, it would be nice if the file names were prepended with the schema name (e.g., dbo.<tablename>...sql). I have a database with multiple schemas, and some of the objects in various schemas share their names. As a result, the files/directories in my project become difficult to organize (think about AdventureWorks db - i have a similarly organized db) Another feature that i think is missing, is scripting out custom error messages. If you have particular error messages registered using sp_addmessage, those error messages do not become a part of your project. Diagrams and Intellisense would be high on my list of requests as well, but i know they're not going to happen in this ...Show All

• Visual Basic how to query task manager and task schedular

  Hi Can any body tell me how can i see what tasks are running on my machine under task manager and sheduler task using vb.net or asp.net.. I would appriciate if anybody can provide me code example for it Please reply ASAP Thanks Gurvinder Hi guys, Thanks for your help. I later came up with this Imports System.Diagnostics Dim a, b, c, d As String Dim p As Process For Each p In Process.GetProcessesByName("taskmgr", "100.100.100.100") Console.WriteLine(p) a = p.ToString() b = a c = b + vbCrLf + c a = Nothing Next p If c Is Nothing Then lblRed.Visible = True Else lblGreen.Visible = True End If ...Show All

• Visual Studio Removing margins

  Hi!! I have designed a report with C.Report 9, and I want to show it in a web application developed with ASP.NET; but there's 2 problems: - There's a column that doesn't appear in the report; I fill the report using a dataset, and the column contains data in the dataset, but it doesn’t appear in the report.  It's a varchar(2) data in the data base, and I have defined it as string in the data set. -when the report is shown in a web form a margin appears on the left, and I can't remove it. I have remove the left margin in the section Page setting in Crystal Report, and I've tried to remove the right margin in the web form but the margin doesn't disappear. Help please! and excuse me for my engl ...Show All

• Smart Device Development What is the process of purchasing certificate for device

  I have make an application which extends native tools menu ,add new service and a C# client application. I have tested it using sdk privileged certificate. Now I wants to deploy it. What is the procedure of purchasing the certificate. Which would be best in my scenario Visit http://msdn.microsoft.com/mobility/windowsmobile/partners/mobile2market/default.aspx or http://msdn.microsoft.com/mobility/windowsmobile/partners/mobile2market/smartphoneapps/default.aspx Manav ...Show All

• SQL Server Query much slower on 2005 compared to 2000

  We have a database developed using SQL Server 2000. We are in the process of testing it on SQL Server 2005. So far i've not done much testing but it has become apparant quickly that quite a lot of queries are performing much slower in SQL Server 2005. I am currently trying to figure out why a particular query is not performing well. One SQL Server 2000 it runs in around 6 seconds. On SQL Server 2005 it takes around 50 seconds. The query is this... SELECT StartBase, StartPoint, PickupPoint, PickupInstructions, SingleJourney, Destination FROM vwJobs WHERE StartDateTime BETWEEN '2006-09-01' AND '2006-09-23' vwJobs is a view in our database. The view includes many UDF's and also has a UNION which combines two seperate table structures ...Show All