private void button提交_Click(object sender, EventArgs e)
{
SqlConnection thisConnection = new SqlConnection(Properties.Settings.Default.LibraryConnectionString1);
SqlDataAdapter thisAdapter = new SqlDataAdapter("select id from Administrator where id='" + this.textBox18.Text + "'", thisConnection);
SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet, "Administrator");
DataRow findRow = thisDataSet.Tables["Administrator"].Rows.Find["this.textBox18.Text"];
if (findRow != null)
{
findRow.Delete();
thisAdapter.Update(thisDataSet, "Administrator");
}
thisConnection.Close();
MessageBox.Show("删除管理员成功!");
}
当调试时,系统提示 加粗的那行有错误:无法将带[]的索引应用于“方法组”类型的表达式
{
SqlConnection thisConnection = new SqlConnection(Properties.Settings.Default.LibraryConnectionString1);
SqlDataAdapter thisAdapter = new SqlDataAdapter("select id from Administrator where id='" + this.textBox18.Text + "'", thisConnection);
SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet, "Administrator");
DataRow findRow = thisDataSet.Tables["Administrator"].Rows.Find["this.textBox18.Text"];
if (findRow != null)
{
findRow.Delete();
thisAdapter.Update(thisDataSet, "Administrator");
}
thisConnection.Close();
MessageBox.Show("删除管理员成功!");
}
当调试时,系统提示 加粗的那行有错误:无法将带[]的索引应用于“方法组”类型的表达式
Find[this.textBox18.Text];
我在 thisAdapter.Fill(thisDataSet, "Administrator"); 后面添上了
DataColumn[] keys = new DataColumn[1];
keys[0] = thisDataSet.Tables["Administrator"].Columns["name"];
thisDataSet.Tables["Administrator"].PrimaryKey = keys;还是报同样的错!