Appel's Q&A profile

• Visual Studio Express Editions Problem with SQL query

  Hi I'm trying to write a query ---------------------------------------------- SELECT field1, field2, field3 FROM table WHERE field1=form.textfield ----------------------------------------------- Where form.textfield is a link to textbox in form. It doesnt understand this link. In previous versions (VB6) it works. Is there any changes in syntax in new VS Do not concatenate user input to a sql statement! Use parameterized query instead. This will avoid sql injection attacks. Something like this if you use the sql client. Dim strQuery As String = "SELECT field1, field2, fiel ...Show All

• Windows Forms DateTimePicker in MainMenu?

  Is there any way to insert a DateTimePicker as a submenu of a MenuItem E.G.  In the MenuItem called "View", under a section with options of "Today", "Yesterday", and "Select Date", if the user puts their mouse over "Select Date", a submenu appears with a DateTimePicker in it. Is that possible   If so, how ...Show All

• Visual Studio Team System tfsbuild.exe.config AllowedTeamServer

  Hi, I'm having trouble executing a build from the command line or through TE on my build machine- which is also the TFS. I get the same error when I try each way TF42053: The build machine is not configured to build for server http://<servername>:8080/ . ... To change the team foundation server for the build machine update the AllowedTeamServer key in the config file for TFSbuildService.exe ... I don't see a config file for TFSBuildService anywhere but, I have tried to add this key to the Tfsbuild.exe.config file- the key did not exist when I looked at the file the first time. I did restart the build service after I added ...Show All

• Visual Basic Visual Basic and graphics - for the novice/beginner

  Hi there I have no training in programming, but would like to start writing my own little programmes. In my work (civil engineer), I am increasingly frustrated by the lack of simple, time saving programmes to make my life easier, and hence the urge to write my own programmes. Of course, the start will be no more than programmes for one-off formulas, but having said that, I would like to (in many year's time) be able to write more complicated programmes. And of course what I have in mind involves graphics, specifically being able to draw (for instance) pipelines (with coordinates) and then be able to generate a longitudinal section from th ...Show All

• SQL Server Access 2003 and SQL Express

  Is there a way to integrate Access 2003 as the Front End for SQL Express I tried, but I can't make a new Access project because I need to specify a login/pass and I have no idea what those are set to, or if I need to make an account somehow. As you can see, I am totally new to SQL and any help would be appreciated. Thank You, James Run the following from DOS: %SystemRoot%\system32\odbcad32.exe This creates ODBC connections. Administrative tools gives you access features of the OS to meddle with, important if you are a programmer. I would suggest you get familiar with them, although I believe you need to be an administ ...Show All

• Visual Studio Tools for Office access [contextual||context||right-click] [menu||commandbar] of chart?

  Hi, I would like to add an item to the chart contextual menu, but I don't know where to find it! The cell/worksheet contextual menu is accessible via ((Excel.Application) xl).CommandBars["Cell"] whilst ((Excel.Application) xl).CommandBars["Chart"] points, not to the contextual menu, but to the floating toolbar menu. "Chart Menu Bar" is, of course, the top level menu bar (File,Edit...), and so I appear to have run out of items in the CommandBars collection that contain the word "Chart". Not sure where to look now - getting frustrated enough to question "is this even possible " . Thanks for ...Show All

• .NET Development How to manage multiple database at remote locations?

  HI All, How to manage multiple databases at remote locations for single web application which is made in Asp.Net 2.0 one way is Make one database as master database and put all other database information into that master database. Is ther any other way for that Thanking you David Hi, Thanx this one is realy helpfull to me. One more question regarding it. Suppose i had two differnt table In one table let say 2 fileds (PersonId, Address) and in other table let say 2 fields (PersondId, Name) I get data of both the table in one dataset in two different table. Suppose i want to merge that both datatable c ...Show All

• Visual Studio Team System pass test with 401.1 error

  I want to write a web test for a user that is not authorized to access a page...the test should pass if the user is denied access with "HTTP Error 404.1 - Unauthorized". This was easy enough to do with NUnitASP (just set an expected exception), but I can't figure out how to do it in VS 2005. Any suggestions Thanks, Chuck   Chuck, Unfortunately failure testing is not possible with the current release.  It is at or at least very near the top of our priority list for the future, though.   Josh ...Show All

• Smart Device Development Windows Mobile 5 and Java

  I don't even know if this is the right area or not, but I have a problem and maybe someone here can help. I have a PPC 6700 from Sprint. I am trying to install a Java program onto it. The file type is a .jad. I have tried installing every single java program that I can find on my desktop pc and pocket pc. I can't do it. I know absolutely nothing about programming. Don't understand any coding (uuecode-What's that ) Completely lost. I have installed IBM J9. No help. Can't even get that to work. Even tried other similar programs, and nothing worked. Does anyone have any ideas Java is not supported on PPC. You've to install PPC compatib ...Show All

