My friend and I have 4 weeks to make a program in VB.net that will assist a teacher in some way.We have decided on a program that stores data and can record marks, attendance and calculate the data.We used a module from: url.... to Import the excel file and display the data. How do i actually edit the data? I want to first use a bubble sorting algorithm to sort and give the students a rank.
View 1 RepliesI have a form that adds new contacts. New contacts are added by pressing an appropriate button and they appear as an entry in the list on the form. I try now to add an edit button that will edit existing entries.User will select a given entry on the list and press edit button and will be presented with an appropriate form (AddContFrm).Right now it simply adds another entry with the same title. Logic is handled in a class called Contact.vb Here is my code.
Public Class Contact
Public Contact As String
Public Title As String[code]....
After reading data from an Excel spreadsheet, I wish for the user to have the option to change one or more variable values. I am encountering two key problems:
1) I cannot change the value given the code below:
Private Sub TextBox2_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox2.TextChanged, TextBox2.VisibleChanged
Dim aircontent As String
[Code].....
how to display data in grid view using code that you can edit, update and delete the data...do i need to have a stored proc in this?
View 4 RepliesI am coding in Visual Basic. I am using a checkbox control. Now depending on its checked property I need to set/unset a bit column in a SQL Server database. Here's the code:
Try
conSQL.Open()
Dim cmd As New SqlCommand("update Student set send_mail = " + _
[Code].....
The send_mail attribute is of bit datatype. This code is not working.
i have an error is Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index how to rectify this.any one help me.
Try
If (conn.State = ConnectionState.Closed) Then
conn.Open()
End If
[Code].....
i have a problem with editing data in datagridview in vb.net 2005
View 2 RepliesI have a datagridview that is bound to a Dataset I have created. My question is, how hard is it to be able to edit/add data to these rows? It looks as though the Dataset is actually a query of somesort (which you obviously can't edit) Is there a way to link directly to the table for editing? I know you can do this using queries, etc... but I'm thinking there should be an easier way.
View 2 RepliesI am using following data to add new data to my table enter code here
Me.TblResultTableAdapter.Fill(Me.DbResultDataSet.tblResult)
Dim drNewRowEditSummary As DataRow drNewRowEditSummary = DbResultDataSet.tblResult.NewRow drNewRowEditSummary.Item(1) = "Test"
DbResultDataSet.tblResult.Rows.Add(drNewRowEditSummary)
TblResultTableAdapter.Update(DbResultDataSet.tblResult)
How can I edit my data using similar method as above?
how do i add columns to a listbox??
And Checkedlistbox add and edit more than 1 data per item. So if you take a look at Cheat engine it got 3 data per row. 1: the checkbox, 2: the item name and 3 the value i want to change if i doubleclick (all this in same row)
So if you take a look at A cheat engine Video at you tube you can see the checked listbox that you can freeze things and change values so more thann 1 data.
I create receive item form that contained
Doc_id ,
Doc_date
And Data Grid View:
Item_id ,
Item_Name ,
Item_Qty ,
Item_Cost
I use this code to update data in datagridview
For R As Integer = 0 To ReceiveGrid.Rows.Count - 2
GridcmdUpdate.Parameters.AddWithValue("@DocId", TbxCode.Text)
GridcmdUpdate.Parameters.AddWithValue("@DocType", "ST_REC_VOU")
[code]....
I'm trying to edit the data of a column. I load the column in textboxes and let the user edit the fields. But now to insert it, I know I can delete the column and add a new one, but couldn't I just overwrite the data in the column?
[Code]...
I used a table adapter to fill a data table from a sql database.then made the datatable the source to a datagridview.how do i change data in the datatable, and how do i save it back to the sql database.
View 1 RepliesI want to edit the data into the ListView of the first item. when i right click on item..But when i right click selected item not come in edit mode....Plz check it out..
Code: Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
For lcount As Integer = 1 To 3
ListView1.Items.Add(lcount.ToString, lcount - 1)
Next
End Sub
Private Sub ListView1_MouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles ListView1.MouseClick
[Code]...
I can add new/delete info to data, but cannot update/edit, I have tryd everything that I could, but no luck on my side, I have put txt file of my page.
View 5 RepliesI have unformatted text in my SQL 2005 database. I'm pulling it into a masked edit text box with a (999)999-9999 mask.Unfortunately, when I attempt to save the data back it doesn't work because I don't know how to get the 'masked' information back to the 'unmasked' raw data that the database wants.
View 4 RepliesIn my web application, i have an XML file called "answers.xml"
it store the user entries in XML[code]...
i can add data to the XML file using a DLL file i downloaded from the internet.
i need a way to change the data (edit / delete) in the xml file using ASP.net / VB.net or C#
I just need to edit one field on a datarow and save the changes back to the database. My database is SQL Compact 3.5
I tried many methods but change is not saved to database.
Me.taSet.Fill(Me.Dsset.tblQuestions)
Dsset.tblQuestions.Rows(1).BeginEdit()
Dsset.tblQuestions.Rows(1).Item("ExamID") = "EDITED"
Dsset.tblQuestions.Rows(1).AcceptChanges()
taSet.Update(Dsset.tblQuestions)
I'm trying to create a Library System in VB 2010 which is connected to a 2007 MS Access Database manually. I was successful to create a "Search" button where it displays content from the database based on the user's entries on several text boxes.
The result is shown on a Data Grid which I set to allow Editing on it. My problem now is I can't find a way to create an "Edit" button. My idea is basically allow the user to search, let the result be shown on the data grid, edit the data grid, and click the Edit button to save the updated records back to the database.
My question is it possible to create such button? Here is the code that I use to connect to the data base for the Search button.
[CODE...]
My code is this:
Me.Validate()
Me.CFTINVENTORYBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(CFTDataSet)
At first I can insert data into the cells and save it... but when I try to edit the same cell with data already saved in it I get this error...
sqlcelexception was unhandled
There was an error parsing the query.
[ Token line number = 2,Token line offset = 29,Token in error = , ]
I also get the same error when deleting an already saved cell with data.
How insert , Edit and update data in datagrid? Im using visual basic 2008 express.
View 3 Repliesi have problem with my button edit, after i make change in the data then i click edit button to save all the data. After that i check again the data is not changing and still the same. This code here can run and don't have any error but cannot save the data which i changed [Code]
View 1 RepliesI have a DataGridView and i binded its datasource to the datatable.Now i want to edit and delete the data from the datagridview in this way:I did this in asp.net and now i want to do the same in the vb.net.What i want to do is that each dataGridView row will contain two link button called edit and delete(in the above figure they are the imagebuttons of asp.net),when i will click the edit link button then it will change to update and cancel link buttons and the contents of that particular row will be shown in textboxes so that the row can be edited by the user.
View 8 RepliesI want to edit the data into the ListView of the first item. when i right click on item..But when i right click selected item not come in edit mode...
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
For lcount As Integer = 1 To 3
ListView1.Items.Add(lcount.ToString, lcount - 1)
[code]....
I have Visual Studio 2010 and wish to create something which will store assets and serial numbers. I have an access datatbase which is where all of the data is currently stored however I wanted to make it easy for people to add/remove and edit assets by using a GUI which pulls data to a from the database. What is the best way for me to go about doing this and where should I start?
View 7 Repliesi have a problem with my data gridview i want to edit selected record in datagrid but i am facing some problem here is the code
[Code]...
How to allow duplicate,orif I enter a duplicate, to display Msgbox.
View 2 RepliesPrivate cs As New SqlConnection("Data Source=ANKIT-PC;Initial Catalog=mrks_analysis;Integrated Security=True")[code]...
i want that the Sno field to become non editable + and the rest rows i want a combobox from which user selects the data and which gets stored in db.
in my application i have to print some data on alrady printed forms...for example: i have print on a BANK CHEQUE.
Now my problem is that these forms are printed differently and different bank have different check but all have the same data..and to meet this requirement printing need to be ajusted for eg i might need one colom two place down or left or right.. so i need a printing tool in which i can edit the location of printing meterial i mean take them few places left or right and adjust them as my requirement.i have used crystal reports and ms reports at very basic level but what i have found is that i can not edit design move drag etc from the application..
save, edit and delete files in the data grid.
View 1 Replies