i connect a database (.mdb) but getting error when i try to save a data in field more than 50 character. i also set document field for 255 char. then cant change it even i edit it from ms access. how can i set mdb. file to input 255 character or more?
View 1 RepliesIs there any way to put the "&" symbol on a button text? VB keeps converting the name "Forty-Six & 2" to "Forty-Six_2".
View 6 RepliesI try to store Korean langguage in Microsoft jet OLEDB 4.0 database, but I cant retrive it back.
CODE:
I try to google around for weeks..but still cant find the solution, I believe microsoft jet 4.0 should support unicode, but cant find any command like charset to set the character set.
I've try store with DataTypeEnum.adVarWChar/DataTypeEnum.adWChar/DataTypeEnum.adLongVarWChar.
I've set the regional and lagguage setting to korean(I can view korean in textpad).
I've try System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("ko-KR") before retrive korean string also.
Now i have totaly no clue. just suspect, i need to do something when create the database or when read from the database, but dont know how.
I have a masked textbox on my form for a phone number. I want to store its value in my Database without the literals as the database field for that phone is only 10 characters long. How do I store this value in the database field without any literals.
View 3 RepliesI want to read a text file(.txt) character by character into a database.There are 28 characters on each line and I want to read the first 16 into a column in a database and the rest in another column in the database.
View 7 Repliesis possible to store a colletion into database field (ms sql server) is this case, the collection can contains different data types. What data type should be the database field ?
View 4 RepliesI'm trying to replace one character at a time in order to store its index, therefore if the replace is used all characters are changed and I cannot keep the index of all characters.
[code]...
I want to store .pdf into image field of sql 2008
and display the same in vb.net without using adobe pdf reader
I am making a small and very simple game that is ment to help children learn to recognise letters. I have come to a stop as I have 3 text fields. When something is entered into the first field, the program will set focus to the next text field. The problem is when the child tries to delete a character from a previous field as the focus is already set to the next text field. I want it to delete the character from the previous field when the backspace bar is hit. Any suggestion how this might be done?
View 5 RepliesI'm connection to a sql server 2005 database. I have a field called MapName which contains the following name for example:
SAMWON TEXTILE CO LTD
NO NOT USE
Notice the field contains an enter character.Now in my vb code I have the following
Dim SupplierCommand As New SqlCommand("SELECT OurID FROM [Mapping] WHERE (MapName=@SupplierName) AND (OrgId=" & CustomerId & ") AND (Active=1);", con)
SupplierCommand.Parameters.AddWithValue("@SupplierName", f_supplier)
'con.Open()
[code]....
where the @SupplierName parameter would be:
SAMWON TEXTILE CO LTD
NO NOT USE
exactly the same as my database field.But for some reason this query fails because of the enter characters.
I'm connection to a sql server 2005 database. I have a field called MapName which contains the following name for example:SAMWON TEXTILE CO LTDNO NOT USENotice the field contains an enter character.Now in my vb code I have the following
Dim SupplierCommand As New SqlCommand("SELECT OurID FROM [Mapping] WHERE (MapName=@SupplierName) AND (OrgId=" & CustomerId & ") AND (Active=1);", con)
SupplierCommand.Parameters.AddWithValue("@SupplierName", f_supplier)
[code].....
There are lots of questions about this but I've not been able to solve my problem using the answers to any of them (after many, many attempts..)
I'm working in vb.net creating an asp.net web application. I have an SqlDataSource and a GridView on my page.
I want to change the DoNotMail boolean value represented by a Gridview checkbox and automatically update in the database if the checkbox is checked from 0 (False, Will Mail) to 1 (True, Won't Mail) here is the code I used. [code]...
is it possible to do a two way sync on the entire gridview when the user hits a button so you don't have to do an update every time a row is changed? because the user might check the box and then check another box then uncheck a box and it would be a lot of updates...
My client wants that my table be filtered based on the values from a field regardless of its order.
Example: I want to search for a student whose surname is 'Thomas' but the keyword is not the first in the field. The 'Surname' field, instead, contains the value "Ian Thomas".
If I am going to use this code;
bindingsource.filter = "surname Like '" & textbox1.text & "'"
It will base the searching on the first characters of the field only.
I created a local Database in VB2008 with 4 tables, the problem is that I have a textbox in one table and a combobox in other table and I want that the information that I put in textbox appear after in combobox from the other table... that's possible?
Table: Filmes ... Field: NomeTextBox
Table: Tempo de Aluguer ... Field: Nome_FilmeComboBox
Dim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 RepliesI understand that within a rich field text box you can search for a string and then format that string, but I am looking to change the formating of a certain position in a string regardless of what character is at that position.Can this be done in VB 2008?
View 3 RepliesThis is my code which i used to try this but it inserts only the last value in the listbox but i need all the selected values seperated by comma [code]...
View 2 RepliesI have a matrix with rows indicating a name (Ex Store name) and I have data pertaining to that in the DATA cells. I also have another date field in this format (MM/DD/YYYY). I would like to use a cross tab between Store Names and Just the Month of the date field.
[code]...
is there any expression I can use to get the month format on the header of column.
I am creating a database in VB.NET for a movie rental place. I currently have three forms;
Member Information
DVD Information
Borrow DVDs
What I would like to do is when I am viewing a member's details, if I click a button 'Borrow DVD for Member', the member's ID number transfers over to the Borrow DVDs table in the Member ID which also would hold some information from the DVD Information table, but I'm sure if i can figure out how to do this firstly, I will be able to apply the same rule and work it out myself.I have been trying to use a query statement like;
INSERT INTO [Borrow DVDs].[Member ID] [IN goodstuffvideos.mdb]
SELECT [Member Information].[Member ID]
FROM [Member Information]
but that has been coming up with error codes and completely not working.
Borrow DVDs table fields are: Borrow ID, Member ID, DVD ID Number, Hiring Fee, Borrowing Limit?
DVD Information table fields are: DVD ID Number, Title, Rating, Hiring Fee, Borrowing Limit Member?
Information table fields are: Member ID, Family Name, Given Name, Address, Town/Suburb, Postcode?
The error coming up is; Error in INSERT statement. Unable to parse query text.And under that it says The query cannot be represented graphically in the Diagram and Criteria Pane.
Restricted data input for a Textbox
View 6 RepliesI have some code that queries all the printers on our print server and returns a list. I need this code to work so please don't reply with comments asking why I am using it when you can simply type \Server to list the printers (I know this, but need the code to work as part of a larger application). When running the following code on an IT PC with admin rights, it works. When running on a restricted user PC, it doesn't. How can I add permissions in code to elevate the EXE to 'run as administrator'? [Code]
View 14 RepliesI am coding a program that will allow the user to input 5 payrolls for Store 1, Store 2, and Store 3. The total of the 5 payrolls are then added together and shown in the respective Store's labels. A total label is also there to add up all the totals into one number. The numbers in the label must be in currency form. My problem is the numbers don't add correctly when I hit calculate. The first two numbers add together, but then after that the number just seems to subtract a random amount.
So far I have this --
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.Close()
End Sub
[CODE[...
Possible Duplicate: Function or interface marked as restricted, or the function uses an Automation type not supported in Visual Basic.
Basically, im just searchign for uPnP devices using the uPNPDeviceFinder classes .FindByType method, .FindByUDN works, but FindByType gives an error:VB6 gives a compile error when I attempt to call the method:
Function or interface marked as restricted, or the function uses an Automation type not supported in Visual Basic.
why i am getting it. I am referencing and using the upnp.dll file as found in yoru system32 directory - when i reference and use this in VS2010 (say, vb.net) it all works and no issues are found, but in VB6, i get the error above.
I had a dataSet which link to a database. I need to add one field inside the database, After adding the field, how can I update and link it to the dataSet?
View 4 Replieshow to insert special character in sql database like wise" @#$%^&&*"
View 2 RepliesI need replace some character when add new record to database. I try this code but it isn't work.
bseo = Replace(bseo, """, "")
how I can resolve this?
How to allow the user to select the date from the DateTimePicker and store that selected date month and year in the database table?
View 3 RepliesI am doing an application on receiving sms but the problem is that I want to put the receiving sms in the database. I am not sure how the process works.
Here is the code that I am using
Imports System.IO
Public Class Form1
Dim receivedData As String
Private WithEvents serialPort As New IO.Ports.SerialPort
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code] ....
For my website I've just implemented tinyMCE for my site (just a word processor). Everything works fine except when i try to store the string variable input into a sql server database. I want to store a string and not have the html tags make me exceed the 8000 length limit(the html tags take up most of that space). My question is, is there a solution so I can store my document with the html tags without shortening my document? Create an if statement that will determine the length If > 8000 than split the string apart and insert into separate fields. Maybe their is a compression feature which I'm unaware of?
View 1 RepliesI am doing a project on sms. I am doing the receive part where the sender send sms and my program just take the sms that has been received and store in the database but the problem is that I did not know how to connect the sql connection with the program that I used which is to detect the receive sms and store it in the database. My problem is that I want to store the receive sms in the database. I am using the SQL Server Database and visual studios 2005 in windows appliaction. I know how to make the connection between the application and the SQL server but I did not know how to implement it when to receive the sms.
[Code]...