You need to reference the .text property. I.e. this.testBox1.text = "some string" In your case it would be... this.tblInvoiceTableAdapter.UpdateQuery(owner_NameTextBox.Text,owner_AddressTextBox.Text,owner_CityTextBox.Text,owner_StateTextBox.Text,owner_ZipTextBox.Text);

//this should answer your question string connStr = "Fill in your connection string here"; string sqlStr = "SELECT * FROM someTable"; System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connStr); System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sqlStr, conn); System.Data.DataSet ds1 = new DataSet("test"); System.Data.DataTable dt1 = ds1.Tables["someTable"]; int rowCount = dt1.Rows.Count; //or a good use is for(int i=0; i< dt1.Rows.Count; i++) { //do something } //or another foreach (System.Data.DataRow dr1 in dt1.Rows) { //Do something else }