i'm getting an error with the code below
The Error.... SQL Syntax Errors Encountered
Error in Select clause: expression near 'DESC'.
Missing from clause
[code].....
I have a Visual Basic project and when working and modifying code, the compiler will crash and then a message will say something like "Microsoft visual studio encountered a problem and was shut down." I've tried editing code from the solution and the project. Both produce the error. Usually occurs when adding an "IF...Then..." condition. May work for hours but then crash. Solution will compile and build.
View 3 RepliesI was woking on a windows app today when my errors were no longer being displayed as they usually would, instead the debugger just jumps out of the method. It works in other projects, I have put this: 'Dim i as Integer = "A"' in as my first line to try and raise an error but it just exits the sub on that line.
The output window makes a note of the exception but the usual popup trace does not appear, any ideas how I get it back??
OpenFileDialog.ShowDialog()
Connection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source = " & OpenFileDialog.FileName
[code].....
I recently installed WSP Builder on a machine with Visual Studio 2008 already installed.Quite expectedly, the WSP Builder sub-menu appeared (and still appears) under the Visual Studio 2008 Tools menu.Having then installed Visual Studio 2010 Professional and installed WSP Builder a second time, I can not seem to find the WSP Builder sub-menu anywhere under any of the Visual Studio 2010 menus.Can anyone throw some light on this "missing menu" problem?
View 2 RepliesMy code is supposed to select the month fand see what product ahas been sold and how much has been sold. It does it but i keep getting a Incorrect syntax near '='. and i cannot fix
CODE:
I have a database in access and one of the fields is 'Is Quick'. I have a query that filters all of these out. How would I get the data from that query in Visual Studio 2010 (Express). VB code please.
View 1 RepliesIs it possible to import a query from Access 2003 into Visual studio 2010 (language used vb.net).
I created the queries originally for a project, then when I imported the database to visual studio I can only use the tables that i created. I have started looking at the coding to re-do these, but if I can import them would it be quicker?
I am working in a project where i have to add employees in a company. I have a form with text fields(for example name,surname,age,...). What i want is to insert this txt values into a database. My project is connected with an sql database. How can i add the values into a data table on button click("submit")?
View 9 RepliesI'm looking for a control that allows images to be placed onto it and moved about. Moreover, I need to draw lines between the images. It will sort of be like the query designer in SQL Man Studio. It will be used as a virtual desktop where a variety of objects (and their icon representations) can be freely placed and moved. I'm having a blank and cant remember where I saw this before.
View 2 RepliesI am new to VB and trying my hand at the below code. I am trying to determine the number of records for each possible combination. Depending on the outcome of the number of records groups may be combined. I am not able to find the record count for each grouping. Can you please look at the code below and suggest what I am doing wrong?
[Code]...
I am using Visual C# 2010 Express and Visual Basic 2010 Express on my Windows 8 developer preview PC.Before, there was no problem, both VB and C# work fine.But today, both VB and C# can't handle errors. I have created a simple application with VB and C#. (.Net framework 4.0) the codes are here:[code]But visual studio shows the dialog shown in first image instead of this dialog. So, I can't debug my program.If I enable break exception when thrown in Exceptions dialog, the problem solves, but at that point, visual studio breaks on EVERY exception , even handled exceptions... I don't want to break on every exception...
View 2 RepliesI have a weird problem that seems to of started happening yesterday afternoon. Basically, VS seems to of decided to act as if I had set like a "On Error Resume Next" style rule where instead of telling me about exceptions it just ignores them completely.For example, I just created a fresh new project and stuck this in the form_load event:
vb.net
My.Computer.FileSystem.ReadAllText("rubbish")
So that should error and tell me that it could not find the file, but instead the form just loads and ignores that code.Obviously this isn't right..
I have a large solution which contains a mixture of C# and VB.Net projects.If I get compilation errors because a project which several other projects depend upon fails to build, it is very hard to see the actual error(s) because of the number of VB errors in the error list window in Visual Studio. C# errors found in the projects I compiled show in the error list, but all VB errors appear (including in those projects I have not just compiled).Is there any way of turning off this behaviour so that VB errors only appear for projects that I have explicitly compiled?
View 1 RepliesI'm currently using VS2008 and VB.NET.When I attempt to populate a Queue that has not been instantiated with objects, the program simply hangs without throwing an error.I have run into this issue multiple times in different parts of the program in the past few days.What could be the cause of this?
Here's the code:
Structure ConsoleBufferLine
Public EntryDate As Date
[code].....
I'm develloping a small application over na Access 2007 database. how can i pass the value of a combobox to a query being built with the query builder tool?If I use ? in the Filter column I�m prompted to enter the value but what I need is to pass the value of a combobox in a form. I tried to use:
HTML
=MyForm.MycomboBox.Value
but it is ignored, interpreted as the value to be filtered.
I'm developing a source-editor. I'm going into the 1.3.1 version and it's about time to get a syntax highlighter.
I want a free, easy to use, and simple syntax highlighter and it needs to be a component.Leave a comment if you need more information and I will update.
I am trying to read through some code and it would be helpful if the editor in VS 2008 would highlight the If statement by using the cursor and double clicking the End If statement (or something like that).
I believe I could do something like this in Java using Eclipse - it was very good at highlighting a code block by clicking next to one of the curly braces.
Will i be able to successfully install 2010 beta 2 side by side 2008? because i want to test 2010 features and some development toolkits such as silverlight while i don't want to uninstall my visual studio 2008 professional.
View 2 RepliesI have limited experience with Visual Studio and have a question about Querying an Access database. I have created a Visual Studio application that displays and modifies an access database. I have use datagridview and detailed view to insert data and view data in the Access database. I am now trying to figure out the best way to query the data in the database. I have tried right clicking a table in the database explorer and creating a new query. Everything works and I can view the data but I am unsure how to display this query result in datagridview. So my question is how do I view this result in datagrid view?
View 9 RepliesI receive this error: [code]whenever I run a query via a visual studio project in vb.net. If I run the same query via Open Office Base, it takes a long time but it works. How do I go about troubleshooting whats causing this?
View 2 RepliesI'm trying to write a Vistual Studio 2008 macro to run a stored TFS query and display the results.Previously I've created a query and named it 'Assigned to Me' to display all the work items currently assigned to me.Instead of View->Team Explorer, click, click down the tree to My Queries then double click 'Assigned to me' I want to write a macro to automate these steps.
Sub TemporaryMacro()
DTE.Windows.Item("{131369F2-062D-44A2-8671-91FF31EFB4F4}").Activate() 'Team Explorer
DTE.ActiveWindow.Object.GetItem("tfsserverMyProjectWork ItemsMy QueriesAssigned to Me").Select(vsUISelectionType.vsUISelectionTypeSelect)
[code]....
I am trying to "make table" query. Below is my texT
[Code]...
I want to query an access database with variable data defined by the user. The "Search" criteria would be in a textbox. I made a query like
SELECT askID, Question
FROM chita
WHERE (askID LIKE 'Textbox10.text%')
and referring to this query as
Form1.ChitaTableAdapter.searchrec(Form1.ChitaDataSet1.chita)But id does not take the value of the textbox, instead it takes the Textbox10.text as a value. Is it possible to refer to it like this, or should I Linq?
[Code]...
Does anybody know which version of Visual Studio 2010 contains the full set of Visual Basic SharePoint Templates? I am about to embark on a project to create Visual Web Parts to be used in a SharePoint report.
At the moment I am using Visual Studio 2008 and even though the WSPBuilder is installed none of the relevant SharePoint templates are present.Having searched SO and the web, most advise to install the templates via the Visual Studio command prompt: devenv /installvstemplates
Alas the Visual Studio command prompt is also missing from my VS2008 installation.So, the question remains: which version of VS2010 contains what I need for pain-free SharePoint development? There is a rather large price different between VS2010 Professional and VS2010 Premium, so can anyone tell me if the cheaper version (VS2010 Professional) contains all the Sharepoint templates?
I am just wondering how I can add Direct X references to Visual Basic in Visual Studio 2010 Beta 2. I cant find them in the .NET reference list, or the reference list, or anywhere. I downloaded the Direct X SDK for August 2009, but I can not add the .dll files to the reference list. Is there anything I can do to add them? I need the references for programming reasons.
View 5 RepliesHOW TO update and query and erase in database on visual studio using officce access
View 3 RepliesI want to use "OpenGL" in my project. Is it possible to associate it with "Visual Basic" application developed in Visual Studio 2010? If yes then how can we do it.
View 1 RepliesI have a project in visual basic 2010 and want to convert it to visual studio 2010 so I don't have to chose the "open with" every time. Is there a tutorial on how to do this?
View 4 RepliesTypes have their own color (cyan by default).Enter completes the auto-complete suggestion.
View 1 Replies