using System.Data.SqlClient; using System.Data.OleDb; code for connecting to SQL database:- try { SqlConnection mc = new SqlConnection(Persist Security Info=False;User ID=sa;Initial Catalog=DataBase_Name;Data Source= SQL_Server_Name"); SqlDataAdapter da =new SqlDataAdapter("Select * from Table_name", mc); DataSet ds =new DataSet(); da.Fill(ds,"Table_name"); MessageBox.Show("Connection Successfull"); } catch(Exception ex) {MessageBox.Show(ex.Message); } code for inserting data from textBox:- try{ SqlCommand insertCmd=new SqlCommand("insert into Table_Name(Column_Name)values(@Variable_name)",Connection_Name); insertCmd.Parameters.Add("@Variable_Name",SqlDbType.Nchar,10); insertCmd.Parameters["@Variable_Name"].Value=textBox1.Text; insertCmd.ExecuteNonQuery(); MessageBox.Show("Records inserted successfully"); } catch(Exception ex) {MessageBox.Show(ex.Message);}