试题出自试卷《02275《计算机基础与程序设计》真题及参考答案（2023.04）》

将下列事件程序补充完整，使得程序运行后，单击“显示”按钮，将d:\abc.mdb数据库中txl表的数据显示在dgvTxl控件中。运行情况如题图所示。

题图

private void button1_Click(object sender, EventArgs e)
{
OleDbConnection myconn = new OleDbConnection();
string mystr = "Provider = Microft.Jet.OLEDB.4.0; Data Source = d:\abc.mdb";
myconn.ConnectionString = mystr;
myconn.Open();
string mysql = "SELECT姓名,性别,联系电话 FROM txl ORDER BY 性别";
OleDbCommand mycmd = new OleDbCommand(mysql,mycon);
OleDbDataAdapter da = new OleDbDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = mycmd;
OleDbCommandBuilder builder = new OleDbCommandBuilder(da);

da.           (ds, "txl"); //  (1)
dgvTxl.         = ds.Tables[0]; //  (2)
myconn.Close();
}