I use LINQ but I am not an expert.. still learning as well on vb.net and sql
I have tables Orders and Numbers
Orders Table:
Order_ID -primary key
Date_Ordered
[Code].....
In my code I enter a string in a text box and have the query check the server for the entry. If it exists it returns the string and the date into two separate variables. The database only has TrackingNumber and Date. Below is the code. As of right now i get "Invalid attempt to read when no data is present." at the "If (sdr("TrackingNumber") IsNot Nothing) Then" line.
Public Function CreateSqlParameter(ByVal name As String, ByVal dbType As DbType, ByVal direction As ParameterDirection, ByVal value As Object) As SqlParameter
Dim parameter As SqlParameter = New SqlParameter()
[Code]....
how to Disabled Specific Rows in DataGridView using visual basic 2010
View 8 RepliesI am trying to delete rows of an .sdf file using the Database Explorer utility of Visual Basic. When doing so, I get the following error message:No rows were deleted.
A problem occurred attempting to delete row 1.
Error Source: Microsoft.VisualStudio.DataTools. Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(48 rows). Correct the errors and attempt to delete the row again or press ESC to cancel the change(s). It is correct that the data in the rows are not unique (and not supposed to be; there is no "error" to correct), but why should this prevent deleting them?
I am trying to make a project for point of sale and i am having issues with updating inventory table. once cashier make sale items quantity should get subtracted from inventory table. i tried bellow code but it is not updating table, however in message box it does give me new quantity for that item.
[Code]...
I'm an undergraduate student from Singapore University, would like to enquire you on how to convert character codes to ASCII codes using visual basic. regarding the codes on how to build it as I need it for my semestral project
View 3 RepliesI wanted to know how to write a query in data grid control. So far I've seen alot of forums but they are related to either 2008 vb or vb 6. how to write a query in the datagrid control which will search for an id in the database of access and present it.
View 2 RepliesIn a while loop, I am writing a progressively increasing integer value (between 0 and 100) to the Value attribute of a ProgressBar control, when it disappears from the window in which it resides. I have verified at the time that it disappears that the Min is 0, Max is 100, and Value is a valid integer in range.
View 9 RepliesHow do I disable the background compiler for Visual Basic in Visual Studio 2008?
For my sins, I have to work on a large VB.NET project and it often locks up for 20 seconds at a time whilst doing the very helpful background compilation
I'd rather work blind between compiles and be able to do some work.
I am trying to make a console program in Visual Basic on Visual Studio 2008. I want to ask the user of the program if he wants the premium version or the standard version. If he chooses the premium version, then I want it to say premium in his "receipt" later on and if he chooses standard, then standard in the receipt.
[code]...
I have Visual Studio 2008 Professional and I'm trying to make it so I can click a button to send the application to the System Tray and then click the icon in the System Tray to make the application come back.
Can anyone provide me a method or sample code to do this?
I am very new to Visual Studio Application Development. I'm mostly a DB guy. I used Visual Studio as a Report Designer, not much of an .Net guy though I can understand it. I am now asked to create a .net application and I'm trying to create a "Hello World" starter app. I opened my Visual Studio, click File-New Project and all I see is Business Intelligence Projects and Other Project Types. My step-by-step guide says choose Visual Basic, Windows Forms Application. But I can't see it as an option.
View 2 RepliesI recently loaded my copy of MS Visual Studio 2008 Standard Edition, with Visual Basic, on to my new laptop, one with a Windows 7 operating system. This version of Visual Studio had been on my other laptop, a Windows Vista machine. When I attempt to run any of my Visual Basic applications which has a MSFlexGrid container on it, I get this error message "Unhandled exception has occurred in your application... The error is: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG). Also,
View 2 Replieswhilst trying to debug a sample program, get error code bc 32400. Also error code Class 'CLSID_CorSymWriter' could not be created system error &H80040154&
View 3 RepliesI have been working on a game development program for a few days now. And have come to a halt on one part, and thats adding a 3D space in the program. I do not know the code for this, would some one please provide something i could use for adding 3D space in my project? for example, i have a panel set up to be the view port in to the 3D space. Now i need to figure out how to program it so you can see a 3D space, click on the mouse and drag and the grid will follow the mouse.Likecreate a grid, i wish to give it a grid of 150 x 150 grid pixles.
View 2 RepliesIn this application I need to allow users to enter a month as integer (1-12) then use integer tryparse to validate that input, that seems to be the easy part. I need two create two functions, one that returns the name of the month and the other returns the number of days in that month. The arrays are supposed to be defined and initialized within the function so that the main program can take the user input and call the two functions, then return the appropriate values as output to labels. I am not sure how to declare the arrays in their appropriate functions and then how to call those functions to retrieve the right value from the function.
View 1 RepliesHow do you extract source code from a VB.NET .EXE file?
View 3 RepliesHere is the code:
Function getData(ByVal id As String)
Dim reader As SqlClient.SqlDataReader
Dim statement As String
[code].....
There were three similar questions in StackOverFlow but none gave an answer.. If have found why this error in occurring but don't know the fix. I am using Strongly Typed Dataset for my project which is created as a dll for DAL. I have added the Sql Server Table into this dataset using the designer and has created a DataAdapter
[Code]...
I want to create a Windows Forms Application in Visual Basic 2008. I have created my form already, now I just need to add Caller ID capability. how to do this? Will I need any extra components? If so, where can I get them?
View 10 RepliesThe code below is from Visual Basic 6.0. I need it converted into Visual Basic 2008 .net
I know VB.Net 2008 has the option to convert the code but im still having trouble with this:
[Code]...
I got one listview, and several items, and several picture box. And i want to make a relationship between picture box and listview.Like select the third item, and the picture box 3 show, select the second item and the picture box 2 show. All this in the same form.
View 5 RepliesI would like to use MSChart to display a line chart (X-Y plot with 2 array) on visual basic 2008. I am wondering if someone here can share working examples of using MSChart on VB 2008. In my program, I would like to read in 2 pressure array, each as function of time. Then, plot the pressures using MSChart.
View 4 RepliesI would like to see some example of using the reference VismLIB in Visual Basic 2008.I use in VB6 but am wanting to migrate my applications to VB.NET.
View 3 Repliesthe problem is that I want to (SQL) select from a table in an Oracle database, and show the results of the query in the VB application, in a Excel like manner (rows, columns, selectable, etc.). Or in a SQL developer manner. Haw can I do that? Browsed through a lot of tutorials and howtos on the internet, did not get anywhere.
View 2 RepliesI was wondering if I could somehow binary coding, if not all coding of a file.In Visual Basic 2008, I use this method:I click a button on a form, I browse the file, I select itand then I click open and it fills a RichTextBox with 1 and 0's in binary form.. You know, drag a .exe file into notepad and you get random jiberish and inunderstandable characters.Well, this method does just that, BUT! It's waaaay to slow
Dim input As New System.IO.FileStream("File to get binary from.exe", IO.FileMode.Open) 'Create a new File Stream
Dim bytes() As Byte
[code].....
have a form that has a detail layout of my database which contain username and name and surname and etc. How do i create a button that when i have selected a row it should give me a report for that selected row an not for the whole database
View 5 RepliesI have created a hotel booking system programme. However, I am puzzled as to how when the booking button is clicked it can search a database and find the best suited room (RoomType) and make sure that it is available (Date of Departure < system.date). It must also assign the value of the cost that is placed in the combobox as the room.roomprice value.
[Code]...
here is the API written in C++:
c++
#define BMSAPI_WINDOWCAPTION "BMS Business Music System"
#define WM_BMSAPI_COMMAND 0x7fff
int BMSAPISendCommand(int iBMSCommand, LPARAM ExtraData)
[Code]....
I need it converted to Visual Basic .NET. I ran it through a converter but it wasn't very succesfull.
How to change the frame rate in Visual Basic 2008 Media Player? I have error: System.NullReferenceException was unhandled Message: Object reference not set to an instance of an object. IS there any way to fix this? Here's My Code
[Code]...