I encountered something like a logical error which I could hardly resolve since I'm new to this technology. I'm using visual basic 2008 express edition with its built-in linq-to-sql technology. I was able to retrieve, add, edit, and delete such record using the linq-to-sql method, but one thing.I could not get is something like relational database operation. Here is my problem. As you can see the table above which represents the records on my database. You can notice there some account numbers that were duplicated which I used as the primary key or identifier. What I want is when I'd like to query such account number it should display all the records that have the same account numbers on it. Say for example, if I query the account number 00003. It should only pull up and display three records with the name Maverick and their corresponding address, movie rented and date.What is happening in my end is when I query such account number which are being duplicated in the database I encountered two things, its either it would display all the records in the database with different account numbers associated or it gives me an error message if I change my code from 'For Each memrec In db.Table3s' to 'For Each memrec In retrn' statement.What I've been trying to do here is if you enter the account number on the search box, it should only display the records on the combo box associated with the account number being entered. Like if you enter 00003 on the search box, it should only display the three movies rented by Maverick no more no less on the combo box. [code]
I have already tried that set of codes before but it's working the same thing. I tried many times modifying my codes before I posted my comment in this forum thinking that i can resolve it on my own but I wasn't able to. That code won't still filter the records in the database. I would like to verify that the table above is only representation but the real column on the table on my database is 'Account#' not Account Number and visual basic would detect the code as 'Account_'. May i know why Movies_Rented column on my table is not a member of string? Why is it the code you gave would still display all the records on the combo box? this is what im not getting. hope you can still find the solution to this issue.
I'm using visual basic 2008 express edition and I'm not sure how to attach my query in order for it to run? I've been using trying to use visual basic to create a form which retrieves data from a Microsoft access database and filters the data to find the record starting with the letter retrieved from the user. When it is run without the query the data grid shows all the records. However when my original query is put in the application changes it and the value shown is null in all fields.
I'm just using the default SQL Server Express in my vb 2008 express edition as my database server for my database operation. When I tried to update the records on my table I got a runtime error which indicates the error on this line 'myCommand.ExecuteNonQuery()'and it highlights a yellow background on it. The runtime error says "SqlException was unhandled: An expression of non-boolean type specified in a context where a condition is expected, near 'Number'. ".
Imports System.Data.SqlClient Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim myConnection As New SqlConnection Dim myCommand As New SqlCommand
My company currently has vb.net 2003. I am tasked with evaluating vb.net 2008. And suggest if upgrading to 2008 edition is necessary or if it will be beneficial. For this purpose I decided to experiment with vb.net 2008 express. I have some questions regarding this.
1) Will vb.net 2008 express edition will give me idea about new features etc. ?
2) If I install vb.net 2008 express edition on machine which has vb.net 2003, will it cause any problems to vb.net 2003 ?
3) If I code in vb.net 2008 express edition, on upgrading will this same code work ?
I would like to have one combo box associated with another combo box. When the first one is selected the price is displayed in the next one. The information is got from a txt file and the item name loads in the first combo box and the price loads in the other combo box. What I want it to do is to show the correct price when the first box is selected for the item Here is a copy of my code at the moment. [code]
i'm not able to open the project and run the source code of the bellow link to treelisi'm trying to open with vb 2008 express edition and visual studio 2008, and several error are displayed.
I use vb 2008 express edetion but i find error in it and no answer yet .when i choose the choice : Dont save any changes from the tools menu and then project and solution then run and debug then choose that choice then when create a new project by a new form1.vb with a new buttum then presss F5 or run the msg error appeare is : Form1.vb cannt be modified at this time ?
i am newto visual basic. i am want to import vc++ dll in visual basic. need to pass a function pointer as parameter to the one of the methods in vc+ can we import vc++ dll in vb2008?if no, could you suggest me the alternative for it?
ive been trying to make an app in VB 2008 Express Edition so that every time my timer ticks it randomly adds a number like it either adds 1 or nothing but having trouble with it since it just does it one time this is my coding for the timer
Private Sub Timer1_Tick(ByVal sender As Object, ByVal e As System.EventArgs) Handles Timer1.Tick TextBox1.Text = Int(Rnd() * 1) Select Case TextBox1.Text Case 0
I like to have assistance with the VB 6 codes below; a few cheeky lines dock into positions I do not mean them to be in; sorry; I am on VB 2008 Express; a few lines have errors; adjacent to them I have described what VB 2008 reports.
The radio recently broke in our bedroom and as a result my missus now listen to various radio stations through her laptop. She moans that visiting various pages and clicking the 'listen' link is a bit of a pain.(Note to self: Must buy new radio!)In the meantime, I have made a 'radio player' in VB 2008 Express, which is nothing more than 6 buttons down the left hand side of the 'player' I have created and a Web Browser Control on the right hand side.Clicking each button links to the relevant player of the station she wants to listen to. (Being a newbie to VB and programming, I'm quite proud with what I've achieved so far!!)Anyway, one station I do link to gives an "Are you sure you want to navigate away from this page" prompt: [URL]Is there a way to suppress this message in VB, or even auto-answer OK somehow?
The other sites I have linked to do not display this message, they just navigate away quite happily. Clicking OK on the prompt is no real hardship either, I hear you say, but in the interests of usability, I would just like it to navigate away from the site/player without prompting.Remember, I'm using Microsoft Visual Basic 2008 Express Edition.
I am a competent (but not much more) VB6.0 programmer. I'm still developing software in VB6 and want to upgrade to VB.NET. I primarily write simple software to control proprietary hardware which is called by Active X. I need to figure out how to do this in VB.NET before I can switch over to the new version.In VB6, I connect to the VB6 by adding references to the DLLs (under project / references). When I load the main form, I declare:
Private Sub Form_Load() Set o = New CBEDCSApp End Sub
Im using VB 2008 Express Edition for my project. This is my problem. I have multiple forms in my application and when i run it, the debugger doesnt show any error.But when i change the start up form I dont see the form which i expected to run first.
Iv'e been away from Visual Basic for the past 3 or 4 years so I am a bit vague on the details that I am looking for.
I got myself my first programming job at the company that I work for and I start Monday.
The company has little programming knowledge (well I assumed this as they said they do not have a dedicated programming IDE at my interview) and relies on ad-hoc VBA scripts to perform necessary processing on data. This is all fine and I can deal with that but there is a project that I wish to work on and I think a standalone dedicated application would be much better than extending Excel with VBA.
Now after being with the company for 10+ years, I know they are conservative at spending money so asking them to buy Visual Studio is not really an option so I'm going to suggest that instead of using VBA, I will design an application using Visual Basic Express.
All I need to know is, if there are any kind of limitation to database accessing with the express editions? (Iv'e only ever used OLEDB connected to small MS Access files) I do not know what type of database the company uses yet, but I do know they use ODBC to connect to it, and rely on Sage to do 90% of their work.
I was trying to use WebRequest request = WebRequest.Create[URL]..But get an error message! I am trying to use the WebRequest .NET framework class [URL]..How can I enable .NET? Is something wrong with my installation?
Working on a class project where one heading in a lisbox has to be indented while the subsequent information has to be right-justified. Not sure how this is done.Have tried writing code like:
'To list cost of parts in listbox ''Formatted so value is in U.S. currency lstTotal.Items.Add("Parts" & ControlChars.Tab & ControlChars.Tab & ControlChars.Tab & parts.ToString("C"))
But using ControlChars.Tab over and over again doesn't seem very efficient. The spacing in the listbox looks uneven and the code looks more cumbersome--less easy to read.
I'm creating an application and I want to pass on a string value from one form to the other.Is there an access modifier in VB 2008 EE that would allow me to do that?Example: I have a name such as Mike in one form, in a list box, and Mike has a file attached to it with different information.I then click on a button to load another form, where the name Mike will be passed on and will be used by my program to find the file and display all the information in the file of his name.
I want to add a reference to a libary in Microsoft SDK (SnmpAPI.lib) Visual Basic 2008 Express Edition but is says "C:\Program File\blah\SnmpAPI.Lib" cannot be added.
Is there a manual or can someone provide a description on how to use the Microsoft Visual Basic/C++ 2008 Express Edition to create a .ocx or activex file? I have an application where I need to create and OCX to embed in a 3rd party software program. I have the application developed but I need a .ocx file to register the application for the project. I did this a while back in V6 but the newer version seems to be different
I have newly installed VB 20008 Express. What extras do I need to have to allow me to create standalone exes? This for giving to fellow model railway club members and not for commercial use.
I've got a problem. I need to convert a decimal to a fraction by a BUTTON. I've tried several times through everything I found on the internet. Until Dll's I've tried using
i have a project and i used NSIS to create a Setup file. I am able to install it to my system but some parts of the program do not work (and they work when i run my project in VB). For example i have a Back Up option that creates a back up but this does not work when i run the application via the installation file. Probably it has something to do with the directories?
If System.IO.Directory.Exists(CurDirectory + "Backup Folder") = False Then System.IO.Directory.CreateDirectory(CurDirectory + "Backup Folder") End If
how can i make it work from the installation file? Do i need to copy something somewhere?
I have built a web browser using Visual Basic 2008 Express Edition, but I don't know how to open the .exe file back in Visual Basic so that I can improve it and fix some problems that are in it. Can someone tell me how I can edit the project in Visual Basic 2008 Express Edition?
I want to connect visual basic 2008 or 2005 to sql server using connection string or something elsejust like in VB6 I'm using a connection string but here at VB express i dont know =(Is there a way just like in asp.net to have connection string using?
i am using visual studio 2008 express edition. when i want create a database using database explorer then it shows that a network related or instance speicified error occur.i am using visual c# language
