I have been writing a program to teach myself the process of reading and writing to an XML document. I can figure out how to load the present file, populate the fields, and save save settings using elements that are already present, but I can't seem to figure out how to add to an XML file without clearing the data which is already there? What am I doing wrong?
Public Function SaveMovieList() As Integer
'Create writer
Dim MovieList As Strin
[code].....
I'm trying to connect a VB application (2010) to an MS Access DB by adding a data source from the data menu but I receive this error message "The connection you selected uses a local data file that is not in the current project.Would you like to copy the file to your project and modify the connection ?
If you copy the data file to your project, it will be copied to the project's output directory each time you run the application" and the options are (yes , No , Help)
If I choose Yes I will not be able to make the application 'device independent ' since it will not be copied under the bin , and if I choose No , changes won't be applied to the DB
I am trying to pass a different template to a Telerik Grid, depending on if the add button or the edit button is pressed (on creation: a few field to fill. on existing: add button : some extra fields to fill, edit button : most field are read-only, new field to fill).
Dim myGrid = Html.Telerik().Grid(Of SomeModel) _
.Name("myGrid")
If Model.Action = AddNewData Then
myGrid.Editable(Sub(editing) _
[code]....
I have no idea on how to do the if "gridBoutonPushed = Add" then part.
How would you add data source to your combobox from a combobox that is connected to the access atabase?they are both ın the same form of course and the software language ıs Visual Basic. I ve got two comboboxes that I need to connect with eachother combobox1 is showing the "itemsonsell" from the "table_items" table from my access database, the second one should show the "prices" value from "table_items" depending on which "itemsonsell" item is chosen on combobox1,I ve done the solution below,but it didnt seem to be working,it is showing all the "prices" that are under the "table_items" table's "prices" class.
[Code]....
i want to know that when im adding my data in form after loading one person data then 2nd person data the 2nd person data cannot come to next line it is adding on the same line.plz tell me wat can i do?
View 6 RepliesI have a datagridview on form1 but I don't want users adding data using datagridview, instead, I wanna use details view. So I created a form2, dragged and dropped details view on form2. I changed the Addnew on BindingNavigator to None and added a code to the Addnew click event handler to call the form2 out so that I could add data from there. But, when form2 loaded. the textboxes pulled out all the information from datagridview. I did not want that, I wanted all the textboxes to appear empty when it was loaded. so I deleted all the textboxes and added my own textboxes so that they appeared empty when form2 was loaded.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.VendorTableAdapter.Insert(TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text)
Me.VendorTableAdapter.Fill(Me.VendorDataSet.vendor)
End Sub
I added the above code to allow users to add data into datagridview using data details view.
I'm displaying data from a database in a datagridview, but the player also needs to be able to add new rows, which isn't allowed because the datagridview is data-bound. What is the simplest workaround to this problem?
View 10 Replieshere's the code:
Try
Dim com As New OleDbCommand
com.Connection = con
[code]......
I have got an Xml like below. I want to "add" data in it. Tried alot of forums..
eg.<?xml version="1.0" encoding="us-ascii"?>
<!--Version 5.0.0.0 - 4/12/2011-->
<SalesReport>
[code].....
i want to add data into a datagridview line by line.for example on a point of sale window where you pick item by item and populate the grid.ode. i also want to know if the datagridview is the best for this. can i achieve the same with another control and still be able to go back to each line to edit.
View 4 Repliesi have a problem when add data into dataTable. The problem is that after populating the dataTable with the 1st, and when adding a 2nd column, the row that contain the data is not at 1st row of 2nd column. It is directly under 1st column row. For example, column 1 has 10 rows of data. After adding the 2nd column, the data is at row 11 instead on the 1st row. Can someone tell me how to add the data for 2nd column so that it will be in the 1st row. Code for adding the data
Dim col1 As DataColumn
Dim row1 As DataRow
col1 = New DataColumn("Column 2", System.Type.GetType(" System.String"))
dTable.Columns.Add(col1)
[code]...
I have a project I created for my VB class where you enter what type of ticket(combobox), how many tickets(textbox), what type of tickets(listbox) and will give you the total amount.I want to do a little more to the program and was wondering about adding the person's name, address, phone, city, state, zip and then having all the information put into a database. I wanted to also take the information entered from the program and use the printPreview control to view a report from Access(possible?).
I've only worked with viewing database information on the forms in VB but I've never entered data into the database. Is this possible?Can I have the information entered on the form be entered into a database that keeps track of all tickets purchased and customer information?I can see this working in my head but don't know if it's logistically possible.
where X, Y, Z, F1, F2, F3 can be as small as 1 digit or as large as 3. There is a space between each value.I need a loop where I can write these digits to an excel document where:The first X goes into A2, the first Y goes into B2, the first Z goes into C2...The second X goes into A3, the second Y goes into B3, the second Z goes into C3...And this continues for as long as the program is run.
View 2 RepliesDim ConnectionString As String = "server=dataserver;
initial catalog=nash;
persist security info=true;
user id=sa; password=nimda"
Dim conn As SqlConnection = New SqlConnection(ConnectionString)
conn.Open()
[Code] .....
Now here id as autonumber field for table. After adding data to table I want added row's id value. How to get it ??
Iam try addingnew data source by using the Wizard but it gives me massage error (unexpected error has occured)
View 11 RepliesOk so I am writing code to a contacts database and as i add new info to the table it is not committing to the table. I have attached my program... idk if you will be able to open it.
But I have 2 buttons one adds a new row to a datagrid and the save is suppose to save the data in the grid to the table called contacts.mdf
Private Sub btnSave_Click(ByVal sender As System.Object,
[code]....
I built the sample project "How Do I" Data Access and ran into a problem adding, updating or deleting records. The project works like a champ until this step... It will let me delete, change or add records just fine, but when I save and close project and go back to my "show table data" in the database explorer nothing has changed?
[Code]...
if you could possibly point me to the right direction, that would be great. i have tried researching about this but found no solution.i have a 2d array which holds student name and 3 grades (eng, maths, science.)student array (24,3)Now, i would like to use the data which is held within the array to create averages.I need a total class average for: maths column, eng column, and science. I also need an overall average for all subjects.the code i have used, so far, brings some odd results.
studentarray(i,1) / count
studentarray(i,2) / count
studentarray(i,3) / count
[code].....
I'm am very new to Vb.net, I have coded in VBA.I have created a form that will open Microsoft Excel, add header text to the columns, and insert the text from a few of the controls located on my form ("not finished adding controls") when I click the Submit button.
My problem is that when I enter different data into those controls and click the submit button again, I get a new Excel Workbook with the new data.I need the new data the be submitted to the .Activecell.Offset(1,0) of the already open workbook.Ultimate Goal of Submit button is to open new Excel workbook, Enter multiple rows of data via Visual Basic Form.
[Code]...
i am a student i have an assignment in a class in which i am totally lost PLEASE HELP
1) Code the necessary instructions for the ADD button which is instantiating an object and adding to a collectioni
2) Code the necessary instrutions for the DEL button
3) Code the rest of the SAVE button to allow us to continue to edit and save the customers.[code]
Most of the project I do, I use the datagridview to display the data from the database. What is the different between the datagridview and listview? If I want to display the data from the database, should I use the datagridview or the listview?
View 4 RepliesWell basicly I have been trying trial and error, and im sure this is a very simple fix, but how would I populate a ComboBox with information from My.Settings using VB.Net.
View 6 RepliesI am trying to input the data from textbox1 into the section for user= but can't get the syntax right.
Console.WriteLine(sqlQuery("INSERT INTO TESTDATA (User, Status) VALUES ('edavis','Passed')"))
This is a winform and I'm using mysql as a database, here is my code:I'm trying to add data into multiple tables.[code]Index and length must refer to a location within the string. Parameter name: length
View 2 RepliesI am trying this..
Imports System.Data.OleDb
Public Class Form1
Dim conn As OleDbConnection
Dim cmd As OleDbCommand
[code]....
I get an error: object reference not set to an instance of an object
I am using VB express 2008 with MsAccess as database. How to bind a dataview to a listview i.e. how we can add data to a Listview from a Dataview.
Dim
DailyExpenses As New DataTable("DailyExpenses")
Dim dv As New DataView(DailyExpenses)
I read in some post something like under but when i tried to implement that ItemsSource is not a member of Listview:
listview.ItemsSource = dtView
I use the following code to update a DGV row line by double clicking a row from another DGV. but the code is not writing values to the new line irrespective the cursor placed in new line of the first DGV. how to change the code, so that the new values are added to the new row.?
Private Sub DGV1_CellDoubleClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TemplateDataGridView.DoubleClick
Me.DataGridView1.Show()
[Code].....
Im currently doing a small programme of a register system. I need to add a new group box filed with a few textboxes and a couple comboboxes for each entry in a access 2010 database. for example if i had someone called bob in my database with his details i would like the GUI of the VB app to add in a new textbox for the name, a textbox for the address ect in a set order, this needs to work for multiple entry's so the textboxes ect don't overlap but be placed neatly below the added textbox.
View 3 RepliesI'm trying to add a new data connection to a SQL Server database that lives out on my network. When I add the new connection I get the "Choose Data Source" dialog but it only contains the following:
Microsoft Access Database File
Microsoft SQL Server Database File
I don't see an option for a remote SQL database. How can I add that option to my list?
Imports System.Reflection
Imports System.Data.SqlClient
Imports PSXSTL.Data.DataAccess
[code]....
How do i generate a new GUID and Add a new "CustomerName" to my table if the GUID doesnt exist.