General Queries

Question

I am very new to C# so sorry if I am fumbling my way through this. I am trying to produce an database insert method for saving contact information on a windows form. I need to know a couple of things: 1. Is there a simpler way to pass in parameters 2. How do I get the next unique id for the table from my oracle sequence in C# 3. How do I pass back the database ID from my combo box value instead of the text value. ===================== private void SaveContact() { string strSQL; int i; string strSurname; string strForename; string strTitle; string strPhone; string strFax; string strEmail; int intBusUnit; int intDiv; int intLoc; int intTeam; strSurname = this.txtSurname.Text.Trim(); strForename = this.txtForename.Text.Trim(); strTitle = this.cboTitle.Text.Trim(); strPhone = this.txtPhone.Text.Trim(); strFax = this.txtFax.Text.Trim(); strEmail = this.txtEmail.Text.Trim(); intBusUnit = this.cboBusUnit.SelectedIndex; intDiv = 1; //this.cboDivision.ValueMember; //SelectedValue intLoc = 1; //this.cboLocation.Text; intTeam = 1; //this.cboTeam.Text; strSQL = "INSERT INTO PERSON (ID,SURNAME,FORENAME,TITLE,PHONE,EMAIL,FAX,DIVISIONID,BUSINESSUNITID, LOCATIONID, TEAMID)"; strSQL += "VALUES (20,'"+strSurname+"','"+strForename+"','"+strTitle+"','"+strPhone+"','"+strEmail+"','"+strFax+"',"+intDiv+","+intBusUnit+","+intLoc+","+intTeam+")"; try { // Create database Connection DataProvider.DataProvider provider; Utilities objUtil = new Utilities(); string strConnectionString = objUtil.GetConnectionString(); provider = new DataProvider.DataProvider(strConnectionString,DataProvider.DataProvider.DBType.OleDb); // Execute the insert i = provider.ExecuteNonQuery(strSQL); MessageBox.Show ("New Contact Saved.", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); } finally { MessageBox.Show ("Nice one geezer!", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); } }