I am doing a project as part of an external exam, previously i had been using just a variable to store my data. But i kept getting a bad record length error so i switched to a dynamic array but now my project is not looping properly. When i click submit the manually input data by the user is supposed to add to a Dat file and also add to a list box but when i click submit the new information over writes all the previous information that has been input. Here is my
I'm getting an error message when I try and save record data to a file.The error message I recieve says 'Bad Record Length', and highlights the following code - FilePut(filenum, customer)
1. Can someone please explain to me what the error message means?
I have a control thread that starts up a secondary thread and when the secondary thread finishes, the control thread restarts the secondary thread. On this secondary thread, I use a stopwatch to record a thread.sleep event. Is there any reason, under any circumstance, why the stopwatch elapsed millisecond value (499) would be 1ms less than the sleep time (500 ms)This doesn't happen all the time or even a lot, I'm just curious if there is any physical reason for this to happen.
how I can implement my calendar with VB .net express 2008 and MSSQL 2008 Express. How do I get it to work with datasets, binding source etc.If I go to Properties>settings my connection string is:
Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CalendarDatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True
and I have a table with fields:-
CalendarID Subject Location Purpose
[code]....
I can Add the event to the calendar I have the necessary items on my form linked to my table and I can save them to my table:
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
I tried to start using VB 2010 Express with a program I originally developed with VB 2005 Express that I moved to VB 2008 Express successfully a couple years ago. It uses a database file (*.mdf) that is on the computer ( not out on a server). When attempt to run the program in debug mode, I get the following error "An attempt to attach an auto-named database for file C:Documents and SettingsTomMy DocumentsQuizzing StuffQuestion Database 2010QuizQuest ionGameQuizQuestionGameinReleaseQuizQuestionDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share."
I first made a copy of the entire project folder that was working in VB 2008 Express and gave it a different name. In VB2010 I opened the project in the copied folder and it said it successfully converted the project. I am able to open the Data Source inthe Designer and see the database structure as I expect. I think the project is still using SQL Server 2005 Express (because it is what is checked in the list of prerequisites on the Publish tab).
Note, I have programmed off and on for many years, but fairly new to using databases and SQL Server.
Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
I am trying to re write a VB6 program using MS Access, many years ago, using VB 2010 express and SQL server 2008 R2 Express. I have a database with several tables, which I created using the designer. I am able to connect to the database and select data and display it in textboxes etc in vb code. What I have not been able to in code is to INSERT rows DELETE rows or UPDATE any data in the tables. I can do any of these operations using the Query Designer, but I want to do it in code. I can post some code if necessiary, but I thought it might just be some property that I had not set in the designer.
This code i had use for create a field in DB Access 2003:
SQL = "ALTER TABLE plano_contas ADD declperiodica06A char(40) WITH COMPRESSION NULL)" Dim command1 As New OleDb.OleDbCommand(SQL, con1) con1.Open() command1.ExecuteNonQuery() con1.Close()
like you see the code create a Text field with 40 lenght...Well the problem is:When i save a new record the record it's save in this mode: "100......... .........................." - the points means spaces and should be:"100"After try a lot of things i'm without more solutions in find why this happen!
End WhileI am trying to read from the ": " to the end of the line. I keep getting this error: Index and length must refer to a location within the string. Parameter name: length
there Dream in Code Community! Im an okay programmer as far as skill right now I am still learning as we all are I need some help from some experienced VB.NET programmers in the community, Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords.
The program I am trying to modify was initially written using VB 2005 Express. I have subsequently downloaded the 2008 version. The program creates a monthly spreadsheet from a template. The old code that will no longer (highlighted and underlined) compile is as follows:
I'm using VB 2008 Express for our College Project. I'm also running SQL Server 2008 Express and have installed SQL Server Management Studio and used it to create my database. Both software have been installed and running locally. I'm trying to connect to the database from VB 2008 Express. Database connection wizard have 3 options:
connecting to Access db connecting to SQL Server 3.5 compact db and connecting to SQL Server db file.
I have SQL 2008 Express and Visual Basic 2008 Express runing on XP Professional SP2. When I select add new data source from VB I don't have the option to connect to SQL Server 2008 express to get at the to SQL Server Database. I also notice that the OLE DB connector is not availble as a data connector. Can somebody please confirm that VB 2008 Express can connect directly to SQL Server 2008 Express and how I can achieve it.
'm trying to use Visual Basic 2008 Express and connect to a DB of SQL Server 2008 Express but ... you can tell me why in the Database Explorer and the Data menu of VB only have the following options for data source? Microsoft Access Database File Microsoft SQL Server Compact 3.5 Microsoft SQL Server Database File does not have the options Microsoft ODBC Data Source Microsoft SQL Server obs.: I have the Visual Web Express 2008 installed, and there are the options available.
I have a field displaying on a datagrid that the user has asked to be variable length based on the data that is returned. Is there an easy way to determine how many characters are returned for a field and then converting that to a pixel length so that I can change the length of the field in the code.
I hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data() dim dt as new data.dataTable dim service as ws webservice.webservice
If using the following in an if statement I get an error: If trg.Name.Substring(4, 6).ToUpper <> ("ABCDEF") Then I get the error: "Index and length must refer to a location within the string. Parameter name: length"
I assume this is because the string (trg.name) is too small for the 4, 6 substring. What would be the correct method of working around this problem? VB.net Studio 2008.
Me and my coworker were discussing variable names today because we both have completely different naming conventions...but we were wondering is the a limit on the length of the variable name??? is it posible to do this: dim
ItsPeanutButterJellyTimePeanutButterJellyTimePeanutButterJellyPeanutButterJellyPeanutButterJellyWithABaseBallBatPeanutButterJellyPeanutButterJellyPeanutButterJellyWithABaseBallBat as string = "lol"
I am trying to check a record in database before inerting a new record here is my code but problem is when i enter a names first alphabet it imediatly populate massage. i want to check it after entering whole name
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress Try Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
Seen this in Dim file as FileStream = New FileStream("myfile.text", 0, FileMode.Open, FileAccess.Read) Dim reader as BinaryReader = New BinaryReader(file) Dim data as Byte() = reader.ReadBytes(CType(file.length, Integer)) Why is the file.length being converted to Byte, when Integer range is greater, and the code not failing to do so? I don't understand.
I need to be able to look at Offset 14 and Length is 1B. I need to be able to look at bit 0 - bit 5. I have NO idea how to read data like this so I wish I could be more specific but I can't. Can someone tell me how to read the specific bits and translate them? I have no idea how to google this. So if someone wants to point me to a search pattern. That would be awesome too.
Here is a chart that describes the bits:
bit 0 : Light LED (head) status, 0: OFF, 1: ON bit 1 : IR-Radar power status. 0: OFF, 1: ON bit 2 : IR-Radar detector status: 0: fine, 1: barrier detected. bit 3-5: Charger staus 0x00 : nothing happen 0x01 : charging completed. 0x02 : in charging 0x04 : something wrong, error occur. bit 6,7: undefined, do not use.
Is there any container that would hold a number that is 10,000 characters in length? would I have to create one? If so how would I go about doing something like that?
I have a problem to make the comparison from char to string array using Naive Algorithm in vb.net.[code]The problem is the system cannot compare the input from s1 to compare with s2.
how to split a string into an array based on it's length?Say if I want the length to be 350 then every 350 chars in a textbox will be split into an array like [code]
