Random random = new Random();
            int num = random.Next(10000000);
            string numy = num.ToString();

            string connectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=cms;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
            SqlConnection connection = new SqlConnection(@connectionString);
            string query = "INSERT INTO users (ID,Password) VALUES('"+numy+"','01')";
            SqlCommand command = new SqlCommand(query, connection);
            try
            {
                connection.Open();
                command.ExecuteNonQuery();
                MessageBox.Show("Records Inserted Successfully");
            }
            catch (SqlException x)
            {
                MessageBox.Show("Error Generated. Details: " + x.ToString());
            }
            finally
            {
                connection.Close();
            }