• SQL Server DataReader Source and ODBC connection to PostgresSQL

  Hi, I am trying to use the DataReader Source to import a table from a PostgresSQL database into a new table in SQL 2005 database. It works for all tables except one, which has over 80,000 records with long text columns. When I limit the import to fraction of records (3,000 to 4,000 records) it works fine but when I try to get all it generates the following errors: Source: DataReader using ADO.NET and ODBC driver to access PostgresSQL table Destination: OLE DB Destination - new table in SQL 2005 (BTW - successful import with DTS packagein SQL 2000) ---Errors Error: 0x80070050 at Import File, DTS.Pipeline: The file exists. Err ...Show All

• Visual Basic User and Application Settings

  Hi there, two quick questions for anyone who knows. where do the user and application settings get stored by default and can you change it without needing to handle the settings (load/save) events thanks very much I think you'll find that the settings get stored in the application.config file which is an XML file which resides in the application directory. WindowsApplication30.exe.config for WindowsApplication30.exe You'll see something like the following in you file <userSettings> <WindowsApplication30.My.MySettings> <setting name="barsetting" serializeAs="String"> ...Show All

• Visual Studio Express Editions Help needed with KeyDown

  Hi all, I am new to VB2005 and am having trouble identifing a keypress.  In VB6 I would just use the textboxname. keydown event which would return a key code identifying the key.  But it doesn't seem to work in VB2005.  Any ideas please Hi, It still works on VB2005. Though getting the inputted key is quite different:    Private Sub TextBox1_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress         If e.KeyChar >= "0" And e.KeyChar <= "9" Then      &n ...Show All

• Windows Forms to cgraus

  Hi, I'm trying to write a splash screen for my application and I'm using the sample splash screen code provided by MSDN with the link http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnnetcomp/html/casoast.asp but the splash screen form runs maximized which makes it cover the whole screen. I disabled that and also added this.ClientSize = bmpSplashSize; also made it centered on the screen by this.StartPosition = FormStartPosition.CenterScreen; at the end of it's constructor. Now when I run the application splash screen runs centered on the screen and with the same size of splash image. The problem is that there ...Show All

• Visual Studio i want to know if there is a way to disable copy in internet explorer

  i need to find a way of disallwing users to copy anything from internet explorer i have a small amount of coding knowledge but would like simple steps to know how to if possible create a application/process that disallows the user of a pc to use the copy feature or simply remove that feature from the internet explorer application thank you in advance P.S i didnt know where i should put this question [which forum] so im sorry if i messed up P.S.S if you could help me i would like you to e-mail me at this email address thank you in advance again You might try the IE forums for this question, most of the moderators on this newsgroup a ...Show All

• Visual Basic Blair Allen Stark

  Here is the problem I am working on. It asks me to use the method CalculateCharges, but I don't fully understand how to do this or how it works. I would be grateful for any input. Lab Problem III A parking garage charges a $2.00 minimum fee to park for up to three hours. The garage charges an additional $0.50 per hour for each hour or part thereof in excess of three hours. The maximum charge for any given 24-hour period is $10.00. Assume that no car parks for longer than 24 hours at a time. Develop a console program that calculate and displays the charges for each customer who parked a car in this garage yesterday. ...Show All