I am trying to edit a dbf table. I would like to be able to rename field headings and change the field type, ie string or dbl, and the size of the field. is this possible to do with vb.net. I have connected to the dbf file but after that am lost on what to do.
I am building a data based application using VB 2008 an SQL Express. I need to create textboxes on my form using code, (With & End With) method. I need a simple code string that will allow the app to check if the field to wich the textbox wil be databound is Nul, If so the textbox will not be created.
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...
I am pulling data from a local MSSQL database using a stored procedure, then send the data to a web service. Every part of the component works well except for a pesky problem will a DBNull being returned from the DataRow field, when I know that the field is not null and has valid data. The database and associated INSERT statements that add to this field are designed to not allow NULL entries. When I debug break the program on or right before the line that throws the error I see that the field has valid data for the current row.If I add a null check to the code (as below) the operation continues as normal:
Dim dataResultsTable = Me.myViewTableAdapter.GetData(int) For Each myDataRow In dataResultsTable.Rows If worker.CancellationPending Then
[code]....
Why is the read operation returning DBNull instead of the data in the database?
EDIT: Just to be clear, the operation does return the proper data, but the data is not being saved into the variable.
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
This is something that I'm curious about. Is it possible using OpenFileDialog to have user select, instead of Access Database File,a file with different name and type but keeping Access Database connection string intact ? I have no idea how you would go about attempting this-----I thought it might be better if the user opened a generic file instead of realizing that they were opening a Database File.Can you create Custom file Type to handle situation like this or do declare some type of Variable
I'm trying to change the value of a field, and can't get it to work. I'm using the example they gave of how to read through a CSV file, looking and displaying each field. Everything works OK, and after I change the value it displays the new value, but when I look at the file I've created, it has the old value. I'm new to VB, so forgive me if it's something really dumb. Here's my code:
I've got a SQL Database with the field type Date, when i load any data such as 06/04/2010 into my masked textbox it shows as 64/20/10 (without the leading zero's so the date shows wrong.
Also how can I set it to be dd/mm/yyyy and not mm/dd/yyyy?
I have problem in my application when updating 3 items otherwise it is as good as work. The problem is when updating the username to the access database an error showing that "Datatype mismatch" when updating the date and time field an error occurs and tells that the "Unknown field type". This is my code where bold faced lines have errors:
Dim objCmd As OleDb.OleDbCommand = New OleDb.OleDbCommand() objCmd.Connection = con.con 'Make a command to insert data
If the field type in the SQLServer db is 'nvarchar 10', what would be / is the field type in a DataTable filled by rows from this SQLServer table? String?
I've got a set of static "enumeration" classes that I'm using to hold meaningful variable names to represent meaningless code values I receive on an input file. Here's an example of one.
Public Class ReasonCodeValue Private Sub New() End Sub
I need to set a field that i have dumped into a dictionary to a value that is always a string, (well, it came from an xmlElement, so the .value is a string)
Function setMembers(ByRef ClssObj As Object, ByRef nLinkObj as Object, ByRef xml As XElement) as integer Dim fields As New Dictionary(Of String, FieldInfo)
I have my application sending out emails when the user triggers certain events. The problem is that the email logs into the local Lotus database stored on the person's computer so the emails appear to be coming from different individuals.
Is there a way to alter the from field? I'd like to have everything coming from MyProgram for example, even if that user doesn't exist in the Lotus directory.[code]...
In my page there is a fileupload control and a gridview. When I upload a file, the DocName and the path of the saved file will in the gridview. I put the filepath in a hyperlink field so that it will show "View file"(not the path). My problem is - the gridview is showing "view file" text when there is no file saved.It works fine when I upload a file.
I have an array set up to receive the names of forms when they open. The form name is sent as a Form not a String therefore when I run my code I cannot check for whether the field is empty in the normal way (ie. array(1) = "") as the "" are only usable with strings!
Dim Forms(24) As Form Dim i As Integer Dim Free As Integer = -1
[CODE]...
I only need a solution to do the same as array(1)="" but for windows forms.
A string can contain from 0 to approximately 2 billion (2 ^ 31) Unicode characters. Does this mean the length field for the string is a 4 byte unsigned binary field, or is it a 4 byte signed binary ?
I am looking for some code that will allow me to set field properties of fields in a table I have just created in code using vb.net (2005). I have seen a number of articles to do this in vb6 but not vb.net.
I have the following code to try and change a field in a Microsoft SQL database. I don't get any Exceptions when processing the code but I use the Microsoft SQL Management Studio to view the data before and after but the data does not change.
myDataAdapter.SelectCommand = New SqlCommand myDataAdapter.SelectCommand.Connection = New SqlConnection(myConnectString) myDataAdapter.SelectCommand.CommandText = mySqlString
I have a field on my form for Check Number if a bill was paid by check, if not it should be blank. When I run the query in Access it returns the right records.the query loads all current customers, 99 out of a possible 107, when I navigate through the records as soon as I hit one where a Check was used, the Check Number field stays filled in for all records displayed after.
vb.net If Not dsForm.Tables(0).Rows(dbCursor).Item(1) Is DBNull.Value Then Me.txtRentalID.Text = CStr(dsForm.Tables(0).Rows(dbCursor).Item(1)) Me.intRentalID = CInt(Me.txtRentalID.Text.Trim.ToString)
I have some xml that I read from an xml document, now I need to take that same xml and then change one field and then drop back to a file again. [Code] so then as you can see I tried to use a new open of the document from scratch and I get the same error. I read that its because I may have 2 imports that have the same method? I had 2 XML imports and made it only this, but still get the same error. [Code] how to fix my issue or a better way to read and change the one field I need to change?
I've got a custom NumericEditor control that has a nullable Decimal property called Value. When I bind a data field to Value, I'd like to retrieve the underlying Type of the data that's bound, so that I can restrict the use of decimal places if the source field is an integral data type.I figure I'd have to do this in the BindingContextChanged event, but how do I get the Type of the data field from the binding itself? My Google-Fu is failing me at the moment.
In short, I'm looking for something like the GetValueType method mentioned in the following question: Simple databinding - How to handle bound field/property change. Winforms, .Net I imagine this method would also be handy if the Value property was an Object.
I have an vCard application that needs to read vCard Data, and have found a RegularExpression which gets the FieldName, Encoding and FieldValue from the file, here it is below:
Without skipping them. How can I modify the RegularExpression so TEL;WORK;VOICE ends up as part of the "FIELDNAME" and 0200 0000000 is part of the "CONTENT".I am unfamiliar with complex RegularExpressions and cannot figure out how to modify it, there is a regular expression that gets these:
^(?:TEL)([^:]*):(?<TEL>[^ ]*)
However it only gets the FieldName as "TEL" and I need the whole value for this so I can tell the numbers apart in my application.If possible the Regular Expression would read the WORK and VOICE elements also like the CHARSET and ENCODING in the current regular expression, so they can treated like an Attribute and Type for example, however anything which allows the Regular Expression to read the whole TEL;WORK;VOICE as the FIELDNAME will be fine.
Reads up to the first Colon which covers the Whole FieldName, however it would be nice to store each SemiColon Element in a seperate item such as ATTRIBUTE or TYPE.
I have the following Data Transfer Objects defined:
Public Class MemberWithAddressesDTO Public Property Member_PK As Integer Public Property Firstname As String Public Property DefaultAddress As AddressDTO Public Property Addresses As IQueryable(Of AddressDTO) End Class
I am linking to an SQL table with 'Money' field. When i try to update this field in VB.NET I get an error message that "Can not convert a character value to money. The char value has incorrect syntax".
Dim Query = From t In New XPQuery(Of xUser)(Xpo.Session.DefaultSession) .Where("Name=John").Select("new (Name as FirstName)")
Unfortunately i get the error No property or field 'John' exists in type 'xUser'.Of course no such property exists in my xUser class, but hot can i fix that?After reading within the DynamicLinq Class i found this function
Function FindPropertyOrField(ByVal type As Type, ByVal memberName As String, ByVal staticAccess As Boolean) As MemberInfo Dim flags As BindingFlags = BindingFlags.Public Or BindingFlags.DeclaredOnly Or _ If(staticAccess, BindingFlags.Static, BindingFlags.Instance)[code]...
How can i edit my "faulty" query? What am i doing wrong here?