TableAdapter更新失败

Question

我正在尝试从tbUsers表中更新userPassword列中的用户密码。

单击“确认按钮”时出现以下错误:对象引用未设置为对象的实例-未处理NullReferenceException

它说我需要实例化一些东西，但我不知道是什么。我已经有了tableAdapter实例化。

感谢您的帮助！

using System.Data;
using System.Data.SqlClient;
using System.IO;
using Library.DataBase.dsLibraryTableAdapters;
using Library.DataBase;    

tbUsersTableAdapter tableAdapterUsers = new tbUsersTableAdapter();
dsLibrary.tbUsersDataTable dataTableUsers;

private void btnConfirm_Click_1(object sender, RoutedEventArgs e)
{
    tbUsersRow = (dsLibrary.tbUsersRow)dataTableUsers.FindByIdPeopleIdUser(value1, value2);
    tbUsersRow.userPassword = txtNewPassword.Password.ToString(); <- ERROR HERE
    tableAdapterUsers.Update(dataTableUsers);
}

Answer 1

好了，这似乎解决了问题。

谢谢大家！

using System.Data;
using System.Data.SqlClient;
using System.IO;
using Library.DataBase.dsLibraryTableAdapters;
using Library.DataBase;    

tbUsersTableAdapter tableAdapterUsers = new tbUsersTableAdapter();
dsLibrary.tbUsersDataTable dataTableUsers;

private void btnConfirm_Click_1(object sender, RoutedEventArgs e)
{
     dataTableUsers = tableAdapterUsers.getDataByUserName(lblUser.Content.ToString());
     tbUsersRow = (dsLibrary.tbUsersRow)dataTableUsers.Rows[0];
     tbUsersRow.userPassword = txtNewPassword.Password.ToString();
     tableAdapterUsers.Update(dataTableUsers);
}