Q1)My ASP.NET VB Script will write long writings - like many thousand words into my Access DB but i have previously had problems with the text containing characts such as '.Is there a way of inserting such?
Q2)When I read a database field in consolidates it into my string variable on a single line. What variable type should I use to have it maintain the line spacing and stuff.
I don't know if this forum is the appropriate place for the question, but here it goes.I need a hand of someone who knows "iTextSharp" - it was created mainly to build PDFs, but I am using "PdfReader" function to retrieve all the plain text out of existing PDF files, in my VB.net project.
[Code]...
How can I insert a hyphen after each 3 characters in a textbox? For example, if in the text box there are: ABCDEFGHIJKLMNOP. how can I insert a hyphen between each 3 letters automatically? The result would then be ABC-DEF-GHI-JKL-MNO-P. I have come to a way but it's not a practical one, i.e I used Insert(,"-") but then lines are filled with conditions slowing down the application. [Code]
View 5 RepliesVB.Net (2008) doesn't seem to allow inserting formating characters (eg.) in String.Format:
'BAD MessageBox.Show(String.Format("{0}{tab}{1}", "Foo", "Bar"))
'BAD MessageBox.Show(String.Format("{0} {1}", "Foo", "Bar"))
MessageBox.Show(String.Format("{0}" & vbTab & "{1}", "Foo", "Bar"))
Is there an easier way to build a formated string that must contain formating characters?
I would like to ask if you guys know how to convert 1 to 00001? For example, I have an item in my database with an ID of 00001. When I add another item again, it must increment already to 00002. But when I try adding one, the next ID saved is just 2. The zeros aren't on the left side.
The code is shown below
da = New OleDbDataAdapter("select * from booklet", con)
cb = New OleDbCommandBuilder
dt = New DataTable
[Code].....
The output in the database after the 00025 is 26 up to 50 only. If I add another again, it's just another 51-75 only. I can't seem to save it on a format like the 1st series of ticket number that I've added directly on the database with the format of 00001-00025.
I am writing a small project which first reads all the access database's in a web directory and shows the database names in a combobox.
When the user select one of the names, the system connects to the database in question (still in the web directory), and shows the database contents.I have tried the following code:
Imports System.IO
Dim NetFiles As String = "http://www.myWebsite.com/db/"
Private Sub LoadAllLanguage()[code]....
Problem is I get an error from the LoadAllLanguage function: 'does not support URL formats'
i have a button and 2 text boxes to insert datai have a button and 2 text boxes to read the datait seems that when i insert a row, it is not being inserted as the very next row. or at least it is not reading it in order1st. I add rws with the values (2 columns in table) 1 and 1, then 2 and 2, then 3 and 32nd. I read the rows, the do not come up in order 1 and 1, then 2 and 2, then 3 and 3. I will get somethign like 1 and 1, then 3 and 3, then 2 and 2,it does read it the same way each time i read it.
vb.net
Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInsert.Click
[code].....
I am trying to read records from a table base on unique values read from another table and want to write these records depending on value from a For Loop into different tables. This is code is what i have so far and it only read the last value of the loop and does not even write it to the appropriate table. [Code]
View 2 RepliesI am a bit of a newbie when it comes to vb.net and databases and I have a small favor to ask anyone I am looking for a very basic example on how to connect, read, update and insert data into remote mysql database. I have successfully connected to my database with the code below,, and for the moment I am just trying to LIST data from it in a listview control,, and then would like to find a way to insert data into it and update data.
Al examples I find on the net are too long and usually have too many unnecessary data around the code I need so I get a bit lost in it.Can anyone point me in the direction of SIMPLE examples that are easy to follow or provide a bit of useful code I could learn form.
[Code]...
Trying to read and display the text between two re-ocurring characters with a Serial connected device. The beginning of string starts off with "+8" and ends up with "0+". The string displays correctly between the characters, however I do not wish to see these characters. Here is my code that I used from a serial comm chat. P.S. this displays on two lines, the characters that I'm asking about are on the second line.
Private Sub DataReceived(ByVal sender _
As Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) _
Handles serialPort.DataReceived
[code]....
I've been trying to find a solution to my problem for quite a while. I need to build a program that reads data off of the screen, recognizes characters and images and then acts based on what characters and images are. For example, I provide it with a picture of a dog, a picture of each possible character, and it would be able to read the screen and tell me where the dog was, where the characters were and in what order, etc. Is there a free library for this out somewhere? I prefer something that can be used in C# or Vb.net
View 1 Repliesi tried out this code to read characters from an existing file:
Dim SR As StreamReader
Dim FS As FileStream
FS = New FileStream("D:email.txt", FileMode.Open, FileAccess.Read)
[Code].....
I have a tool which reads dBase files and uploads the contents to SQL Server, part of a system to import shapefiles. It works but now we have a requirement to import files that include non-English characters (Norwegian in this case, could be other languages later) and they're being corrupted. The dBase files are being read using an OleDbDataAdapter. Stepping through the code I can see that the text is wrong as it is read in. I'm assuming it's something to do with code pages or Unicode but I have no idea how to fix it.A dBase Reader application tells me the DBFs are in code page 1252 - I don't know if this is correct. My upload tool runs on Win7 with English (UK) regional settings.[code]Is there a way to tell OleDbDataAdapter what code page to use or a better way to read dBase files from VB.Net?
View 2 RepliesI have a code to rewrite an ini file, but characters such as 'ñ' will get changed to '?'. This way my whole ini file will get ****ed up, I have no idea to fix this and this is a serious issue for my application.You can find my whole source file here:
View 4 RepliesI done this:
sTxt = File.ReadAllText("C:someWebPage.html")
reading dBase DBF with non-English characters
View 9 RepliesfI am reading some 10 fields per line from a text file. One of the field is in Chinese Characters. The other are numeric or english strings. When I open the text file (using notepad), I can see all characters displayed properly, including the Chinese. BUt when I read the line o text into a variable oneLine in a VB program using the following code:
Dim V_file As String = "N:Table_test.txt"
Dim oneLine As String
Dim scanfile As New IO.StreamReader(V_file)
[Code].....
My project needs to read and count the individual characters in a textbox. Is that possible? If so, how so?
Nameone = TextBox1.Text.ToLower
For F = 1 To Nameone.Length
L = Nameone(F)
[code].....
So I want my program to read a file, but sadly there are null characters in the text file. The program searches for strings and I want it, when searching, to ignore all of the null values and just the actual characters. Is this possible?
View 4 RepliesI have .txt file with ANSI encoding format which is generated from Japanese OS.
so it has Japanese Characters in ANSI txt file.. i don't know how japanese characters allow in ANSI txt file..
My doubt is that
How to read all language characters from ANSI txt file. That txt file will contain any characters like English,Japanese,Chinese,Numbers etc... ( Any kind of characters )
I want to read that characters as it is in file..
Dim sr As New StreamReader(_FilePath)
While Not sr.EndOfStream
MsgBox(sr.ReadLine)
[Code]....
Is there any general way to read all types of characters with ANSI format ?
I am trying to read the file contents using
System.IO.File.ReadAllText
After reading the file contents the special charaters gets replaced with some garbage characters like "?".
To eliminate this I have used encoding along with above method
System.IO.File.ReadAllText(strFile, System.Text.Encoding.ASCII)
But still it is not working.
Actualy when i do click to insert button in my form i get this error:
the strange is when i close this window and i do click again the insert button the record is successfully added the the database :( here my insert code (the necessary because it`s so long):
Try
'build sql requests
Dim sqlQRY1 As String = "INSERT INTO AUDIO Values ('" + nomAudio + "')"
[Code]....
i would ask why in first click he show me error but in the second it worked although it`s the same operation, the same form without changing anything in his components and fields .
My problem is when I try adding a new appointment I get an error that says ""Column 'AppID' does not allow nulls."" Editing existing appointments is fine and it updates the DB no problem. I don't have an INSERT statement right now (which might be the issue) so I was thinking of doing this: INSERT INTO [tablename] ( [column1], [column2], ... ) VALUES ( [value1], [value2], ...) Only problem with that is I would need to use the textbox names for the VALUES, and that form that pops up to gather appointment info is from a third party, and I can't find the names of any text boxes
View 2 RepliesI've written the following code to add a new record to a database:
Public Shared Sub AddTopicUser(ByVal UserID As Integer, ByVal TopicCode As String)
Dim RowsAffected As Integer
Dim ATUDCONN As New OleDbConnection
ATUDCONN.ConnectionString = DBCONNSTR
Dim ATUDCMD As New OleDbCommand("INSERT INTO tblSubscriptions (UserID, TopicCode, Completed) Values (@UserID, @TopicCode, @Completed)", ATUDCONN)
[Code]...
I recieve no errors from the code, but when i open the database after - the record has not been added.
I have checked that the values being passed as parameters to the function are valid. I was curious as to whether I was formatting the OleDbCmd correctly, which is why i added a message box function to show be the value of the connection string which at runtime is: when they're not being added to the db?
I am having problems with inserting into my sql database my program is as follows:[code]So when I enter my data, into my program, it goes perfectly until it gets to "dim num as integer = cmd.ExecuteNonQuery" and then it comes up with an error saying "Syntax error in INSERT INTO statement.".i am also doing an update function which is pretty much exactly like this, except for the sql command of course, and that works perfectly with this code.[code]I have noted that instead of"replace" it should be "insert" but am now getting another error where it says "Conversion from string "#PlayerNo#" to type 'Integer' is not valid."
View 5 RepliesSo I have the following that seems to work fine in MS SQL Server management Studio and seems (but isn't) to be working as its doing a re-direct to another page after the insertion of data...Basically, I pull in all the data from the text boxes and hidden fields, convert that info to strings and do my insert statement. Now in MS SQL SMS The following insert statement works:
insert into [Contacts].[dbo].[contactInformation] values ('Adam', 'john', '16', '' , '' , 'm', '', '');
You can tell from the above which are allowed and which are not allowed to be null. any ways. Why is this not inserting data into my database? is it because of
cmd.CommandText = SqlDataSourceCommandType.Text
I'm trying to insert data into a MS SQL database from a vb application. When i enter in some dummy data at runtime, this is the error i get "Invalid column name 'ahfh'. Invalid column name 'dsfhdf'. Invalid column name 'sdfhdf'." The error occurs at this line - "myCommand.ExecuteNonQuery()"
Protected
Sub Button1_Click(ByVal
sender As
Object,
[code].....
Iam developing bank application in vb.net 2008. Back end is ms access. I want to insert customer details into two databases.I 'm included connection string as seperate module customer database
Module Module1
Public Const cnstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source= D:\Bank Project\customer.mdb"
[Code].....
I'm getting error in rs1.open(select *...) line as 'could not use File already in use'
I am using an SQL local database to store my data. I can connect to it, but i cannot write any data to it. I get no errors when i execute my code, but when i view the database it is still empty. I have working on this for about 12 hours, I have imported System.Data and System.Data.SqlClient
[Code]...
how to insert the images in database using vb.net.both using web cam and scaned photo
View 1 Replies
