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)
[code].....
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
[Code]...
I have an open database (dataset) with two tables. It is binded to toolboxes, but I have one field, what I have to calculate about other parameters. I have binding navigator, and I can set field values from controls (eg. toolbox). I can step my rows, with binding navigator. I can update my database. But how can I set field value from code?
I want a code line:
database.fields("fieldname") = something - or something like this
How do I set a field value in a VB.NET module using Reflection?
View 2 RepliesI have a databound ComboBox on my form. Is there any way that I can make the first field blank.
I can do this with a DropDownList in the HTML part of .Net but is there a way to do it for a ComboBox?
I'm using vb.net 2005. I've a textbox , a hidden field and a button. My textbox is setted to password mode. While editing an existing password, in order to display the password in password mode, i wrote txtPassword.Attributes.Add("value", strpassword)
View 6 RepliesHow does one set Originator (or From field) in an e-mail. I have tried setting RecipType to 0 together with RecipAddress and RecipDisplayName but keep getting an error when I try to set the RecipType to 0. Does anyone know how to do this and why is there such a woeful lack of documentation on this control?
View 1 RepliesIm writing an app which connects to a SQL Server database, via datasources / datatable.When Im looking at my .xsd I can see DataTables containing DataColumns. Each DataColumn has a 'NullValue' property which defaults to '(Throw exception)'.Because I have nulls in my tables I have gone through the fields and set all System.String fields to NullValue = 'Empty', System.int32 field to NullValue = 0.
View 1 RepliesI 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.
View 8 RepliesThere 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...
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 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.
View 3 RepliesIm pretty use to doing loops (although still relative new to vb) in my code however am having difficulty setting up one that picks up an entry in one data table and then sums a field in another where records have matching criteria. Example:
[Code]...
What i am trying to do is set up a datagridview on a form that shows the summary data. The time is controlled on the form by a trackbar (output to textbox) and I started setting up a loop using (For/Next) to isolate firstly the matching entries in field 3 (time). This works fine. I then used compute to sum the the field 2. However what i want to do is to loop through table 2 and where entries match i.e. where Field 1 in table 2="A" sum matching entries in table 1 where the DateTime matches.
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
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.
I have a Access table where I would like to set fields values ( swh1_ct and swInfa_ct) to null if my pdmH1_ct or pdmInfA_ct fields have values greater than 0. and vice-versa.[code]...
View 1 RepliesI'm trying to make an appointment scheduler here. The table has an AppID column which just increments 1 every time a new appointment is added. That works fine. It also has an ID column that gets a unique doctor ID assigned to it so the program knows which doctor has which patient.
Now, when I try to add a new row, no matter what I try, the ID field gets a -1. I've tried assigning it the doctor's ID that I'm currently browsing as well as hard coding it to be a "3" and it still shows as -1. So this means that while it [B]does[/B] save and update the new row, it adds that -1 in the ID column and thus the program can't tell which doctor has it so it won't show in my program. I don't know if this is because I've tried so many data sets that it's getting them confused or what, but here is the code that I am using to try to save this:
[Code]...
I'm trying to do a Datediff in VB.Net thats confusing me. Basically I'm trying to do the following. If DateDiff("D", Today(), rsData("Start")) > 0 Then This is working fine when comparing the value from SQL with todays date. I however need to convert this to check the current month and if it matches then return whatever I'm trying to show below.
[Code]...
I have:
Dim aList As List(Of myObj.Answers) = myObj.GetResults(someID)
This returns:
aList.AnswerID | aList.AnswerCount
1 3
2 5
3 9
How can I get the sum of aList.AnswerCount field in my List(Of myObj) ?
I USED THIS CODE :
Private Sub ButtonX1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonX1.Click
Dim myReport As New CrystalReport1()
[Code].....
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:
[Code]...
I am loading a form in a tabbed window but when the form loads it does not default into any field on the form. I want it to automatically default to the first field on the form, how do i do this?
View 12 RepliesI added a bindingsource and set the datamember to a table (in access) which has two fields. My bindingsource name is M and the field is usersT. how do i get its value?I tried:
dim tmp as string
tmp=M.item("usersT")
but this doesn't work.
I want to edit the Filed name from session to session1 because session is keyword using vb.net
View 4 RepliesI am trying to use the value of a field of the last row in a table. I have been trying to use tables().Rows().Item() but somehow it always returns the value of the first row instead of the last one. here is the code:
Dim accion As String
Label1.Text = ""
Label2.Text = ""
Label3.Text = ""
Me.HorasTableAdapter.Fill(Me.ControlDataSet.Horas)
[Code] .....
I have one table in MS Access 2007 called "Case" and this database is link to my project in VB2010. The first field in the table is called "Auto" i made this one as autonumber. What i'm trying to do now is to create the "Case ID" with the combination between current date and current autonumber in "Auto" field. eg: 191010-12.
I have a windows form with a gridview bound to a lisbox. I need to know how to get the field in the gridview with prices to show a total in a textbox, also on the form.
View 3 RepliesI am using database compact and i loaded it on my form and i want to update a single field but I cannot, why: what am doing is:
[Code]...
How I can make the field values to field names?
View 3 Replies[code]...
I do no it is right way to return XId field.A bit confuse since this is first time i touch vb since vb6. Lot of changes.Software Use : Visual Web Developer 2008 Express.Database Use : Sql Server 2008 Express.