find items, they get added to your inventory. But the problem is is that what you have say like 3 items in your inventory, and you close the application, all the items will go away because there's no way to save. So how would I make like the program to where it saves like a .DLL file (preferably .DLL not .TXT so users cant edit easy)? Is there a way to do this like maybe when they get an item, it
View 8 Replies
I need a simple program which add,edit,save,delete data from database in vb.net. I have tried dataset or sqlcommandbuilder but both are not working. look at my code I have used with sqlcommandbuilder, it is not saving anything in database. provide simplest method to save data in database from dataset or direct from textbox. In this vb.net is not showing any error but not saving
'set up a connection string'
Dim connectionstring As String
connectionstring = "Data Source=|DataDirectory|inventorymanage.sdf;Password='XXX'"
Dim sqlquery As String = "SELECT * FROM ledger"
[Code].....
I created a database in access 2007, linked it to my project in visual studio 2008 (vb). When I enter some data using the UI, it does not save it in the database, and it's gone as soon as I run the program again. I dragged the textboxes from the datasource panel, onto the UI..
this is the code that was automatically generated by vs for the save button:
Private Sub StaffBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StaffBindingNavigatorSaveItem.Click
Me.Validate()
Me.StaffBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.GartisDataSet)
End Sub
I am a beginner in VB and I have a school project using VB 2008. I created a save button in vb but it cant save to Access 2007
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
[code].....
i m using fallowing code for update, delete and save data it's working very well when i save new recored but when i update and delete recored it's showing error message "Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information."
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If thismode = 0 Then
row = ds.Tables("state").NewRow()
row.Item("state") = TextBox1.Text
[code].....
I'm currently attempting to save data inputed into a data grid clicking the "save" button. My problem is, I also have another DB opened in the same window that also needs to be saved. The second database is pulled up by the contents of a text box, so there for it has no real Dataset to call on. It looks something like this.
[Code]...
I try to run the update command it always throws the exception "Cannot find table 0" or "Update unable to find TableMapping['Table'] or DataTable 'Table'." I tried declaring the connection the same way as the code above and then simply calling the da.update(ds) but it wouldn't do anything.
i am writing a mobile application to save some task. In this application i want save the data of task to the text file(*.txt). however, i faced some of the issues that i unable to save data to txt file due to the runtime error on file not exist but i have checked it and the txt file is existed. [Code]
View 10 RepliesI am using MS Access 2007 as database and VB 2008 to build an application to show the content of 2 tables as a single table.I have two tables in MS Access and i have linked both the tables using "ID" as primary key(1st Table),foreign key(2nd Table). I used Query Wizard to show the data of both tables in a single table(3rd Table).I am able to view the content of all 3 tables using datagridview in vb 2008(Using Code), but i am unable to add,delete,save and search the content of the table using code. My concern is,i will be able to do all these operations using codes only.Would you please help me out in this.
View 5 RepliesI have a gridview with four template fields that I need to be able to put info into to save to the database. When I hit the edit button and my columns change into edit mode I can enter information just fine. But when I try to loop through the control to get the information it doesn't pick anything up?
Private Sub gvOLIAdj_RowEditing(sender As Object, e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles gvOLIAdjst.RowEditing
gvOLIAdjst.EditIndex = e.NewEditIndex
BindData()
End Sub
Here is the update event that I have so far... any ideas? Am I just not doing this right?
Private Sub gvOLIAdj_RowUpdating(sender As Object, e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles gvOLIAdjst.RowUpdating
Dim dts As DataTable = DirectCast(Session("BudgetsTable"), DataTable)
Dim row As GridViewRow = gvOLIAdjst.Rows(e.RowIndex)
[Code]...
My problem is probably ignorance as to how the DGV works, anyway, the problem.I have a bound datagridview which is used to collect user input. Data for 3 of the 7 fields is entered by looping through the rows and progmatically entering common data anfter a 'Save' Button is pressed:
For I = 0 To DG1.RowCount - 2DG1.Rows(I).Cells(4).Value = TextBox1.Text 'OperatorDG1.Rows(I).Cells(5).Value = TextBox2.Text 'DateDG1.Rows(I).Cells(6).Value = TextBox3.Text 'Time NextDG1.Update Prior to this loop I delete the last unused row if its not a new row:
DG1.CurrentCell = DG1.Item(0, DG1.RowCount - 2)If DG1.CurrentCell.Value.ToString = "" ThenDG1.Rows.RemoveAt(DG1.RowCount - 2)DG1.Update()End If
At this point the DGV looks the way it should...All fields completed correctly and no un used ro except for the new row.
After saving :Me.ItemTableTableAdapter.Update(Me.StockMoveDataSet.ItemTable)The 'Operator', 'Date', and 'Time' are not saved to the database for the first row only I have tried EndEdit, Update, refocussing the currentcell/row all to no avail.
I cant able to save an excel file from VB.NET.
I used the code below:
SaveFileDialog1.Title = "Save Excel File"
SaveFileDialog1.Filter = "Excel files (*.xls)|*.xls|Excel Files (*.xlsx)|*.xslx"
SaveFileDialog1.ShowDialog()
[Code]....
Error occurred in the highlighted line as "Exception from HRESULT: 0x800401A8". I cannot analyse the cause for this error. because in before case it works fine for the same code i used.
I am opening an excel workbook, saving it under a new name, then run a macro on it from personal.xls, then resaving it over this new file.
Then I try to immediately resave again asa third name and it fails
Here is the code:
' Start Excel and get Application object.
oXL = CreateObject(
"Excel.Application")
oXL.Visible =
[Code].....
"The file could not be accessed. Try one of the following: - Make sure the specified folder exists. - Make sure the folder that contains the file is not read-only. - Make sure the file name does not contain any of the following characters: < > ? [ ] : | or * - Make sure the file/path name doesn't contain more than 218 characters."
well i am using visual basics express and i cant seem to be able to save the file as an application [exe file]. i have created a program for my friend and i want to start to us it does eny one have eny ideas???
View 4 RepliesFirst of all I am using vb.net(2008) and i have an application which connects to a database and is able to modify it.
My problem is that when I modify a row and try save, It doesnt save to the database although when I add a new record it does save.
Code I use to Save
Me.Validate()
Me.MessagesBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.ServerDataSet)
[Code].....
PS: When I Delete the row it works but when I try updating the database by saving it it doesnt work. Is the Database row event handler able to help my case?
I posted this in the database development section but i didn't get a reply after a day or so
the below code is use for my website to insert photos, On my compouter, i can insert pics but when i transfer it to the remote machine, i get error message. Here is the code:
Protected Sub dvPictureInsert_ItemInserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewInsertedEventArgs) Handles dvPictureInsert.ItemInserted
'If the record was successfully inserted, save the picture
If e.AffectedRows > 0 Then
[code]...
i want to save String in File Who not Able to open in Text Editor Open it Only on my Application Suposly i want to save Phone Book Contact In this file
Three Text Boxes
1. Name
2. Phon Number
3. @mail Address
i already read these stuff but still not Understand i already check Kaymaf Provided link , but i m not understand Create Your Own Custom File Type
I want to be able to save a score then have it print out in a text box to prove it is saving.. Here's what i have outText = IO.File.CreateText("final.txt")
[Code]...
I have an asp.net web forms application. In this application, students upload assignments and submit a survey along with it. For the survey, I read values from DB and dynamically generate ASP.NET Controls like radiobuttonlist, checkboxlist, textbox on the form during gridview's RowDataBound Event. I cannot do it in Page_Init method because I create only if a user click on a specific assignment which requires a survey to be submitted.
When I submit the survey form, the survey values are not saved into database. During debugging I figured it out that the values are not available in the codebehind page. The radiobuttonlist.selectedvalue returns and I get following error[code]....
modify code to insert the data to MS SQL and save changes when click save button for the second time?
View 14 Replieshow to code for the save button in vb.net datagrid view by using insert into sql and update sql statements (it should be able to insert & update the data grid and save the changes) when the save button is clicked .
View 2 RepliesHow to save all the data displayed in DataGridview( 2 column, no primary key) and have a button and
View 7 RepliesI am working on desktop application. I had created number of dynamic textbox and label and I want to save that data on clicking the save button.
View 4 Repliesin my form i have 4 textboxes and i want all not to be empty while saving the data.I have put condition in save button,when user presses the save button to save data, to check all the textboxes not to be empty. My question is that, i want to focus to that particular textbox which is empty during saving the data.
For example: i have txt1,txt2,txt3,txt4 as textboxes in the form if txt1 is empty while saving, the focus should switch to txt1 rather user himself have to go there.
how to save data (for example some text that user type [as password etc]) and save that password on same location where is application. After saving I want to have also Load option so we can load saved data.
View 7 Replieswhen I tried to add a new data source using the wizard. But after connection has been tested succesfully ,I get this error message:could not load type 'microsoft.visualstudio.data design.sync designer.sync facade.sync manager from assembly 'Microsoft.VisualStudio.DataDesign.SyncDesigner.DslPackage,
View 2 Repliesthis is my coding when i run this coding for display "Procedure or Function 'sp_developer_display' expects parameter '@developerid', which was not supplied."
this error will display
my sp in sql express is
ALTER PROCEDURE dbo.sp_developer_display
[code].....
When trying to create a new data source to a sql database (database up and running with no problems) I get the following error message when testing the database connection
Quote:
Unable to open the physical file "". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
tell what 'visual' designer was used when developing an existing a VB.net 2008 desktop application? What do I click on to tell what 'visual' designer was used? Also once I know what visual designer was used, can you point me to a url to tell me how to use that visual designer? need to change some of the tables behind an existing desktop application. Basically some of the production tables will be changing. The users want to keep the existing desktop (gui) interface since they like it alot.
View 1 RepliesI have a Lightswitch application that is running fine, connects to the database and shows the data just fine. I am trying to write another one using the same database but I get the error "Unable to load data". I can't find anything I've done differently with this application. I can connect to the database in the development window and see the data by using the View/Server Explorer and show table data.
View 3 RepliesI am unable to add data in my listbox its showing in msgbox but did not add in listbox i try using richtextbox but again same prob.[code]...
View 3 Replies
