![vb net 2010 pdf vb net 2010 pdf](https://i.ytimg.com/vi/TU5BZEoQOG8/maxresdefault.jpg)
Now in the IDE, sehow code for the form, in the upper-left hand corner of the editor select CustomerBindingSource. One method for adding a new row inĪdd a Button and add the code below CustomerBindingSource.AddNew() The following project which has loading and saving data but not inserting a new row. Am now learning to code and on my first project as a an upcoming programmer. I accepts any mistake that might occur, in good faith. this my first time of posting a serious question with a code. MsgBox("Weekly Forecast created successfull")
![vb net 2010 pdf vb net 2010 pdf](https://i.stack.imgur.com/PMGt1.png)
& "','" & WeekEndingTextBox.Text & "','" & TopicTextBox.Text & "','" & ReferenceMaterialsTextBox.Text & "','" & TeachingLearningMaterials_TLMTextBox.Text & "','" & RemarksTextBox.Textĭim Command As New OleDbCommand(query, connection) Using connection As New OleDbConnection(connectionstring)ĭim query As String = "INSERT INTO tblLessonPlan (Week,WeekEnding,Topic,ReferenceMaterials,TeachingLearningMaterials_TLM,Remarks) VALUES('" & WeekComboBox.Text Me.myDA.Update(TLPDatabaseDataSet, "tblWeeklyForecast") Private Sub btnSaveForecast_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSaveForecast.Click I tried using some the codes below but any time I input data, and click save, it does nothingĭim connectionstring As String = "Provider=.4.0 Data Source=|DataDirectory|\TLPDatabase.mdb"ĭim connection As New OleDbConnection(connectionstring) I have a problem using the command button to save data into an underlying database in MS Access, and display it in a data grid view.