for example:
OdbcConnection connection = new OdbcConnection(MyConnectionString);
OdbcCommand queryCmd;
queryCmd = connection.CreateCommand();
queryCmd.CommandText = "Insert Into cli_detail(cli_Name,cli_Addr,cli_City,cli_State,cli_Country,Phonenumber,Comments,Gender,Dob,Age,Hobbies)values(?,?,?,?,?,?,?,?,?,?,?)";
queryCmd.Parameters.AddWithValue("@Cli_Name", txtName.Text);
queryCmd.Parameters.AddWithValue("@Cli_Addr", txtAddress.Text);
queryCmd.Parameters.AddWithValue("@Cli_City", txtCity.Text);
queryCmd.Parameters.AddWithValue("@Cli_State", txtState.Text);
queryCmd.Parameters.AddWithValue("@Cli_Country", txtCountry.Text);
queryCmd.Parameters.AddWithValue("@Phonenumber",Int32.Parse(txtPhonenumber.Text));
queryCmd.Parameters.AddWithValue("@Comments", txtComments.Text);
if (rdoFemale.Checked)
{
queryCmd.Parameters.AddWithValue("@Gender :" , rdoFemale.Text);
}
else
{
queryCmd.Parameters.AddWithValue("@Gender :" ,rdoMale.Text);
}
DateTime theDate = Convert.ToDateTime(dtpDob.Text) ;
queryCmd.Parameters.AddWithValue("@Dob" ,theDate.ToString("yyyy-MM-dd"));
queryCmd.Parameters.AddWithValue("@Age" ,Int32.Parse(nuAge.Text));
string hobies = "";
foreach (string chk in lstHobbies.SelectedItems )
{
hobies += "," + chk;
}
queryCmd.Parameters.AddWithValue("@Hobbies:", hobies);
var x= queryCmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
LoadData();
}
}
}
private void LoadData()
{
OdbcConnection connection=new OdbcConnection(MyConnectionString);
connection.Open();
try
{
OdbcCommand queryCmd = connection.CreateCommand();
queryCmd.CommandText="select * from table name";
OdbcDataAdapter adap = new OdbcDataAdapter(queryCmd);
DataSet ds = new DataSet();
adap.Fill(ds);
}
catch(Exception)
{
throw;
}
finally
{
if(connection.State==ConnectionState.Open)
{
connection.Close();
}
}
}