Database update

[mce]

I have the following codes to update some data in the sql database. The dataset seems to be updated, but when i close the application and check the database, non of the value there is updated. What had i missed out here?

Random m_random;
        SqlDataAdapter m_sqlAdapter;
        DataSet m_Dataset;
        SqlConnection m_sqlConn;
        SqlCommandBuilder m_sqlCommandBuilder;

         string strConn = Properties.Settings.Default.testConnectionString.ToString();
            m_sqlConn = new SqlConnection(strConn);
      
            m_sqlAdapter = new SqlDataAdapter("SELECT * FROM Table1",m_sqlConn);
            m_sqlCommandBuilder = new SqlCommandBuilder(m_sqlAdapter);

         
            m_Dataset = new DataSet();  
         
            //m_sqlAdapter.SelectCommand = new SqlCommand("select * from Table1",m_strConn);
            m_sqlAdapter.Fill(m_Dataset,"Table1");


   foreach (DataRow dr in m_Dataset.Tables["Table1"].Rows)
            {
                int nRandom = 0;
  
                dr["Analog1"] = m_random.Next(100);
                
                m_sqlAdapter.Update(m_Dataset, "Table1");
                m_Dataset.AcceptChanges();
                 
            }