I tried the 2 listed answers to this problem but neither worked.I'm writing with VB 2008 Express under .net 3.5 Project going well - no problems until I needed to change the form design again. The project still runs OK - the "Form1.vb" and "Form1.Designer" files are still there and look OK, BUT the "Form1[design]" tab is missing - how do I get it back?
View 2 Repliesi read a text file and i need to overwrite the first line of the text file this is my code
Private Sub readProvisionOrder()
'Loads ProvisionOrder from text file
Dim sFileName As String ' name of file in the directory
Dim sr_ProductsFile As StreamReader 'file reading variable
[code]....
i grow familiar with statements queries of SQL. Now, i have to start writting a store produce and function in SQL Management studio express.
View 1 Replieshow 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:
Me.Validate()
Me.CalendarTableBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.CalendarDatabaseDataSet)
But I cant keep the event displayed on my calendar when I close it and open it again.
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
[code]....
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.
View 1 RepliesI 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.
[Code]...
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.
[Code]...
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:
[Code]...
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.
[code].....
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.
View 5 Replies'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.
View 10 RepliesI 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.
View 3 Repliesi'm running Visual Basic 2008 Express Edition (latest service pack ... 9.0.30729.1 SP) on XP Pro SP3 with .Net Framework version 3.5 SP1 I have a rather large project I've imported from Visual Studio 2003 (Standard).The project compiles and runs just fine ... my compiled program itself never crashes.
But while I actually have the code up in the IDE, and simply adding/deleting code the whole IDE will randomly crash (usually without warning) and I loose my changes since last save.If/when I do get some hint of why it crashed, I get a window about illegal whitespace or something.... but that's rare ... usually it just crashes without warning and the whole IDE completely shuts down instantly. just deleting/adding a character is enough to trigger it maybe once every 30 minutes.
This is on a computer that is otherwise very rock solid .... no other program ever crashes, etc.
I am very close to finishing this function, what I am trying to do is a for loop which:
1) Grabs the value
2) saves the value in an .xml file for later use
Currently when I use a for loop to feed in my function I overwrite the hiddenFields.xml on every pass, instead of adding to it.
Calling function:
vb.net
For X As Integer = 0 To postingHiddenFields
Dim hiddenFieldsReturned As String = functionDealWithHiddenFields(HTMLResponse, postingHiddenFields, X)
Next
[Code] .....
So basically on every pass of the function I'm overwriting the values instead of adding to them.
Do not care to stay at these forums when criticized by other members.
View 6 RepliesIve searched for the pass hour on how to do this. Everything ive found is for vb6 and it wont work with 08 for some reason. Here is what i am doing, and the way i want to do it.I have a login form that has a checkbox remember me. Inside the if statement (If chkRemember.Checked = true) I want the code to write the username and password in a config.ini file in this format;
[LoginInfo]
Callsign=dsfsdf
Password=dsfdsf
[GeneralInfo]
Can someone provide me with a code i can use for this? I also want to be able to read that data to.
Okay, I have a structure that contains numerous elements... mostly strings, one or two integers. I maintain an internal array of that structure. The structure contains ONLY data elements, no code.I want to save the data to a file. I know that I CAN use StreamWriter.Writeline()to put out a formatted string for each element in the array. But is there any way to simply open a binary output file and save each structure, one after the other? And conversely, to load the array again in similar fashion? Something similar to this in intent, though I realize the code below doesn't work.
[code]...
To repeat, I want to write an entire structure to a datafile quickly and easily, without having to save each member of each element in the array. And conversely, to read the data back in the same way for easy loading of the array.
"An unhandled exception of type 'System.StackOverflowException' occurred in mscorlib.dll" when writing to registryI write to the registry quite often in my program (Around 10 times every 12 seconds) the error doesnt constantly pop up sometimes it can save 20times and on 21st ill get the above error. How can i fix this. Is it because im saving so often?
View 8 RepliesOk so there is an XML file for a program that already exists that stores a list of files along with other information.I need to open this file and read the file names and then potentially add files to it if they DO NOT already exist in the file.It is very important that I not wipe the XML file and have to write it from scratch every time.
View 4 RepliesI'm trying to read 5 bytes from a file and then do something according to what has been read. This is my code (I'll explain in a bit what's wrong):[code...]
It reads the 5 bytes I added to the encrypted file, but I want the CryptoStream to start from the sixth value and then copy the original bytes into the decrypted file, but it gives me an error:
Padding is invalid and cannot be removed.That's why I'm trying to make it read from the sixth value and then continue copying normally, but I'm stuck.
I'm currently doing a project, I have 5 text boxes, and the information I put inside them get's added to a record in my database..In this record, an auto-number is allocated, and I need to display what the auto-number allocated is..
View 7 RepliesI am coming across a lot of odd and annoying problems in this program and have almost had enough lol.
I cannot figure this one out for the life of me. I have used streamwriter a hell of alot of times and never once experienced this. But basically I have a string array and I need to write the entire array to a text file with a new line for each array item. So I have gone ahead and done this:
[Code]...
However the outcome is the text file only contains 1 line and that line is the last item in the array yet I know the array has got at least 50 items in it.
I found the following links to fill a listview and then write it to a CSV.[URL]..And I modified the codes and created the project which is attached to this post.
The project works OK but my only problem is that when it creates the CSV file, columns are not created in excel. For example if I expect the data to be placed in A1, B1 and C1 cells, the data will all be placed in A1.
I have a structure in memory which is working fine - now I need to write this entire structure to a file. The below code almost compiles, the problem is that "mstaRecordInfo" cannot be changed to a string, probably because of the Date field. I've just spent over an hour experimenting and searching the web but have gotten no closer to a solution.
[Code]...
This time i have a RTB (look.text) that contains no more than 12 lines (it updates according to a listbox but it will never exceed 12 lines of text). The lines contain numbers like this:2345,0,0,1,36,... and the last line will always be a number like: + or -123456789I also have 12 textboxes (a0.text to a11.text). How do i write each line from the RTB in a textbox?-i can't show you my code because it looks stupid and no matter what i tried i always ended up getting the same error "Index was outside the bounds of the array"-
View 4 RepliesFor writing to a Text file and saving it somewhere like my C: drive, Should the following work?
Dim 1 As NewStreamWriter ("C: est.txt")
I want to put this code into the On btn click section so it outputs the content of my listbox into a .txt file ready for printing if needed
I'm writing to console and it seems to work well. I'm using this
AttachConsole(-1)
Console.Out.WriteLine("Hellow world")
FreeConsole()
The question is:
If I run the app's exe file from command line, and try to redirect the output into a file. It doesn't work.For example:C: > myapp.exe > c:output.txt I still get the output to console screen, but I want to to be saved into output.txt What's going wrong ? How to do that?
im trying to write a .reg file out that is written into the exe's my.resources dynamically at compile time from a diffrent app... but the .reg file gets messed up and alot of extra txt gets added ...
[Code].....