Hi, I hope to create a XML file that will hold my Connection data to a SQL Db.
I want to write an XML file from 4 Text Box named UserName, Password,
Database & Server and later read from it. My XMLSchema elements are named
dbLogin, dbPassword, dbDatabase & dbServer
I receive a 'System.NullReferenceException Info: Object refernece not set to
an instance of an object' on the following line of code: dtSettings =
Settings.Tables("Settings")
My Code:
Private Sub btnApply_Click(....
Dim dsSettings As DataSet
Settings = New DataSet
Settings = dsSettings
Dim dtSettings As New DataTable
dtSettings = Settings.Tables("Settings")
UserName.DataBindings.Add("Text", dtSettings, "dbLogin")
Password.DataBindings.Add("Text", dtSettings, "dbPassword")
Database.DataBindings.Add("Text", dtSettings, "dbDatabase")
Server.DataBindings.Add("Text", dtSettings, "dbServer")
Dim drNewRow As DataRow
drNewRow = dtSettings.NewRow
drNewRow("dbLogin") = UserName.Text
drNewRow("dbPassword") = Password.Text
drNewRow("dbDatabase") = Database.Text
drNewRow("dbServer") = Server.Text
If dtSettings.Rows.Count() > 1 Then
dtSettings.Rows.RemoveAt(0) ' Remove old row for any
previous users
End If
dtSettings.AcceptChanges()
Dim fs As FileStream = New FileStream(SettingsFileName,
FileMode.Create, FileAccess.ReadWrite)
Dim xtw As XmlTextWriter = New XmlTextWriter(fs,
System.Text.Encoding.Unicode)
Settings.WriteXml(xtw, System.Data.XmlWriteMode.WriteSchema)
xtw.Close()
End Sub
Am I approaching this the correct way. I have my schema set up and the