OleDbConnection  con = new OleDbConnection (@"Network Library=DBMSSOCN;Data Source=10.16.132.1;database=craccount;User id=rameshc;Password=;Vishnu10");
            con.Open();
            int a, j;
            string gender;
                        a = int.Parse(textBox8.Text);
                        if ( radioButton1 .Checked == true )
                            gender = "male";
                        else
                            gender = "female";
                        MessageBox.Show(a.ToString());
                        if (a > 1000)
                        {
                            OleDbCommand  cmd = new OleDbCommand ("select *from bankinfo,con");
                            cmd.CommandType = CommandType.Text;
                            cmd.CommandText = "insert into account values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + gender + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox8.Text + "')";
                            j = cmd.ExecuteNonQuery();
                            con.Close();
                        }
                        else
                        {
                            MessageBox.Show("No Sufficent data");
                        }

 string str = MyProject.Properties.Settings.Default.dbnameConnectionString;
sqlconnection conn=new sqlconnection(str);

class sqlconnection
    {
        SqlConnection myconcection;
 
 
        private void getConnection()
        {
            String connstring = "";//your connection string
            SqlConnection myconcection = new SqlConnection(connstring);
        }
 
 
       // method to get data
        public DataSet getData(String sql)
        {
            getConnection();
 
            SqlDataAdapter adptre = new SqlDataAdapter();
            DataSet resultSet = new DataSet();
 
            SqlCommand sqlcmd = new SqlCommand(sql, myconcection);
            adptre.SelectCommand = sqlcmd;
            myconcection.Open();
            try
            {
                adptre.Fill(resultSet);            
            }
 
            catch(Exception ex)
            {
 
            }
            myconcection.Close();
            return resultSet;
        }
        // method to add data
        public void setData(string sqlcmd)
        {
            getConnection();
            myconcection.Open();
 
            string sqlcommand = sqlcmd;
            SqlCommand cmd = new SqlCommand(sqlcommand, myconcection);
            cmd.ExecuteNonQuery();
            myconcection.Close();
        }
 
    }